20230306
Tables (5)
DEPARTMENT
- depNo — int — Primary key — NOT NULL
- depName — char(30)
- manageStartDate — date
- location — char(30)
- ssn — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPARTMENT (DEPARTMENT1)
- dependentNo — int — Primary key — NOT NULL
- depenedentName (dependentName) — char(50)
- gender — char(1)
- birthDate — date
- ssn — char(14)
- relation — char(20)
- ssn (ssn2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE
- ssn — char(14) — Primary key — NOT NULL
- empName — char(50)
- address — char(70)
- salary — int
- birthDate — date
- gender — char(1)
- supervisor — char(14)
- depNo — int — Foreign key → DEPARTMENT.depNo — NOT NULL
PROJECT
- proNo — int — Primary key — NOT NULL
- proName — char(50)
- description — text
- manageDepartment — int
WORKSON
- woNo — int — Primary key — NOT NULL
- ssn — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
- proNo — int — Foreign key → PROJECT.proNo — NOT NULL