ㄴㄴ

Tables (12)

analysis_report

  • report_id — BIGSERIAL — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • overall_score — INT
  • suitability_score — INT
  • summary — TEXT
  • ai_feedback — TEXT — AI 피드백 — 구 SESSION_FEEDBACK(type=AI)
  • analysis_details — JSONB — 역량별 상세 분석 (JSONB)
  • share_url — VARCHAR(256) — 외부 공유 URL — EVALUATION 전용
  • share_expires_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

candidate_memo

  • memo_id — BIGSERIAL — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • candidate_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — VARCHAR(512)
  • created_at — TIMESTAMPTZ — NOT NULL

company

  • company_id — BIGSERIAL — Primary key — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL — 회사명
  • industry — VARCHAR(50) — 업종

competency_score

  • score_id — BIGSERIAL — Primary key — NOT NULL
  • report_id — BIGINT — Foreign key → analysis_report.report_id — NOT NULL
  • competency — VARCHAR(100) — NOT NULL
  • score — INT — NOT NULL
  • max_score — INT — NOT NULL — 만점 기준

job_position

  • job_position_id — BIGSERIAL — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL
  • position_name — VARCHAR(100) — NOT NULL
  • department — VARCHAR(50)
  • job_role — VARCHAR(100)
  • required_competencies — JSONB

portfolio_file

  • file_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • file_extension — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

proctoring

  • proctoring_id — BIGSERIAL — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • tab_switch_count — INT — NOT NULL
  • minimize_count — INT — NOT NULL
  • devtools_detected — BOOLEAN — NOT NULL
  • risk_score — NUMERIC(5,2) — 의심 위험도 점수
  • event_log — JSONB — NOT NULL — '이벤트 로그 배열 {event_type occurred_at} — 구 PROCTORING_EVENT',
  • created_at — TIMESTAMPTZ — NOT NULL

profile_external_link

  • link_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • link_title — VARCHAR(100) — NOT NULL
  • link_url — VARCHAR(500) — NOT NULL
  • display_order — INT — NOT NULL

scenario

  • scenario_id — BIGSERIAL — Primary key — NOT NULL
  • job_position_id — BIGINT — Foreign key → job_position.job_position_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • job_role — VARCHAR(100)
  • difficulty — VARCHAR(50)
  • is_practice — BOOLEAN — NOT NULL — '연습용 여부 (TRUE=연습 FALSE=평가)',
  • is_active — BOOLEAN — NOT NULL

scenario_step

  • step_id — BIGSERIAL — Primary key — NOT NULL
  • scenario_id — BIGINT — Foreign key → scenario.scenario_id — NOT NULL
  • step_order — INT — NOT NULL
  • content — TEXT — NOT NULL
  • question_type — VARCHAR(50)

session_answer

  • answer_id — BIGSERIAL — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • step_id — BIGINT — Foreign key → scenario_step.step_id — NOT NULL
  • user_answer — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id
  • email — VARCHAR(320) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • job_role — VARCHAR(100) — 희망 직무 — CANDIDATE 전용
  • profile_image_url — VARCHAR(500)
  • email_verified — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • bio — TEXT — 자기소개 — 구 USER_PROFILE.bio
  • is_public — BOOLEAN — NOT NULL — 프로필 공개 여부 — 구 USER_PROFILE.is_public
  • slug — VARCHAR(100) — 공유용 슬러그 — 구 USER_PROFILE.slug
  • github_connected — BOOLEAN — NOT NULL — GitHub 연동 여부 — 구 USER_PROFILE.github_connected
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • last_login_at — TIMESTAMPTZ