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