SQL

CREATE TABLE vision_tags  (
  vision_id INTEGER NOT NULL,
  tag_id INTEGER NOT NULL,
  PRIMARY KEY (vision_id, tag_id),
  FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
  FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)

Columns

Column Data type Allow null Primary key Actions
vision_id INTEGER ✓ read-only
tag_id INTEGER ✓ read-only

Foreign Keys

Column Destination
tag_id tags.id
vision_id frames.id

Indexes

Name Columns Unique SQL Drop?
idx_vision_tags_tag_id tag_id SQL 
CREATE INDEX idx_vision_tags_tag_id
ON vision_tags(tag_id)
read-only
idx_vision_tags_vision_id vision_id SQL 
CREATE INDEX idx_vision_tags_vision_id
ON vision_tags(vision_id)
read-only
sqlite_autoindex_vision_tags_1
  • vision_id
  • tag_id
 ✓ SQL
-- no sql found --
 read-only