32

Tables (7)

Club

  • club_id — INT
  • club_name — VARCHAR(255)
  • club_code — VARCHAR(10)

Department

  • department_id — INT
  • department_name — VARCHAR(255)
  • manager_id — INT
  • office_location — VARCHAR(255)
  • phone_number — VARCHAR(15)
  • employee_id — INT — Foreign key → Employee.employee_id

Dependent

  • dependent_id — INT
  • employee_id — INT
  • relationship — VARCHAR(255)
  • name — VARCHAR(255)
  • birthdate — DATE

Employee

  • employee_id — INT — Primary key
  • name — VARCHAR(255)
  • age — INT
  • address — VARCHAR(255)
  • department_id — INT

EmployeeClub

  • employee_id — INT
  • club_id — INT

EmployeeTraining

  • employee_id — INT
  • program_id — INT

TrainingProgram

  • program_id — INT
  • program_name — VARCHAR(255)
  • duration — INT
  • topic — VARCHAR(50)