신기플
테이블 (5)
audio_files
- id — UUID — 기본 키 — NOT NULL
- study_session_id — UUID — 외래 키 → study_sessions.id — NOT NULL
- storage_key — TEXT — NOT NULL
- original_filename — VARCHAR(255)
- mime_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT
- duration_seconds — NUMERIC(10, 3)
- created_at — TIMESTAMP — NOT NULL
evaluations
- id — UUID — 기본 키 — NOT NULL
- transcription_id (id2) — UUID — 외래 키 → transcriptions.id — NOT NULL
- audio_file_id (id22) — UUID — 외래 키 → transcriptions.audio_file_id — NOT NULL
- study_session_id — UUID — 외래 키 → study_sessions.id — NOT NULL
- accuracy_score — NUMERIC(5, 2) — NOT NULL
- coverage_score — NUMERIC(5, 2) — NOT NULL
- structural_score — NUMERIC(5, 2) — NOT NULL
- total_score — NUMERIC(5, 2) — NOT NULL
- pass_status — VARCHAR(2) — NOT NULL
- evaluation_json — JSONB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
study_sessions
- id — UUID — 기본 키 — NOT NULL
- user_id — UUID — 외래 키 → users.id — NOT NULL
- lecture_id — VARCHAR(100) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- hint_used — BOOLEAN — NOT NULL
- started_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
transcriptions
- id — UUID — 기본 키 — NOT NULL
- audio_file_id (id2) — UUID — 외래 키 → audio_files.id — NOT NULL
- study_session_id — UUID — 외래 키 → study_sessions.id — NOT NULL
- raw_text — TEXT — NOT NULL
- corrected_text — TEXT — NOT NULL
- stt_model — VARCHAR(100) — NOT NULL
- beam_size — INTEGER — NOT NULL
- correction_model — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
users
- id — UUID — 기본 키 — NOT NULL
- kakao_user_id — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(100)
- profile_image_url — TEXT
- created_at — TIMESTAMP — NOT NULL
- last_login_at — TIMESTAMP