해커톤

테이블 (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