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)