AINJOB ERD 2
Tables (19)
app_history
- id — BIGINT — Primary key — NOT NULL
- application_id — BIGINT — Foreign key → application.id — NOT NULL
- job_posting_id — BIGINT — Foreign key → stage.job_posting_id — NOT NULL
- from_stage_id — BIGINT — Foreign key → stage.id
- to_stage_id — BIGINT — Foreign key → stage.id — NOT NULL
- from_status_id — BIGINT — Foreign key → status.id
- to_status_id — BIGINT — Foreign key → status.id — NOT NULL
- reason — VARCHAR(500)
- changed_by — VARCHAR(100)
- changed_at — TIMESTAMP — NOT NULL
app_user
- id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → company.id — NOT NULL
- email — VARCHAR(200) — NOT NULL
- name — VARCHAR(50) — NOT NULL
applicant
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(200) — NOT NULL
- birth_date — DATE
- created_at — TIMESTAMP — NOT NULL
application
- id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → job_posting.company_id — NOT NULL
- job_posting_id — BIGINT — Foreign key → stage.job_posting_id — NOT NULL
- applicant_id — BIGINT — Foreign key → applicant.id — NOT NULL
- stage_id — BIGINT — Foreign key → stage.id — NOT NULL
- status_id — BIGINT — Foreign key → status.id — NOT NULL
- applied_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
career
- id — BIGINT — Primary key — NOT NULL
- applicant_id — BIGINT — Foreign key → applicant.id — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- years — DECIMAL(4,1) — NOT NULL
- position_type_id — BIGINT — Foreign key → position_type.id — NOT NULL
- is_current — TINYINT(1) — NOT NULL
career_skill
- 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
- created_at — TIMESTAMP — NOT NULL
degree
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
education
- id — BIGINT — Primary key — NOT NULL
- applicant_id — BIGINT — Foreign key → applicant.id — NOT NULL
- school_name — VARCHAR(100) — NOT NULL
- degree_id — BIGINT — Foreign key → degree.id — NOT NULL
- major_id — BIGINT — Foreign key → major.id — NOT NULL
job_posting
- id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → company.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- position_type_id — BIGINT — Foreign key → position_type.id — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
job_posting_skill
- id — BIGINT — Primary key — NOT NULL
- job_posting_id — BIGINT — Foreign key → job_posting.id — NOT NULL
- skill_id — BIGINT — Foreign key → skill.id — NOT NULL
major
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_cs_related — TINYINT(1) — NOT NULL
position_type
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(30) — NOT NULL
- name — VARCHAR(50) — NOT NULL
role
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(30) — NOT NULL
- name — VARCHAR(50) — NOT NULL
skill
- id — BIGINT — Primary key — NOT NULL
- skill_key — VARCHAR(50) — NOT NULL
- skill_name — VARCHAR(100) — NOT NULL
stage
- id — BIGINT — Primary key — NOT NULL
- job_posting_id — BIGINT — Foreign key → job_posting.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
stage_transition_rule
- id — BIGINT — Primary key — NOT NULL
- job_posting_id — BIGINT — Foreign key → stage.job_posting_id — NOT NULL
- from_stage_id — BIGINT — Foreign key → stage.id — NOT NULL
- from_status_id — BIGINT — Foreign key → status.id — NOT NULL
- to_stage_id — BIGINT — Foreign key → stage.id — NOT NULL
- to_status_id — BIGINT — Foreign key → status.id — NOT NULL
- reason_required — TINYINT(1) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
status
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(30) — NOT NULL
- name — VARCHAR(50) — NOT NULL
user_role
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → app_user.id — NOT NULL
- role_id — BIGINT — Foreign key → role.id — NOT NULL