아인잡
테이블 (24)
actor_type
- actor_type_id — SMALLINT — 기본 키 — NOT NULL
- actor_type_key — VARCHAR(30) — NOT NULL
- actor_type_name — VARCHAR(50) — NOT NULL
applicant
- applicant_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.company_id — NOT NULL
- applicant_name — VARCHAR(100) — NOT NULL
- birth_date — DATE
- email — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
application
- application_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → job_posting_stage.company_id — NOT NULL
- applicant_id — BIGINT — 외래 키 → applicant.applicant_id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting_stage.job_posting_id — NOT NULL
- current_stage_id — SMALLINT — 외래 키 → stage.stage_id — NOT NULL
- application_status_id — SMALLINT — 외래 키 → application_status.application_status_id — NOT NULL
- applied_at — TIMESTAMP — NOT NULL
- stage_changed_at — TIMESTAMP
- status_changed_at — TIMESTAMP
- version — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
application_history
- application_history_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — NOT NULL
- application_id — BIGINT — 외래 키 → application.application_id — NOT NULL
- change_type — VARCHAR(10) — NOT NULL
- from_stage_id — SMALLINT — 외래 키 → stage.stage_id
- to_stage_id — SMALLINT — 외래 키 → stage.stage_id
- from_status_id — SMALLINT — 외래 키 → application_status.application_status_id
- to_status_id — SMALLINT — 외래 키 → application_status.application_status_id
- changed_by_actor_type_id — SMALLINT — 외래 키 → actor_type.actor_type_id — NOT NULL
- changed_by_user_id — BIGINT — 외래 키 → user_account.user_id
- change_reason — VARCHAR(255)
- changed_at — TIMESTAMP — NOT NULL
application_status
- application_status_id — SMALLINT — 기본 키 — NOT NULL
- application_status_key — VARCHAR(30) — NOT NULL
- application_status_name — VARCHAR(50) — NOT NULL
- is_terminal — BOOLEAN — NOT NULL
career
- career_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → applicant.company_id — NOT NULL
- applicant_id — BIGINT — 외래 키 → applicant.applicant_id — NOT NULL
- employer_name — VARCHAR(150) — NOT NULL
- experience_years — SMALLINT — NOT NULL
- position_id — SMALLINT — 외래 키 → position.position_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
career_skill
- career_skill_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → career.company_id — NOT NULL
- career_id — BIGINT — 외래 키 → career.career_id — NOT NULL
- skill_id — INT — 외래 키 → skill.skill_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
company
- company_id — BIGSERIAL — 기본 키 — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
company_user
- company_user_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.company_id — NOT NULL
- user_id — BIGINT — 외래 키 → user_account.user_id — NOT NULL
- role_id — SMALLINT — 외래 키 → company_user_role.role_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
company_user_role
- role_id — SMALLINT — 기본 키 — NOT NULL
- role_key — VARCHAR(30) — NOT NULL
- role_name — VARCHAR(50) — NOT NULL
education
- education_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → applicant.company_id — NOT NULL
- applicant_id — BIGINT — 외래 키 → applicant.applicant_id — NOT NULL
- education_level_id — SMALLINT — 외래 키 → education_level.education_level_id — NOT NULL
- university_name — VARCHAR(150)
- major_id — INT — 외래 키 → major.major_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
education_level
- education_level_id — SMALLINT — 기본 키 — NOT NULL
- education_level_key — VARCHAR(30) — NOT NULL
- education_level_name — VARCHAR(50) — NOT NULL
- level_rank — SMALLINT — NOT NULL
job_posting
- job_posting_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.company_id — NOT NULL
- position_id — SMALLINT — 외래 키 → position.position_id — NOT NULL
- posting_title — VARCHAR(150) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
job_posting_career_req
- company_id — BIGINT — 외래 키 → job_posting.company_id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting.job_posting_id — NOT NULL
- position_id — SMALLINT — 외래 키 → position.position_id — NOT NULL
- minimum_experience_years — SMALLINT — NOT NULL
job_posting_education_req
- company_id — BIGINT — 외래 키 → job_posting.company_id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting.job_posting_id — NOT NULL
- education_level_id — SMALLINT — 외래 키 → education_level.education_level_id — NOT NULL
- major_id — INT — 외래 키 → major.major_id — NOT NULL
job_posting_skill
- job_posting_skill_id — BIGSERIAL — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → job_posting.company_id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting.job_posting_id — NOT NULL
- skill_id — INT — 외래 키 → skill.skill_id — NOT NULL
job_posting_stage
- company_id — BIGINT — 외래 키 → job_posting.company_id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting.job_posting_id — NOT NULL
- stage_id — SMALLINT — 외래 키 → stage.stage_id — NOT NULL
- stage_order — SMALLINT — NOT NULL
major
- major_id — INT — 기본 키 — NOT NULL
- major_name — VARCHAR(100) — NOT NULL
position
- position_id — SMALLINT — 기본 키 — NOT NULL
- position_key — VARCHAR(30) — NOT NULL
- position_name — VARCHAR(50) — NOT NULL
skill
- skill_id — INT — 기본 키 — NOT NULL
- skill_key — VARCHAR(30) — NOT NULL
- skill_name — VARCHAR(100) — NOT NULL
stage
- stage_id — SMALLINT — 기본 키 — NOT NULL
- stage_key — VARCHAR(30) — NOT NULL
- stage_name — VARCHAR(50) — NOT NULL
stage_transition
- company_id — BIGINT — 외래 키 → job_posting_stage.company_id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting_stage.job_posting_id — NOT NULL
- from_stage_id — SMALLINT — 외래 키 → job_posting_stage.stage_id — NOT NULL
- to_stage_id — SMALLINT — 외래 키 → job_posting_stage.stage_id — NOT NULL
status_transition
- from_status_id — SMALLINT — 외래 키 → application_status.application_status_id — NOT NULL
- to_status_id — SMALLINT — 외래 키 → application_status.application_status_id — NOT NULL
user_account
- user_id — BIGSERIAL — 기본 키 — NOT NULL
- login_id — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL