ㄴㄴ
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