AlbaBot

Tables (5)

applications

  • application_id — INT
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • job_id — INT — Foreign key → jobs.job_id — NOT NULL
  • applied_at — DATETIME
  • status — ENUM('PENDING','ACCEPTED','REJECTED')
  • cover_letter — TEXT

evaluations

  • eval_id — INT
  • reviewer_id — INT — Foreign key → users.user_id — NOT NULL
  • reviewee_id — INT — Foreign key → users.user_id — NOT NULL
  • job_id — INT — Foreign key → jobs.job_id — NOT NULL
  • score — INT — NOT NULL
  • comment — TEXT — EX
  • eval_type — ENUM('EMPLOYER_TO_SEEKER','SEEKER_TO_EMPLOYER') — NOT NULL
  • created_at — DATETIME

jobs

  • job_id — INT
  • employer_id — INT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • category — VARCHAR(50)
  • hourly_wage — INT
  • location — VARCHAR(255)
  • work_hours — VARCHAR(100)
  • deadline — DATETIME
  • description — TEXT
  • status — ENUM('OPEN','CLOSED')
  • created_at — DATETIME

user_categories

  • id — INT
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • category — VARCHAR(50) — NOT NULL

users

  • user_id — INT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • role — ENUM('EMPLOYER','SEEKER','ADMIN') — NOT NULL
  • region — VARCHAR(100)
  • preferred_time — VARCHAR(100)
  • created_at — DATETIME
  • is_active — TINYINT(1)