wqe
Tables (9)
Club
- club_id — INT
- club_name — VARCHAR2(255)
- club_code — VARCHAR2(10)
Department
- DepartmentID — varchar2(20) — Primary key — NOT NULL
- Office — varchar2(20)
- Phone — int
- manager_id — int — NOT NULL
Dependent
- Relationship — varchar2(10)
- Name — varchar2(50)
- Birthdate — varchar2(50)
- DependentID — int — NOT NULL
Education
- ProgramCode — int
- ProgramName — varchar2(100)
- ProgramDate — varchar2(50)
- Topic — varchar2(50)
Employee
- EmployeeID — int — Primary key — NOT NULL
- Name — varchar2(15)
- Age — int
- Address — varchar2(200)
- ClubID — int
- ProgramCode — int
- DepartmentName — varchar2(20) — NOT NULL
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)
club
- ClubID — int
- ClubName — varchar2(20) — NOT NULL