ss
Tables (3)
Keyword
- id — VARCHAR(36)
- voice_note_id — VARCHAR(36) — Foreign key → VoiceNote.id — NOT NULL
- word — VARCHAR(100) — NOT NULL
TranscriptSegment
- id — VARCHAR(36)
- voice_note_id — VARCHAR(36) — Foreign key → VoiceNote.id — NOT NULL
- start_time — DECIMAL(10, 2) — NOT NULL
- end_time — DECIMAL(10, 2) — NOT NULL
- text — TEXT — NOT NULL
- speaker_id — VARCHAR(50)
VoiceNote
- id — VARCHAR(36)
- title — VARCHAR(200) — NOT NULL
- creation_date — DATETIME — NOT NULL
- duration — DECIMAL(10, 2) — NOT NULL
- audio_file_path — VARCHAR(500) — NOT NULL
- status — INTEGER — NOT NULL
- progress — DECIMAL(3, 2)
- error_message — TEXT
- summary — TEXT