ee
Tables (3)
department
- department_code — VARCHAR(50) — Primary key — NOT NULL
- department_team — VARCHAR(50) — NOT NULL
employee
- employee_id — INT — Primary key — NOT NULL
- employee_name — VARCHAR(20) — NOT NULL
record
- record_id — INT — Foreign key → employee.employee_id — NOT NULL
- record_code — VARCHAR(50) — Foreign key → department.department_code — NOT NULL
- record_name — VARCHAR(20)
- record_team — VARCHAR(50)