61315
Tables (5)
DEPARTMENT (Untitled)
- depNo (int) — int — Primary key — NOT NULL
- depName (Field) — char(30)
- manageStartDate (Field3) — date
- location (Field4) — char(30)
- managerSsn (Key) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled4)
- dependentNo (Key) — int — Primary key — NOT NULL
- depenedentName (Field) — char(50)
- gender (Field2) — char(1)
- birthDate (Field3) — dete
- 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) — char(1)
- supervisor (Field6) — char(14)
- depNo (int) — 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) — int
WORKSON (Untitled5)
- 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