11

Tables (6)

ai_feedbacks

  • feedback_id — INT
  • interview_id — INT — Foreign key → interview_histories.interview_id — NOT NULL
  • score — INT — NOT NULL
  • feedback_content — TEXT — NOT NULL

document_analyses

  • analysis_id — INT
  • document_id — INT — Foreign key → resumes.document_id — NOT NULL
  • summary — TEXT — NOT NULL
  • tech_stack — TEXT
  • project_keywords — TEXT

interview_histories

  • interview_id — INT
  • user_id — VARCHAR(50) — Foreign key → users.user_id — NOT NULL
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • status — VARCHAR(20)

qa_records

  • qa_id — INT
  • interview_id — INT — Foreign key → interview_histories.interview_id — NOT NULL
  • question_type — VARCHAR(30) — NOT NULL
  • question_content — TEXT — NOT NULL
  • answer_content — TEXT
  • follow_up_content — TEXT

resumes

  • document_id — INT
  • user_id — VARCHAR(50) — Foreign key → users.user_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(512) — NOT NULL
  • uploaded_at — TIMESTAMP

users

  • user_id — VARCHAR(50)
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP