34
Tables (7)
Club
- club_id — INT — Primary key
- club_name — VARCHAR2(255)
- club_code — VARCHAR2(10)
- employee_id — INT — Foreign key → Employee.employee_id
Department
- department_id — INT — Primary key
- department_name — VARCHAR2(255)
- manager_id — INT
- office_location — VARCHAR2(255)
- phone_number — VARCHAR2(15)
Dependent
- dependent_id — INT — Primary key
- employee_id — INT
- relationship — VARCHAR2(255)
- name — VARCHAR2(255)
- birthdate — DATE
- employee_id (employee_id2) — INT — Foreign key → Employee.employee_id
Employee
- employee_id — INT — Primary key
- name — VARCHAR2(255)
- age — INT
- address — VARCHAR2(255)
- department_id (department_id2) — INT — Foreign key → Department.department_id
EmployeeClub
- employee_id — INT
- club_id — INT
EmployeeTraining
- employee_id — INT
- program_id — INT
TrainingProgram
- program_id — INT
- program_name — VARCHAR2(255)
- duration — INT
- topic — VARCHAR2(50)