Query

event_store.db — inbox_links

SQL

CREATE TABLE inbox_links  (
  inbox_id TEXT NOT NULL,
  entity_id TEXT NOT NULL,
  link_type TEXT NOT NULL DEFAULT 'about',
  PRIMARY KEY (inbox_id, entity_id, link_type),
  FOREIGN KEY (inbox_id) REFERENCES inbox_items(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
inbox_id TEXT ✓ Rename | Drop
entity_id TEXT ✓ Rename | Drop
link_type TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
entity_id entities.id
inbox_id inbox_items.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_inbox_links_entity entity_id SQL 
CREATE INDEX idx_inbox_links_entity
ON inbox_links (entity_id)
Drop
idx_inbox_links_inbox inbox_id SQL 
CREATE INDEX idx_inbox_links_inbox
ON inbox_links (inbox_id)
Drop
sqlite_autoindex_inbox_links_1
  • inbox_id
  • entity_id
  • link_type
 ✓ SQL
-- no sql found --
 Drop