HR
Tables (19)
Account
- id — bigint — Primary key — NOT NULL
- company_id — bigint — Foreign key → Company.id — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(50)
AccountRole
- account_id — bigint — Foreign key → Account.id — NOT NULL
- role_id — bigint — Foreign key → Role.id — NOT NULL
AppHistory
- id — bigint — Primary key — NOT NULL
- application_id — bigint — Foreign key → Application.id — NOT NULL
- prev_stage_id — bigint
- next_stage_id — bigint — NOT NULL
- changed_at — timestamp
- reason — text
Applicant
- id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- birth_date — date
- email — varchar(100) — NOT NULL
- phone — varchar(20)
- created_at — timestamp
Application
- id — bigint — Primary key — NOT NULL
- company_id — bigint — Foreign key → Company.id — NOT NULL
- job_posting_id — bigint — Foreign key → JobPosting.id — NOT NULL
- applicant_id — bigint — Foreign key → Applicant.id — NOT NULL
- current_stage_id — bigint — Foreign key → Stage.id — NOT NULL
- applied_at — timestamp
Career
- id — bigint — Primary key — NOT NULL
- applicant_id — bigint — Foreign key → Applicant.id — NOT NULL
- company_name — varchar(100) — NOT NULL
- start_date — date — NOT NULL
- end_date — date
- years — int
- job_type_id — int — Foreign key → JobType.id — NOT NULL
CareerSkill
- 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
Education
- id — bigint — Primary key — NOT NULL
- applicant_id — bigint — Foreign key → Applicant.id — NOT NULL
- major_id — bigint — Foreign key → Major.id — NOT NULL
- school_name — varchar(100) — NOT NULL
- education_level — varchar(20) — NOT NULL
- entrance_date — date
- graduation_date — date
- edu_level_id — int — Foreign key → EducationLevel.id
EducationLevel
- id — int — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
JobPostSkill
- job_post_id — bigint — Foreign key → JobPosting.id — NOT NULL
- skill_id — bigint — Foreign key → Skill.id — NOT NULL
JobPosting
- id — bigint — Primary key — NOT NULL
- company_id — bigint — Foreign key → Company.id — NOT NULL
- title — varchar(200) — NOT NULL
- created_at — timestamp
- job_type_id — int — Foreign key → JobType.id
JobType
- id — int — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
Major
- id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
Permission
- id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
Role
- id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
RolePermission
- permission_id — bigint — Foreign key → Permission.id — NOT NULL
- role_id — bigint — Foreign key → Role.id — NOT NULL
Skill
- id — bigint — Primary key — NOT NULL
- skill_key — varchar(50) — NOT NULL
- skill_name — varchar(50) — NOT NULL
Stage
- id — bigint — Primary key — NOT NULL
- company_id — bigint — Foreign key → Company.id — NOT NULL
- name — varchar(50) — NOT NULL
- sequence — int — NOT NULL
- is_final — tinyint(1)