Tooktac
Tables (12)
evaluation_result
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- session_id — int — Foreign key → interview_session.id — NOT NULL
- question_id — int — Foreign key → interview_question.id — NOT NULL
- question_order — int — NOT NULL
- similarity — float
- intent_score — float
- knowledge_score — float
- final_text_score — int
- model_answer — text
- strengths — text
- improvements — text
- final_feedback — text
- speed_score — int
- filler_score — int
- pitch_score — int
- final_speech_score — int
- speed_label — varchar(20)
- fluency_label — varchar(20)
- tone_label — varchar(20)
- created_at — timestamp
final_report_summary
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- session_id — int — Foreign key → interview_session.id — NOT NULL
- total_score — int
- rank_value — varchar(20)
- grade — varchar(10)
- grade_message — text
- personalized_advice — text
- created_at — timestamp
interview_answer
- id — int — Primary key — NOT NULL
- session_id — int — Foreign key → interview_session.id — NOT NULL
- question_id — int — Foreign key → interview_question.id — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- question_order — int — NOT NULL
- answer_text — text
- created_at — timestamp
interview_question
- id — int — Primary key — NOT NULL
- session_id — int — Foreign key → interview_session.id — NOT NULL
- question_order — int — NOT NULL
- question_text — text — NOT NULL
- question_type — varchar(50) — NOT NULL
- created_at — timestamp
interview_session
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- started_at — timestamp
report_area_score
- id — int — Primary key — NOT NULL
- report_id — int — Foreign key → final_report_summary.id — NOT NULL
- area_name — varchar(100) — NOT NULL
- score — json
- created_at — timestamp
report_improvement
- id — int — Primary key — NOT NULL
- report_id — int — Foreign key → final_report_summary.id — NOT NULL
- priority — int
- title — varchar(100)
- description — text
- score — int
report_question_score
- id — int — Primary key — NOT NULL
- report_id — int — Foreign key → final_report_summary.id — NOT NULL
- question_order — int — NOT NULL
- question_name — varchar(200) — NOT NULL
- question_type — varchar(50) — NOT NULL
- question_text — text — NOT NULL
- user_answer — text — NOT NULL
- model_answer — text — NOT NULL
- score — int — NOT NULL
- summary — json
- created_at — timestamp
report_strength
- id — int — Primary key — NOT NULL
- report_id — int — Foreign key → final_report_summary.id — NOT NULL
- title — varchar(100)
- description — text
- score — int
resume
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- filename — varchar(255)
- content — text
- structured — json
user
- id — int — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(100) — NOT NULL
- nickname — varchar(100) — NOT NULL
- email — varchar(255)
- birthdate — date — NOT NULL
- desired_job — varchar(50) — NOT NULL
- created_at — datetime
- updated_at — datetime
- last_login_at — datetime
video_evaluation_result
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- session_id — int — Foreign key → interview_session.id — NOT NULL
- question_id — int — Foreign key → interview_question.id — NOT NULL
- question_order — int — NOT NULL
- gaze_score — int
- shoulder_warning — int
- hand_warning — int
- posture_score — int
- final_video_score — int
- positive_rate — int
- neutral_rate — int
- negative_rate — int
- tense_rate — int
- emotion_best — varchar(20)
- emotion_score — int
- created_at — timestamp