veriview

테이블 (12)

개인면접 (interview)

  • interview_id — INT — 기본 키
  • user_key — INT — 외래 키 → 사용자.user_key
  • job_category — VARCHAR(100)
  • workexperience — VARCHAR(100)
  • education — VARCHAR(100)
  • experience_description — TEXT
  • tech_stack — TEXT
  • personality — TEXT

개인면접 답변 (interview_answer)

  • interview_answer_id — INT — 기본 키
  • interview_question_id — INT — 외래 키 → 개인면접 질문.interview_question_id
  • video_path — VARCHAR(255)
  • transcript — TEXT

개인면접 답변 피드백 (interview_feedback)

  • interview_feedback_id — INT — 기본 키 — NOT NULL
  • interview_answer_id — INT — 외래 키 → 개인면접 답변.interview_answer_id
  • voice_score — FLOAT
  • action_score — FLOAT
  • content_score — FLOAT
  • voice_feedback — TEXT
  • action_feedback — TEXT
  • content_feedback — TEXT
  • feedback — TEXT

개인면접 질문 (interview_question)

  • interview_question_id — INT — 기본 키
  • interview_id (interview_id2) — INT — 외래 키 → 개인면접.interview_id
  • question_type — ENUM('INTRO', 'FIT', 'PERSONALITY', 'TECH', 'FOLLOWUP')
  • question_text — TEXT
  • ai_video_path — VARCHAR(255)

사용자 (user)

  • user_key — INT — 기본 키
  • user_id — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL

채용공고 (job_posting)

  • job_posting_id — INT — 기본 키
  • title — VARCHAR(255) — NOT NULL
  • deadline — VARCHAR(255)
  • keyword — VARCHAR(255)
  • location — VARCHAR(255)
  • workexperience — VARCHAR(255)
  • education — VARCHAR(255)
  • employmenttype — VARCHAR(255)
  • corporation — VARCHAR(255)
  • category — VARCHAR(255)

채용공고 추천 (job_recommendation)

  • job_recommendation_id — INT — 기본 키
  • user_key — INT — 외래 키 → 사용자.user_key
  • education — TEXT
  • major — TEXT
  • double_major — TEXT
  • workexperience — TEXT
  • qualification — TEXT
  • tech_stack — TEXT
  • location — TEXT
  • category — TEXT
  • employmenttype — TEXT

채용공고 추천 결과 (recommendation_result)

  • recommendation_result_id — 기본 키 — NOT NULL
  • job_recommendation_id — INT — 외래 키 → 채용공고 추천.job_recommendation_id
  • job_posting_id — INT — 외래 키 → 채용공고.job_posting_id
  • title — VARCHAR(255)
  • keyword — VARCHAR(255)
  • corporation — VARCHAR(255)

토론면접 (debate)

  • debate_id — INT — 기본 키
  • debate_topic_id — INT — 외래 키 → 토론면접 주제.debate_topic_id
  • user_key (user_key2) — INT — 외래 키 → 사용자.user_key
  • stance — ENUM('PRO', 'CON')

토론면접 답변 (debate_answer)

  • debate_answer_id — INT — 기본 키
  • debate_id — INT — 외래 키 → 토론면접.debate_id
  • phase — ENUM('OPENING', 'REBUTTAL', 'COUNTER_REBUTTAL', 'CLOSING')
  • ai_answer — TEXT
  • ai_video_path — VARCHAR(255)
  • transcript — TEXT
  • video_path — VARCHAR(255)

토론면접 답변 피드백 (debate_feedback)

  • debate_feedback_id — INT — 기본 키
  • debate_answer_id — INT — 외래 키 → 토론면접 답변.debate_answer_id
  • voice_score — FLOAT
  • action_score — FLOAT
  • feedback — TEXT
  • initiative_score — FLOAT
  • collaborative_score — FLOAT
  • communication_score — FLOAT
  • logic_score — FLOAT
  • problem_solving_score — FLOAT
  • initiative_feedback — TEXT
  • collaborative_feedback — TEXT
  • communication_feedback — TEXT
  • logic_feedback — TEXT
  • problem_solving_feedback — TEXT
  • sample_answer — TEXT

토론면접 주제 (debate_topic)

  • debate_topic_id — INT — 기본 키
  • topic — VARCHAR(255) — NOT NULL