Department
Tables (3)
department (Untitled2)
- department_id (Key) — varchar(10) — Primary key — NOT NULL
- department_name (Field) — varchar(10)
department_employee (Untitled3)
- department_employee_id (Key3) — Long — Primary key — NOT NULL
- employee_id (Key) — Long — Foreign key → employee.employee_id — NOT NULL
- department_id (Key2) — varchar(10) — Foreign key → department.department_id — NOT NULL
employee (emplyee)
- employee_id (Key) — Long — Primary key — NOT NULL
- employee_name (Field) — varchar(10)