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