20230907
Tables (8)
DEPARTMENTLOCATION (Untitled5)
- Key (depID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (localNo) — int — Foreign key → Location.Key — NOT NULL
EMPLOYEEFAMILY (Untitled2)
- Key (famSSN) — char(14) — Primary key — NOT NULL
- Field (famName) — char(30)
- Field (famGender) — char(10)
- Field (famBirth) — date
- Field (famRelation) — char(20)
- Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL
Location (Untitled4)
- Key (localNo) — int — Primary key — NOT NULL
- Field (localName) — char(20)
- Field (localAddress) — char(30)
PROJECT (Untitled)
- Key (proNo) — int — Primary key — NOT NULL
- Field (proName) — char(20)
- Key (depID) — int — Foreign key → Untitled.Key — NOT NULL
PROJECTMANAGE (Untitled6)
- Key (proNo) — int — Foreign key → PROJECT.Key — NOT NULL
- Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (depID) — int — Primary key — NOT NULL
- Field (depName) — char(20)
- Field (depLocation) — char(20)
- Field2 (depManager) — int
- Field2 (managerStartDate) — date
- Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (empSSN) — char(14) — Primary key — NOT NULL
- Field (empName) — char(30)
- Field (empDepartment) — int
- Key (depID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (empSalary) — int
- Field (empAddress) — char(30)
- Field (empGender) — char(10)
- Field (supervisor) — char(30)
- Key (superVssn) — char(14) — Foreign key → Untitled.Key — NOT NULL
- Field
WORKSON (Untitled3)
- Key (empSSN) — char(14) — Foreign key → Untitled.Key — NOT NULL
- Key (proNo) — int — Foreign key → PROJECT.Key — NOT NULL
- hoursPerWeek (Field) — float