해커톤
테이블 (6)
AudioFile
- audio_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- file_path — VARCHAR(255)
- duration — FLOAT
- upload_time — DATETIME
- status — ENUM('pending','processing','completed','error')
Script
- script_id — BIGINT — 기본 키 — NOT NULL
- audio_id — BIGINT — 외래 키 → AudioFile.audio_id — NOT NULL
- full_text — LONGTEXT
- created_at — DATETIME
- updated_at — DATETIME
ScriptSegment
- segment_id — BIGINT — 기본 키 — NOT NULL
- script_id — BIGINT — 외래 키 → Script.script_id — NOT NULL
- start_time — FLOAT
- end_time — FLOAT
- text — TEXT
- segment_order — INT
Summary
- summary_id — BIGINT — 기본 키 — NOT NULL
- audio_id (audio_id2) — BIGINT — 외래 키 → AudioFile.audio_id — NOT NULL
- audio_id — BIGINT
- summary_text — LONGTEXT
- created_at — DATETIME
Translation
- translation_id — BIGINT — 기본 키 — NOT NULL
- segment_id — BIGINT — 외래 키 → ScriptSegment.segment_id — NOT NULL
- language_code — VARCHAR(10)
- translated_text — TEXT
- created_at — DATETIME
User
- user_id — BIGINT — 기본 키 — NOT NULL
- username — VARCHAR(50)
- email — VARCHAR(100)
- password_hash — VARCHAR(255)
- role — ENUM('student','admin')
- created_at — DATETIME
- updated_at — DATETIME