erd

Tables (15)

analysis_report

  • id (PK) — bigint — Primary key — NOT NULL
  • total_score (Field) — float
  • alignment_score (Field7) — float
  • best_moment (Field4) — text
  • worst_moment (Field8) — text
  • mentor_feedback (Field2) — text
  • report_status (Field3) — enum
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • mentee_id (FK2) — bigint — Foreign key → session_participant.id — NOT NULL
  • session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL

interview_answer

  • id (PK) — bigint — Primary key — NOT NULL
  • stt_text (Field) — text
  • answer_start (Field2) — timestamp
  • answer_end (Field3) — timestamp
  • ai_score (Field4) — float
  • mentor_score (Field7) — float
  • gap (Field8) — float
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL
  • question_id (FK3) — bigint — Foreign key → interview_question.id — NOT NULL
  • mentee_id (FK2) — bigint — Foreign key → user.id — NOT NULL

interview_question

  • id (PK) — bigint — Primary key — NOT NULL
  • content (Field) — string
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL

interview_session

  • id (PK) — bigint — Primary key — NOT NULL
  • job_category (Field) — string
  • status (Field2) — enum
  • started_at (Field3) — timestamp
  • ended_at (Field4) — timestamp
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • mentor_id (FK) — bigint — Foreign key → user.id — NOT NULL

job_posting

  • id (PK) — bigint — Primary key — NOT NULL
  • company (Field) — string
  • job_category (Field2) — string
  • raw_text (Field3) — text
  • url (Field4) — string
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL

job_skill

  • id (PK) — bigint — Primary key — NOT NULL
  • skill_name (Field) — string
  • skill_type (Field2) — enum
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • job_posting_id (FK) — bigint — Foreign key → job_posting.id — NOT NULL

mentor_availability

  • id (PK) — bigint — Primary key — NOT NULL
  • day_of_week (Field) — enum
  • time_slot (Field2) — string
  • slot_type (Field3) — enum
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL

resume

  • id (PK) — bigint — Primary key — NOT NULL
  • content (Field) — text
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL

resume_skill

  • id (PK) — bigint — Primary key — NOT NULL
  • skill_name (Field) — string
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • resume_id (FK) — bigint — Foreign key → resume.id — NOT NULL

script_segment

  • id (PK) — bigint — Primary key — NOT NULL
  • segment_text (Field) — text
  • segment_type (Field2) — enum
  • start_offset (Field3) — int
  • end_offset (Field4) — int
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • answer_id (FK) — bigint — Foreign key → interview_answer.id — NOT NULL

session_participant

  • id (PK) — bigint — Primary key — NOT NULL
  • answer_status (Field) — enum
  • joined_at (Field2) — timestamp
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • user_id (FK2) — bigint — Foreign key → user.id — NOT NULL
  • session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL

speech_analysis

  • id (PK) — bigint — Primary key — NOT NULL
  • wpm (Field) — float
  • dead_air_count (Field3) — int
  • is_star_s (Field4) — boolean
  • is_star_t (Field7) — boolean
  • is_star_a (Field8) — boolean
  • is_star_r (Field9) — boolean
  • star_ratio (Field10) — float
  • answer_duration_sec (Field2) — int
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • answer_id (FK) — bigint — Foreign key → interview_answer.id — NOT NULL

tag

  • id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — string
  • category (Field2) — enum
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

user

  • id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — string
  • email (Field2) — string
  • password (Field3) — string
  • role (Field4) — enum
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

user_tag

  • id (PK) — bigint — Primary key — NOT NULL
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • tag_id (FK) — bigint — Foreign key → tag.id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → user.id — NOT NULL