Query
CREATE TABLE constraints (
entity_id TEXT PRIMARY KEY,
applies_to TEXT NOT NULL,
condition TEXT NOT NULL,
enforcement_level TEXT NOT NULL,
action_tier TEXT,
exceptions TEXT,
rationale TEXT,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED
)