Query

event_store.db — entity_tags

SQL

CREATE TABLE entity_tags  (
  entity_id TEXT NOT NULL,
  tag TEXT NOT NULL,
  PRIMARY KEY (entity_id, tag),
  FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

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

Foreign Keys

Column Destination
entity_id entities.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_entity_tags_tag tag SQL 
CREATE INDEX idx_entity_tags_tag
ON entity_tags (tag)
Drop
sqlite_autoindex_entity_tags_1
  • entity_id
  • tag
 ✓ SQL
-- no sql found --
 Drop