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)