아인잡

테이블 (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