ㅇㅇ

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