1차 개발 산출물 ERD

테이블 (8)

audio_recordings

  • id — bigint
  • interview_id — bigint — 외래 키 → interviews.id — NOT NULL
  • file_name — varchar(255) — NOT NULL
  • file_url — text — NOT NULL
  • duration_seconds — int
  • created_at — timestamp

conversation_evaluations

  • id — bigint
  • conversation_id — bigint — 외래 키 → conversations.id — NOT NULL
  • answer_score — tinyint — NOT NULL — 0 ~ 100
  • feedback — text — NOT NULL
  • emotion — varchar(50)
  • created_at — timestamp

conversations

  • id — bigint
  • interview_id — bigint — 외래 키 → interviews.id — NOT NULL
  • question — text — NOT NULL
  • answer — text
  • started_at — timestamp
  • ended_at — timestamp

interview_evaluations

  • id — bigint
  • interview_id — bigint — 외래 키 → interviews.id — NOT NULL
  • total_score — tinyint — NOT NULL — 0 ~ 100
  • feedback — text — NOT NULL — 종합 분석 결과
  • created_at — timestamp

interviews

  • id — bigint
  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • description — varchar(255)
  • position — enum(frontend,backend,fullstack,mobile,devops,data,ai,design) — NOT NULL
  • summary — varchar(255)
  • started_at — timestamp
  • ended_at — timestamp
  • created_at — timestamp

resumes

  • id — bigint
  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • response_id — varchar(255) — NOT NULL — LLM 세션 유지
  • created_at — timestamp

users

  • id — bigint
  • email — varchar(255) — NOT NULL
  • display_name — varchar(255) — NOT NULL
  • average_score — double
  • provider_id — varchar(255) — NOT NULL
  • refresh_token — varchar(255) — NOT NULL
  • created_at — timestamp

video_recordings

  • id — bigint
  • interview_id — bigint — 외래 키 → interviews.id — NOT NULL
  • file_name — varchar(255) — NOT NULL
  • file_url — text — NOT NULL
  • thumbnail_url — varchar(255)
  • duration_seconds — int
  • created_at — timestamp