qw

Tables (3)

departments

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

employees

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • department_id — INT — NOT NULL
  • team_name — VARCHAR(100)
  • position — VARCHAR(50) — NOT NULL
  • role — VARCHAR(50)
  • is_resigned — BOOLEAN
  • resigned_at — TIMESTAMP
  • created_at — TIMESTAMP

positions

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • category — ENUM('general', 'executive')
  • created_at — TIMESTAMP