12

Tables (7)

departments

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

employee_logs

  • id — INT
  • employee_id — INT
  • action — VARCHAR(20)
  • created_at — TIMESTAMP

employees

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • department_id — INT — NOT NULL
  • team_id — INT
  • position_id — INT — NOT NULL
  • role_id — INT
  • created_at — TIMESTAMP

positions

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(50)
  • level — INT
  • created_at — TIMESTAMP

roles

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

teams

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

users

  • id — INT
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP