ㅇㅇ
Tables (14)
analysis_report
- report_id — BIGSERIAL — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → evaluation_session.session_id — NOT NULL
- overall_score — INT
- suitability_score — INT
- summary — TEXT
- ai_feedback — TEXT — AI 자동 생성 피드백
- human_feedback — TEXT — 면접관/관리자 작성 피드백 — 구 FEEDBACKS(type=HUMAN) 대체
- analysis_details — JSONB — 역량별 상세 분석 데이터 (JSONB)
- share_url — VARCHAR(500) — 외부 공유용 고유 URL
- 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 — NOT NULL
- content — TEXT
- 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 — 만점 기준
evaluation_session
- session_id — BIGSERIAL — Primary key — NOT NULL
- scenario_id — BIGINT — Foreign key → scenario.scenario_id — NOT NULL
- user_id — BIGINT — NOT NULL
- status — session_status — NOT NULL
- started_at — TIMESTAMPTZ
- finished_at — TIMESTAMPTZ
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)
- required_competencies — JSONB — 요구 역량 리스트 (JSONB)
job_role
- job_role_id — BIGSERIAL — Primary key — NOT NULL
- role_name — VARCHAR(100) — NOT NULL
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 — Foreign key → evaluation_session.session_id — 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_LOG 대체',
- 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
- target_job_role_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- difficulty — VARCHAR(20)
- 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 — Foreign key → evaluation_session.session_id — NOT NULL
- step_id — BIGINT — 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 — user_role — NOT NULL — '시스템 권한 (ADMIN CANDIDATE)',
- desired_job_role_id — BIGINT — '희망 직무 — CANDIDATE 전용 job_role 참조',
- profile_image_url — VARCHAR(500)
- email_verified — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- bio — TEXT — 자기소개
- is_public — BOOLEAN — NOT NULL — 프로필 공개 여부
- slug — VARCHAR(100) — 공유용 고유 슬러그
- github_connected — BOOLEAN — NOT NULL — GitHub 연동 여부
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- last_login_at — TIMESTAMPTZ