CREATE TABLE IF NOT EXISTS work.development_gates (
  gate_id TEXT PRIMARY KEY,
  revision BIGINT NOT NULL CHECK (revision > 0),
  updated_at_unix_millis BIGINT NOT NULL CHECK (updated_at_unix_millis > 0),
  stage TEXT NOT NULL,
  evidence_refs TEXT[] NOT NULL,
  proposal_ref TEXT NOT NULL,
  task_packet_ref TEXT NOT NULL,
  worktree_ref TEXT NOT NULL,
  producer_run_refs TEXT[] NOT NULL,
  verifier_run_refs TEXT[] NOT NULL,
  verification_evidence TEXT NOT NULL,
  canary_evidence TEXT NOT NULL,
  promotion_ref TEXT NOT NULL,
  rollback_ref TEXT NOT NULL
);