CREATE TABLE decisions (
    id TEXT PRIMARY KEY,
    statement TEXT,
    lifecycle_state TEXT,
    role_exposure TEXT,   -- JSON
    tags TEXT,            -- JSON array
    timestamp DATETIME
);

CREATE TABLE edges (
    source_id TEXT,
    target_id TEXT,
    relation TEXT,
    PRIMARY KEY (source_id, target_id)
);

CREATE TABLE constraints (
    id TEXT PRIMARY KEY,
    scope TEXT,           -- "global" or "role:<role>"
    description TEXT
);
