passroute-route

Tables (22)

ai_competitors

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → debate_sessions.id — NOT NULL
  • persona_id — BIGINT — Foreign key → ai_personas.id — NOT NULL
  • stance — VARCHAR(10) — NOT NULL

ai_personas

  • id — BIGINT — Primary key — NOT NULL
  • persona_key — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • background — TEXT
  • debate_style — VARCHAR(20) — NOT NULL
  • difficulty — VARCHAR(10) — NOT NULL
  • strengths — TEXT
  • weaknesses — TEXT
  • system_prompt_template — TEXT
  • speaking_video_url — VARCHAR(1024)
  • silence_video_url — VARCHAR(1024)

debate_reports

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • session_score — DOUBLE
  • report_status — VARCHAR(20) — NOT NULL
  • overall — TEXT
  • strengths — TEXT
  • weaknesses — TEXT
  • improvements — TEXT
  • turn_feedback — TEXT
  • strategy_analysis — TEXT
  • recommended_topics — TEXT
  • final_advice — TEXT
  • voice_score — DOUBLE
  • avg_wpm — DOUBLE
  • avg_silence_duration — DOUBLE
  • filler_count — INT
  • face_score — DOUBLE
  • avg_gaze_ratio — DOUBLE
  • gaze_off_count — INT
  • avg_blink_per_min — DOUBLE
  • created_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → debate_sessions.id — NOT NULL

debate_sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • topic_id — BIGINT — Foreign key → debate_topics.id — NOT NULL
  • user_stance — VARCHAR(10) — NOT NULL
  • difficulty — VARCHAR(10) — NOT NULL
  • mode — VARCHAR(10) — NOT NULL
  • prep_seconds — INT — NOT NULL
  • current_state — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6)
  • ended_at — DATETIME(6)
  • version — BIGINT
  • pending_stt — LONGTEXT
  • video_url — VARCHAR(500)
  • clip_score — DOUBLE
  • clip_reason — VARCHAR(50)
  • is_active — BOOLEAN — NOT NULL
  • deleted_at — DATETIME(6)
  • si_id — BIGINT
  • company_name — VARCHAR(100)

debate_topics

  • id — BIGINT — Primary key — NOT NULL
  • topic_key — VARCHAR(100) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • category — VARCHAR(20) — NOT NULL
  • pro_key_points — TEXT
  • con_key_points — TEXT
  • is_generated — BOOLEAN — NOT NULL

debate_turns

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • speaker_type — VARCHAR(20) — NOT NULL
  • competitor_id — BIGINT
  • stance — VARCHAR(10) — NOT NULL
  • round — VARCHAR(20) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • audio_url — VARCHAR(512)
  • weighted_score — DOUBLE
  • llm_scores_json — TEXT
  • eval_summary_json — TEXT
  • evaluated_at — DATETIME(6)
  • created_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → debate_sessions.id — NOT NULL

document_analyses

  • id — BIGINT — Primary key — NOT NULL
  • document_id — BIGINT — Foreign key → documents.id — NOT NULL
  • extracted_text — TEXT
  • analyzed_at — DATETIME(6)

documents

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • s3_url — VARCHAR(512) — NOT NULL
  • original_filename — VARCHAR(255) — NOT NULL
  • version — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • is_representative — BOOLEAN — NOT NULL
  • embed_status — VARCHAR(255) — NOT NULL
  • file_size — BIGINT
  • file_ext — VARCHAR(10)
  • uploaded_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL

face_analysis

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • question_id — BIGINT — NOT NULL
  • gaze_off_count — INT
  • avg_gaze_ratio — FLOAT
  • avg_blink_per_min — FLOAT
  • id (id2) — BIGINT — Foreign key → interview_sessions.id — NOT NULL

interview_answers

  • id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → interview_questions.id — NOT NULL
  • answer_text — LONGTEXT — NOT NULL
  • percentage — DOUBLE
  • star_score — INT
  • llm_scores — TEXT
  • conciseness_final — DOUBLE
  • video_url — VARCHAR(500)
  • clip_score — DOUBLE
  • clip_reason — VARCHAR(50)
  • answered_at — DATETIME(6)

