EMPLOYEE
Tables (4)
Untitled (Department)
- Key (department ID) — char(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field2 (location) — char(30)
- Field3 (managerStartDate) — date
- Field4 (managerEndID) — char(10)
- Key (employee ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Project)
- Key (project ID) — int — Primary key — NOT NULL
- Field (name) — char(70)
- Field (description) — text
- Field
Untitled (Employee)
- Key (employee ID) — char(10) — Primary key — NOT NULL
- Field (ssn) — char(12)
- Field2 (name) — char(30)
- Field3 (gender) — char(1)
- Field4 (address) — char(50)
- Field5 (department) — char(50)
- Field (degree) — char(50)
- Field2 (birthdate) — date
- Key (department ID) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Key (supervisorempID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (WORKSON)
- Key (workonID) — int — Primary key — NOT NULL
- Key (employee ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (project ID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (hours) — float