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)