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()
);

create index user_inbox_idx on profile (inbox);
create index user_outbox_idx on profile (outbox);
create index user_role_idx on profile (role);
create index user_username_idx on profile (username);