+/- table definition
Query
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)
)