-- Document requests from public and donors. Packet-live is recorded as a stadium play.

create table if not exists deal_room_requests (
  id text primary key,
  project_id text not null,
  actor_email text not null,
  actor_role text not null,
  created_at timestamptz not null default now(),
  unique (project_id, actor_email)
);

create index if not exists deal_room_requests_project_idx on deal_room_requests (project_id);
