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