아인잡

테이블 (24)

account

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • account_name — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

account_role

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • account_id — BIGINT — 외래 키 → account.id — NOT NULL
  • role_id — BIGINT — 외래 키 → role.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

app_history

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • application_id — BIGINT — 외래 키 → application.id — NOT NULL
  • from_stage_id — BIGINT — 외래 키 → stage.id
  • to_stage_id — BIGINT — 외래 키 → stage.id
  • action_type — SMALLINT — NOT NULL
  • reason — VARCHAR(255)
  • changed_by_account_id — BIGINT — 외래 키 → account.id
  • idempotency_key — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL

applicant

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • company_segment — VARCHAR(50)
  • applicant_name — VARCHAR(100) — NOT NULL
  • birth_day — DATE
  • email — VARCHAR(255)
  • total_career_years — INTEGER
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

applicant_skill

  • id — BIGINT — 기본 키 — NOT NULL
  • applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
  • skill_id — BIGINT — 외래 키 → skill.skill_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

application

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
  • applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
  • current_stage_id — BIGINT — 외래 키 → stage.id — NOT NULL
  • ai_recommend_score — DECIMAL(5,2)
  • applied_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

application_resume_snapshot

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • application_id — BIGINT — 외래 키 → application.id — NOT NULL
  • applicant_name — VARCHAR(100) — NOT NULL
  • birth_day — DATE
  • email — VARCHAR(255)
  • total_career_years — INTEGER
  • current_company_name — VARCHAR(200)
  • current_company_years — DECIMAL(5,2)
  • current_company_position — VARCHAR(100)
  • previous_company_1_name — VARCHAR(200)
  • previous_company_1_years — DECIMAL(5,2)
  • previous_company_1_position — VARCHAR(100)
  • school_name — VARCHAR(200)
  • doctor_major — VARCHAR(200)
  • master_major — VARCHAR(200)
  • bachelor_major — VARCHAR(200)
  • associate_major — VARCHAR(200)
  • snapshot_json — TEXT
  • created_at — TIMESTAMP — NOT NULL

application_resume_snapshot_skill

  • id — BIGINT — 기본 키 — NOT NULL
  • application_resume_snapshot_id — BIGINT — 외래 키 → application_resume_snapshot.id — NOT NULL
  • source_type — SMALLINT — NOT NULL
  • skill_id — BIGINT — 외래 키 → skill.skill_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

career

  • id — BIGINT — 기본 키 — NOT NULL
  • applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
  • job_type_id — SMALLINT — 외래 키 → job_type.id
  • career_order — SMALLINT — NOT NULL
  • company_name — VARCHAR(200) — NOT NULL
  • employment_years — DECIMAL(5,2)
  • position_name — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL

career_skill

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

company

  • id — BIGINT — 기본 키 — NOT NULL
  • company_code — VARCHAR(50) — NOT NULL
  • company_name — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

degree

  • id — BIGINT — 기본 키 — NOT NULL
  • degree_name — VARCHAR(100) — NOT NULL
  • degree_level — SMALLINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

education

  • id — BIGINT — 기본 키 — NOT NULL
  • applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
  • school_id — BIGINT — 외래 키 → school.id — NOT NULL
  • major_id — BIGINT — 외래 키 → major.id
  • degree_id — BIGINT — 외래 키 → degree.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

job_posting

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • job_type_id — SMALLINT — 외래 키 → job_type.id
  • job_title — VARCHAR(200) — NOT NULL
  • job_type_code — SMALLINT — NOT NULL
  • min_career_years — INTEGER — NOT NULL
  • is_major_required — BOOLEAN — NOT NULL
  • created_by_account_id — BIGINT — 외래 키 → account.id
  • created_at — TIMESTAMP — NOT NULL

job_posting_major

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
  • major_id — BIGINT — 외래 키 → major.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

job_posting_skill

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
  • skill_id — BIGINT — 외래 키 → skill.skill_id — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

job_type

  • id — SMALLINT — 기본 키
  • job_type_code — VARCHAR(50) — NOT NULL
  • job_type_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

major

  • id — BIGINT — 기본 키 — NOT NULL
  • major_name — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

permission

  • id — BIGINT — 기본 키 — NOT NULL
  • permission_code — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255) — NOT NULL

role

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • role_code — VARCHAR(50) — NOT NULL
  • role_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

role_permission

  • id — BIGINT — 기본 키 — NOT NULL
  • role_id — BIGINT — 외래 키 → role.id — NOT NULL
  • permission_id — BIGINT — 외래 키 → permission.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

school

  • id — BIGINT — 기본 키 — NOT NULL
  • school_name — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

skill

  • skill_id — BIGINT — 기본 키 — NOT NULL
  • skill_key — VARCHAR(100) — NOT NULL
  • skill_name — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

stage

  • id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → company.id — NOT NULL
  • stage_code — VARCHAR(50) — NOT NULL
  • stage_name — VARCHAR(100) — NOT NULL
  • sequence — INTEGER — NOT NULL
  • is_final — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL