backend-old

Tables (9)

Behavior Interview Reports (BehaviorInterviewReports)

  • Key (interview_id) — int — Foreign key → Interviews.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Interviews.Key — NOT NULL
  • 점수1 (score1) — int — NOT NULL
  • 종합평가 (summary) — text — NOT NULL

Behavior Interviews (BehaviorInterviews)

  • Key (interview_id) — int — Foreign key → Interviews.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Interviews.Key — NOT NULL
  • 자소서 (cv_url) — String — CV 파일의 S3 URL
  • JD (jd_url) — String — JD 파일의 S3 URL

Coding Interview Reports (CodingInterviewReports)

  • Key (interview_id) — int — Foreign key → Interviews.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Interviews.Key — NOT NULL
  • 점수1 (score1) — int — NOT NULL
  • 종합평가 (summary) — text — NOT NULL

Coding Interviews (CopyOfTechnicalInterviews)

  • Key (interview_id) — int — Foreign key → Interviews.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Interviews.Key — NOT NULL
  • Key (problem_id) — int — Foreign key → Coding Problems.Key — NOT NULL

Coding Problems (CodingProblems)

  • Key (problem_id) — int — Primary key — NOT NULL
  • 난이도 (difficulty) — varchar(10) — NOT NULL
  • 문제 (problem) — TEXT — NOT NULL

Interviews

  • Key (interview_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Users.Key — NOT NULL
  • 종류 (interview_type) — varchar(10) — NOT NULL
  • 면접관 스타일 (interviewer) — JSON — NOT NULL — 면접관 성별, 스타일 등을 기록
  • 생성시점 (created_at) — Timestamp — NOT NULL

Techinal Interviews (TechnicalInterviews)

  • Key (interview_id) — int — Foreign key → Interviews.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Interviews.Key — NOT NULL
  • 자소서 (cv_url) — String — CV 파일의 S3 URL
  • JD (jd_url) — String — JD 파일의 S3 URL

Technical Interview Reports (TechnicalInterviewReports)

  • Key (interview_id) — int — Foreign key → Interviews.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Interviews.Key — NOT NULL
  • 점수1 (score1) — int — NOT NULL
  • 종합평가 (summary) — text — NOT NULL

Users (User)

  • Key (user_id) — int — Primary key — NOT NULL
  • 이메일 (email) — varchar(40) — NOT NULL — OIDC 또는 OAuth token 사용하여 요청
  • OAuth provider (provider) — varchar(40) — NOT NULL — Google 등
  • 이름 (name) — varchar(40) — NOT NULL
  • 생년월일 (birth) — int — NOT NULL
  • 선호 직무 (jobs) — json — ["소프트웨어 엔지니어", "백엔드 개발자", ...]
  • 기본 자소서 (cv_url) — String — CV 파일의 S3 URL
  • 생성시점 (created_at) — Timestamp — NOT NULL