create table follow (
  follower_ap_id text not null references profile(ap_id) on delete cascade,
  followee_ap_id text not null references profile(ap_id) on delete cascade,
  followed_at timestamptz not null default now(),
  primary key (follower_ap_id, followee_ap_id)
)
