Add Column
Current Schema
CREATE TABLE links (
id TEXT PRIMARY KEY,
type TEXT NOT NULL,
from_id TEXT NOT NULL,
to_id TEXT NOT NULL,
valid_from TEXT,
valid_to TEXT,
strength REAL,
rationale_event_id TEXT,
FOREIGN KEY (from_id) REFERENCES entities(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED,
FOREIGN KEY (to_id) REFERENCES entities(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED,
FOREIGN KEY (rationale_event_id) REFERENCES events(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)