ㅁㄴㅇㄹ
Tables (15)
analysis_reports
- report_id — BIGSERIAL — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → evaluation_sessions.session_id — NOT NULL
- overall_score — INT
- suitability_score — INT
- summary — TEXT
- analysis_details — JSONB
- generated_at — TIMESTAMPTZ
companies
- company_id — BIGSERIAL — Primary key — NOT NULL
- company_name — VARCHAR(50)
- industry — VARCHAR(50)
competency_scores
- score_id — BIGSERIAL — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → analysis_reports.report_id — NOT NULL
- competency_name — VARCHAR(100) — NOT NULL
- score — FLOAT
- max_score — INT
evaluation_sessions
- session_id — BIGSERIAL — Primary key — NOT NULL
- scenario_id — BIGINT — Foreign key → scenarios.scenario_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- status — session_status
- started_at — TIMESTAMPTZ
- finished_at — TIMESTAMPTZ
feedbacks
- feedback_id — BIGSERIAL — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → analysis_reports.report_id — NOT NULL
- type — VARCHAR(50)
- content — TEXT
job_positions
- job_position_id — BIGSERIAL — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- position_name — VARCHAR(50)
- department — VARCHAR(50)
- required_competencies — JSONB
practice_steps
- practice_step_id — BIGSERIAL — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → evaluation_sessions.session_id — NOT NULL
- step_id — BIGINT — Foreign key → scenario_steps.step_id — NOT NULL
- user_answer — TEXT
- answered_at — TIMESTAMPTZ
proctoring_logs
- log_id — BIGSERIAL — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → evaluation_sessions.session_id — NOT NULL
- event_type — VARCHAR(50)
- tab_switch_count — INT
- minimize_count — INT
- devtools_detected — BOOLEAN
- recorded_at — TIMESTAMPTZ
proctoring_reports
- report_id — BIGSERIAL — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → evaluation_sessions.session_id — NOT NULL
- risk_score — FLOAT
- event_summary — JSONB
profile_external_links
- link_id — BIGSERIAL — Primary key — NOT NULL
- profile_id — BIGINT — Foreign key → user_profiles.profile_id — NOT NULL
- link_title — VARCHAR(100) — NOT NULL
- link_url — VARCHAR(500) — NOT NULL
- display_order — INT — NOT NULL
scenario_steps
- step_id — BIGSERIAL — Primary key — NOT NULL
- scenario_id — BIGINT — Foreign key → scenarios.scenario_id — NOT NULL
- step_order — INT — NOT NULL
- content — TEXT — NOT NULL
- question_type — VARCHAR(50)
scenarios
- scenario_id — BIGSERIAL — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- job_role — VARCHAR(100)
- difficulty — VARCHAR(50)
- is_practice — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
shared_report_links
- link_id — BIGSERIAL — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → analysis_reports.report_id — NOT NULL
- share_url — VARCHAR(256)
- expires_at — TIMESTAMPTZ
user_profiles
- profile_id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- bio — TEXT
- profile_image_url — VARCHAR(500)
- is_public — BOOLEAN — NOT NULL
- slug — VARCHAR(100)
- github_connected — BOOLEAN — NOT NULL
- portfolio — JSONB
users
- user_id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(320) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- email_verified — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL