2024_1_example00
Tables (3)
DEPARTMENT
- depID — char(4) — Primary key — NOT NULL
- depNAME (depName) — char(20)
- menageStarDate (manageStarDate) — date
- empID — char(10) — Foreign key → EMPLOYEE.empID — NOT NULL
EMPLOYEE
- empID — char(10) — Primary key — NOT NULL
- name — char(20)
- birthday (birthDate) — date
- gender — char(1)
- phone — char(11)
- depID — char(4) — Foreign key → DEPARTMENT.depID — NOT NULL
Untitled (PROJECT)
- Key (proID) — int(10) — Primary key — NOT NULL
- Field (proName) — char(30)
- Field (department) — char(5)
- Field (manage)