아인잡_ATS_과제_강호림

테이블 (12)

applicant

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • birth_date — DATE
  • created_at — TIMESTAMP — NOT NULL

application

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
  • job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
  • current_stage_id — BIGINT — 외래 키 → stage.id — NOT NULL
  • applied_at — TIMESTAMP — NOT NULL

application_history

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • application_id — BIGINT — 외래 키 → application.id — NOT NULL
  • from_stage_id — BIGINT — 외래 키 → stage.id
  • to_stage_id — BIGINT — 외래 키 → stage.id — NOT NULL
  • changed_at — TIMESTAMP — NOT NULL
  • changed_by — VARCHAR(50)
  • reason — VARCHAR(200)

career

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • job_category — VARCHAR(20) — NOT NULL
  • duration_years — DECIMAL(4,1) — NOT NULL
  • is_current — BOOLEAN — NOT NULL

career_skill

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • career_id — BIGINT — 외래 키 → career.id — NOT NULL
  • skill_id — BIGINT — 외래 키 → skill.id — NOT NULL

company

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • biz_reg_no — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

education

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
  • major_id — BIGINT — 외래 키 → major.id — NOT NULL
  • school_name — VARCHAR(100) — NOT NULL
  • degree_type — VARCHAR(20) — NOT NULL
  • graduation_year — INT

job_posting

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • target_job_category — VARCHAR(20)
  • min_career_years — DECIMAL(4,1)

job_posting_skill

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
  • skill_id — BIGINT — 외래 키 → skill.id — NOT NULL

major

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(20) — NOT NULL

skill

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • skill_key — VARCHAR(30) — NOT NULL
  • skill_name — VARCHAR(50) — NOT NULL

stage

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • sequence_order — INT — NOT NULL
  • is_terminal — BOOLEAN — NOT NULL