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