hr test

Tables (14)

app_history

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — 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
  • event_type — VARCHAR(30) — NOT NULL
  • changed_by_account_id — BIGINT
  • reason — TEXT
  • created_at — TIMESTAMP — NOT NULL

applicant

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(30)
  • created_at — TIMESTAMP — NOT NULL

applicant_skill

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.id — NOT NULL

application

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — 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 → job_posting.id — NOT NULL
  • current_stage_id — BIGINT — Foreign key → stage.id — NOT NULL
  • is_cancelled — TINYINT(1) — NOT NULL
  • version — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

career

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.id — NOT NULL
  • job_type — VARCHAR(20) — NOT NULL
  • company_name — VARCHAR(150) — NOT NULL
  • years_experience — DECIMAL(4,1) — NOT NULL
  • started_at — DATE
  • ended_at — DATE

career_skill

  • id — BIGINT
  • career_id — BIGINT — Foreign key → career.id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.id — NOT NULL

company

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

education

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.id — NOT NULL
  • major_id — BIGINT — Foreign key → major.id — NOT NULL
  • school_name — VARCHAR(150) — NOT NULL
  • degree_level — VARCHAR(30) — NOT NULL
  • graduated_at — DATE

job_posting

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • job_type — VARCHAR(20) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL

job_posting_skill

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — 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
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

skill

  • id — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

stage

  • id — BIGINT
  • tenant_id — BIGINT — Foreign key → tenant.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • sequence — INT — NOT NULL
  • is_final — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tenant

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL