pass-route
Tables (22)
ai_competitors
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → debate_sessions.id — NOT NULL
- persona_id — BIGINT — 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 — Foreign key → debate_sessions.id — 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)
debate_sessions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- topic_id — BIGINT — 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 — Foreign key → debate_sessions.id — NOT NULL
- speaker_type — VARCHAR(20) — NOT NULL
- competitor_id — BIGINT — Foreign key → ai_competitors.id
- 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)
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)
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
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)
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 — Foreign key → self_introductions.id
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
interview_sessions
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → interview_rooms.id — 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)
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)
si_items
- id — BIGINT — Primary key — NOT NULL
- si_id — BIGINT — Foreign key → self_introductions.id — NOT NULL
- question_text — TEXT — NOT NULL
- answer_text — LONGTEXT
- order_num — INT — NOT NULL
user_preferred_companies
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- company_name — VARCHAR(100) — 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)
- 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