2022_2_NGS(1stweek)
Tables (4)
Untitled (project)
- Key (projectID) — char(100) — Primary key — NOT NULL
- Field (name) — char(30)
- Key (deptID) — char(3) — Foreign key → department.Key — NOT NULL
department
- Key (deptID) — char(3) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (phone) — char(10)
- Field (location) — char(20)
employee
- Key (employeeNo) — char(8) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (phone) — char(11)
- Field (departmentID) — char(4)
- Field (sex) — char(6)
- Field (socialID) — char(13)
- Field (birthdate) — char(6)
- Key (deptID) — char(3) — Foreign key → department.Key — NOT NULL
workson
- Key (woID) — char(10) — Primary key — NOT NULL
- Key (employeeNo) — char(8) — Foreign key → employee.Key — NOT NULL
- Key (projectID) — char(100) — Foreign key → Untitled.Key — NOT NULL