아인잡_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