ERD - 신기플

테이블 (6)

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

auth_sessions

  • id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • session_token_hash — CHAR(64) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

evaluations

  • id — UUID — 기본 키 — NOT NULL
  • study_session_id — UUID — 외래 키 → study_sessions.id — NOT NULL
  • transcription_id — UUID — 외래 키 → transcriptions.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
  • pass_status — VARCHAR(2) — 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
  • study_session_id — UUID — 외래 키 → study_sessions.id — NOT NULL
  • audio_file_id — UUID — 외래 키 → audio_files.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