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