SQL

CREATE TABLE audio_tags  (
  audio_chunk_id INTEGER NOT NULL,
  tag_id INTEGER NOT NULL,
  PRIMARY KEY (audio_chunk_id, tag_id),
  FOREIGN KEY (audio_chunk_id) REFERENCES audio_chunks(id) ON DELETE CASCADE,
  FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)

Columns

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

Foreign Keys

Column Destination
tag_id tags.id
audio_chunk_id audio_chunks.id

Indexes

Name Columns Unique SQL Drop?
idx_audio_tags_audio_chunk_id audio_chunk_id SQL 
CREATE INDEX idx_audio_tags_audio_chunk_id
ON audio_tags(audio_chunk_id)
read-only
idx_audio_tags_tag_id tag_id SQL 
CREATE INDEX idx_audio_tags_tag_id
ON audio_tags(tag_id)
read-only
sqlite_autoindex_audio_tags_1
  • audio_chunk_id
  • tag_id
 ✓ SQL
-- no sql found --
 read-only