Query
CREATE TABLE commitments (
entity_id TEXT PRIMARY KEY,
scope TEXT,
desired_outcome TEXT,
constraints TEXT,
deadline TEXT,
recurrence TEXT,
importance REAL DEFAULT 0.0,
acceptance_criteria TEXT,
status 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
)