c
Tables (5)
DEPARTMENT
- depNo (Key) — int — Primary key — NOT NULL
- depName (Field) — char(30)
- managerStart (Field3) — date
- location (Field4) — char(30)
- managerSsn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled4)
- dependentNo (Key) — int — Primary key — NOT NULL
- dependentName (Field) — char(50)
- gender (Field2) — char(1)
- birthDate (Field3) — date
- ssn (Field4) — char(14)
- relation (Field5) — char(20)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled3)
- ssn (Key) — char(14) — Primary key — NOT NULL
- empName (Field) — char(50)
- address (Field2) — char(70)
- salary (Field3) — int
- birthDate (Field4) — date
- gender (Field5) — chao(1)
- supervisor (Field6) — char(14)
- depNo (Key2) — int — Foreign key → DEPARTMENT.depNo — NOT NULL
PROJECT (Untitled2)
- proNo (Key) — int — Primary key — NOT NULL
- proName (Field) — char(50)
- description (Field2) — text
- manageDepartment (Field3)
WORKSON
- woNo (Key3) — int — Primary key — NOT NULL
- ssn (Key) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
- proNo (Key2) — int — Foreign key → PROJECT.proNo — NOT NULL