create type actor_kind as enum ('application', 'group', 'organization', 'person', 'service');

create table profile (
  ap_id text primary key,
  username varchar(15),
  description varchar(255),
  inbox text not null,
  role actor_kind not null default 'person',
  outbox text,
  picture text,
  public_key text not null,
  private_key text,
  created_at timestamptz not null default now(),
  last_refreshed_at timestamptz not null default now()
)