audit-labs/gh-attest
GitHub Audit Evidence Extractor
clone: git clone https://gitbay.org/audit-labs/gh-attest.git
main: migrations/0004_exports.sql · raw
1CREATE TABLE exports (
2 id TEXT PRIMARY KEY, -- uuid
3 installation_id INTEGER NOT NULL,
4 framework TEXT NOT NULL, -- 'soc2' | 'iso27001' | 'all'
5 format TEXT NOT NULL, -- 'csv' | 'pdf'
6 status TEXT NOT NULL, -- 'queued' | 'processing' | 'done' | 'error'
7 r2_key TEXT, -- null until rendered
8 error TEXT, -- populated on failure
9 created_at TEXT NOT NULL,
10 completed_at TEXT,
11 FOREIGN KEY (installation_id) REFERENCES installations(installation_id)
12);
13
14CREATE INDEX idx_exports_installation ON exports(installation_id, created_at);