interview_questions

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → interview_sessions.id — NOT NULL
  • set_number — INT — NOT NULL
  • question_text — TEXT — NOT NULL
  • question_order — INT — NOT NULL
  • follow_up — BOOLEAN — NOT NULL
  • audio_url — VARCHAR(512)
  • created_at — DATETIME(6)

interview_reports

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • overall — TEXT
  • strengths — TEXT
  • weaknesses — TEXT
  • improvements — TEXT
  • question_feedback — TEXT
  • recommended_questions — TEXT
  • final_advice — TEXT
  • session_score — DOUBLE
  • face_score — DOUBLE
  • avg_gaze_ratio — DOUBLE
  • gaze_off_count — INT
  • avg_blink_per_min — DOUBLE
  • interview_readiness — VARCHAR(30)
  • key_weakness — TEXT
  • item_averages — TEXT
  • report_status — VARCHAR(20) — NOT NULL
  • avg_wpm — DOUBLE
  • avg_silence_duration — DOUBLE
  • filler_count — INT
  • voice_score — DOUBLE
  • created_at — DATETIME(6)

interview_rooms

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • si_id — BIGINT
  • resume_id — BIGINT
  • portfolio_id — BIGINT
  • company_name — VARCHAR(100)
  • job_position — VARCHAR(100)
  • interview_type — VARCHAR(20) — NOT NULL
  • interview_format — VARCHAR(20) — NOT NULL
  • interview_mode — VARCHAR(20) — NOT NULL
  • ai_interviewer — VARCHAR(30)
  • ai_competitors — VARCHAR(20)
  • debate_topic — TEXT
  • interview_count — INT — NOT NULL
  • difficulty — VARCHAR(10) — NOT NULL
  • pressure_level — INT — NOT NULL
  • followup_count — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL

interview_schedules

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • company_name — VARCHAR(100)
  • job_position — VARCHAR(100)
  • interview_date — DATETIME(6) — NOT NULL
  • location — VARCHAR(200)
  • memo — TEXT
  • self_intro_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → interview_rooms.id — NOT NULL

interview_sessions

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — NOT NULL
  • session_number — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME(6)
  • ended_at — DATETIME(6)
  • is_active — BOOLEAN — NOT NULL
  • deleted_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → interview_rooms.id — NOT NULL

phone_verifications

  • id — BIGINT — Primary key — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • code — VARCHAR(6) — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • verified_at — DATETIME(6)
  • expired_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

self_introductions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • job_position — VARCHAR(100) — NOT NULL
  • career_level — VARCHAR(20) — NOT NULL
  • job_description — TEXT
  • job_posting_url — VARCHAR(500)
  • memo — TEXT
  • interview_date — DATE
  • interview_time — VARCHAR(10)
  • interview_stage — VARCHAR(20)
  • is_active — BOOLEAN — NOT NULL
  • version — INT — NOT NULL
  • deleted_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL

si_items

  • id — BIGINT — Primary key — NOT NULL
  • si_id — BIGINT — NOT NULL
  • question_text — TEXT — NOT NULL
  • answer_text — LONGTEXT
  • order_num — INT — NOT NULL
  • id (id2) — BIGINT — Foreign key → self_introductions.id — NOT NULL

user_preferred_companies

  • user_id — BIGINT — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL

user_preferred_job_types

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • job_type — VARCHAR(50) — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255)
  • phone — VARCHAR(20)
  • email_verified — BOOLEAN — NOT NULL
  • phone_verified — BOOLEAN — NOT NULL
  • experience_years — INT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

voice_analysis

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • question_id — BIGINT — NOT NULL
  • avg_wpm — FLOAT
  • avg_silence_duration — FLOAT
  • filler_count — INT
  • id (id2) — BIGINT — Foreign key → interview_sessions.id — NOT NULL