ㅁㄴㅇㄹ

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