Query

event_store.db — event_subjects

SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
event_id TEXT ✓ Rename | Drop
entity_id TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
entity_id entities.id
event_id events.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_event_subjects_entity entity_id SQL 
CREATE INDEX idx_event_subjects_entity
ON event_subjects (entity_id)
Drop
idx_event_subjects_event event_id SQL 
CREATE INDEX idx_event_subjects_event
ON event_subjects(event_id)
Drop
sqlite_autoindex_event_subjects_1
  • event_id
  • entity_id
 ✓ SQL
-- no sql found --
 Drop