Add Column
Current Schema
CREATE TABLE event_subjects (
event_id TEXT NOT NULL,
entity_id TEXT NOT NULL,
PRIMARY KEY (event_id, entity_id),
FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED,
FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED
)