1 create table person_block (
3 person_id int references person on update cascade on delete cascade not null,
4 target_id int references person on update cascade on delete cascade not null,
5 published timestamp not null default now(),
6 unique(person_id, target_id)
9 create table community_block (
10 id serial primary key,
11 person_id int references person on update cascade on delete cascade not null,
12 community_id int references community on update cascade on delete cascade not null,
13 published timestamp not null default now(),
14 unique(person_id, community_id)