ain

Tables (13)

AppHistory

  • id — BIGINT — Primary key — NOT NULL
  • application_id — BIGINT — Foreign key → Application.id — NOT NULL
  • from_stage_id — BIGINT — Foreign key → Stage.id
  • to_stage_id — BIGINT — Foreign key → Stage.id — NOT NULL
  • changed_by — VARCHAR(100)
  • note — VARCHAR(500)
  • changed_at — DATETIME — NOT NULL

Applicant

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(200) — NOT NULL
  • phone — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

Application

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → Company.id — NOT NULL
  • applicant_id — BIGINT — Foreign key → Applicant.id — NOT NULL
  • job_posting_id — BIGINT — Foreign key → JobPosting.id — NOT NULL
  • current_stage_id — BIGINT — Foreign key → Stage.id — NOT NULL
  • applied_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

Career

  • id — BIGINT — Primary key — NOT NULL
  • applicant_id — BIGINT — Foreign key → Applicant.id — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • job_category — TINYINT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • is_current — TINYINT(1) — NOT NULL

CareerSkill

  • id — BIGINT — Primary key — NOT NULL
  • career_id — BIGINT — Foreign key → Career.id — NOT NULL
  • skill_id — BIGINT — Foreign key → Skill.id — NOT NULL

Company

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • business_no — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

Education

  • id — BIGINT — Primary key — NOT NULL
  • applicant_id — BIGINT — Foreign key → Applicant.id — NOT NULL
  • major_id — BIGINT — Foreign key → Major.id
  • school_name — VARCHAR(100) — NOT NULL
  • degree_type — TINYINT — NOT NULL
  • graduation_status — TINYINT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE

JobPosting

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → Company.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • job_category — TINYINT — NOT NULL
  • min_exp_years — TINYINT — NOT NULL
  • status — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • closed_at — DATETIME
  • deleted_at — DATETIME

JobPostingSkill

  • id — BIGINT — Primary key — NOT NULL
  • job_posting_id — BIGINT — Foreign key → JobPosting.id — NOT NULL
  • skill_id — BIGINT — Foreign key → Skill.id — NOT NULL
  • is_required — TINYINT(1) — NOT NULL

Major

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_cs_related — TINYINT(1) — NOT NULL

MatchingResult

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → Company.id — NOT NULL
  • applicant_id — BIGINT — Foreign key → Applicant.id — NOT NULL
  • job_posting_id — BIGINT — Foreign key → JobPosting.id — NOT NULL
  • match_score — DECIMAL(5,2) — NOT NULL
  • match_status — TINYINT — NOT NULL
  • reason — TEXT
  • created_at — DATETIME — NOT NULL

Skill

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • category — TINYINT — NOT NULL

Stage

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → Company.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • stage_type — TINYINT — NOT NULL
  • step_order — TINYINT — NOT NULL
  • is_terminal — TINYINT(1) — NOT NULL