17 lines
564 B
SQL
17 lines
564 B
SQL
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
|
|
);
|