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)