HR

Tables (19)

app_career

  • career_id — BIGINT
  • applicant_id — BIGINT — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • position — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • description — TEXT

app_education

  • education_id — BIGINT
  • applicant_id — BIGINT — NOT NULL
  • school_name — VARCHAR(100) — NOT NULL
  • major — VARCHAR(100) — NOT NULL
  • degree — VARCHAR(50) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • gpa — DECIMAL(3,2)

app_skills

  • app_skill_id — BIGINT
  • applicant_id — BIGINT — NOT NULL
  • skill_id — BIGINT — NOT NULL
  • skill_level — VARCHAR(20) — NOT NULL
  • years_of_exp — INT

applicant_info

  • applicant_id — BIGINT
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • birth_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

applicant_tracking

  • tracking_id — BIGINT
  • application_id — BIGINT — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • stage — VARCHAR(50) — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • notes — TEXT

applied_companies

  • application_id — BIGINT
  • applicant_id — BIGINT — NOT NULL
  • job_id — BIGINT — NOT NULL
  • applied_date — DATETIME — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • resume_id — BIGINT

com_user_authority

  • authority_id — BIGINT
  • role_name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL

comp_info

  • company_id — BIGINT
  • business_number — VARCHAR(20) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • industry — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

comp_prof

  • profile_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • company_size — VARCHAR(20) — NOT NULL
  • description — TEXT — NOT NULL
  • location — VARCHAR(200) — NOT NULL
  • website — VARCHAR(255)
  • logo_url — VARCHAR(500)

hr_managers

  • manager_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • position — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • department — VARCHAR(50)
  • reports_to — BIGINT

job_posting

  • job_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • requirements — TEXT — NOT NULL
  • position_type — VARCHAR(50) — NOT NULL
  • salary_range — VARCHAR(100)
  • location — VARCHAR(200) — NOT NULL
  • posted_date — DATETIME — NOT NULL
  • deadline — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL

job_posting_skill

  • job_skill_id — BIGINT
  • job_id — BIGINT — NOT NULL
  • skill_id — BIGINT — NOT NULL
  • skill_level — VARCHAR(20) — NOT NULL
  • is_required — BOOLEAN — NOT NULL

manage_users

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • authority_id — BIGINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • last_login — DATETIME

menu

  • menu_id — BIGINT
  • menu_name — VARCHAR(100) — NOT NULL
  • parent_menu_id — BIGINT
  • menu_url — VARCHAR(255)
  • menu_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

menu_authority

  • menu_auth_id — BIGINT
  • menu_id — BIGINT — NOT NULL
  • authority_id — BIGINT — NOT NULL
  • can_read — BOOLEAN — NOT NULL
  • can_write — BOOLEAN — NOT NULL
  • can_delete — BOOLEAN — NOT NULL

notifications

  • notification_id — BIGINT
  • user_type — VARCHAR(20) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

resume_tracking

  • resume_id — BIGINT
  • applicant_id — BIGINT — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • uploaded_date — DATETIME — NOT NULL
  • version — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

skills

  • skill_id — BIGINT
  • skill_name — VARCHAR(100) — NOT NULL
  • skill_category — VARCHAR(50) — NOT NULL
  • description — TEXT

subscriptions

  • subscription_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • plan_type — VARCHAR(50) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL