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