test

Tables (3)

department

  • department_code — VARCHAR(10) — Primary key — NOT NULL
  • department_name — VARCHAR(20)

department_employee

  • department_code — VARCHAR(10) — Foreign key → department.department_code — NOT NULL
  • employee_code — VARCHAR(9) — Foreign key → employee.employee_code — NOT NULL

employee

  • employee_code — VARCHAR(9) — Primary key — NOT NULL
  • enployee_name — VARCHAR(5)