2023910139
Tables (7)
Department
- Key (DepartmentID) — char(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (Location) — Char(30)
- Field (managerStartDate) — date
- Key (manegerEmpID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Employee)
- Key (eployeeID) — char(10) — Primary key — NOT NULL
- Field (ssn) — char(12)
- Field2 (name) — char(30)
- Field3 (gender) — char(1)
- Field4 (adress) — char(50)
- Field (degree) — char(50)
- Field (salary) — int(10)
- Field (birthDate) — date
- Field (phone) — char(12)
- Key (workforDepartmentID) — char(5) — Foreign key → Department.Key — NOT NULL
- Key (supervisoreployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Project)
- Field (projectID) — int — Primary key
- Field (name) — char(70)
- Field2 (description) — text
- Field (StartDate) — Date
- Field (FinishDate) — Date
Untitled (Workson)
- Field (hours) — float
- Key (eployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (projectID) — int — Foreign key → Untitled.Field
Untitled (DEPENDENT)
- Key (ssn) — char(12) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (gender) — char(1)
- Field (birthdate) — date
- Field (relationship) — char(20)
- Key (eployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (LOCATION)
- Key (locationID) — char(10) — Primary key — NOT NULL
- Field (locationName) — char(30)
- Field (address) — char(50)
Untitled (ISAT)
- Key (DepartmentID) — char(5) — Foreign key → Department.Key — NOT NULL
- Key (locationID) — char(10) — Foreign key → Untitled.Key — NOT NULL