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