SQL

CREATE TABLE meeting_transcript_segments  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  meeting_id INTEGER NOT NULL,
  provider TEXT NOT NULL,
  model TEXT,
  item_id TEXT NOT NULL,
  device_name TEXT NOT NULL DEFAULT '',
  device_type TEXT NOT NULL DEFAULT '',
  speaker_name TEXT,
  transcript TEXT NOT NULL,
  captured_at TEXT NOT NULL,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
  FOREIGN KEY (meeting_id) REFERENCES meetings(id) ON DELETE CASCADE,
  UNIQUE(meeting_id, provider, item_id, device_name, device_type)
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
meeting_id INTEGER read-only
provider TEXT read-only
model TEXT ✓ read-only
item_id TEXT read-only
device_name TEXT read-only
device_type TEXT read-only
speaker_name TEXT ✓ read-only
transcript TEXT read-only
captured_at TEXT read-only
created_at TEXT read-only

Foreign Keys

Column Destination
meeting_id meetings.id

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_meeting_transcript_segments_1
  • meeting_id
  • provider
  • item_id
  • device_name
  • device_type
 ✓ SQL
-- no sql found --
 read-only