2023_sli.ex0
Tables (10)
Untitled (EMPLOYEE)
- Key (employeeID) — char(10) — Primary key — NOT NULL
- Field (ssn) — char(12)
- Field2 (name) — char(30)
- Field3 (gender) — char(1)
- Field2 (degree) — char(50)
- Field4 (salary) — int(10)
- Field (birthDate) — date
- Field (address) — char(50)
- Key (departmentID) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Key (supervisesorEmpIDemployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (projectID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (employeeID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPRTMENT)
- Key (departmentID) — char(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field2 (location) — char(30)
- Field4 (manageStardData) — date
- Key (managerEmployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (projectID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (WORKSON)
- Key (worNo) — char(12) — Primary key — NOT NULL
- Key (projectID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (employeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field2 (hours) — float
Untitled (DEPENDENT)
- Key (dependentID) — char(12) — Primary key — NOT NULL
- Field (gender) — chat(4)
- Field2 (birthDate) — date
- Field3 (relationship) — chat(10)
- Field4 (parent) — chat(30)
- Field (name) — char(10)
- Key (dependentEmployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (ssn) — chat(12)
Untitled (PROJECT)
- Key (projectID) — int — Primary key — NOT NULL
- Field (name) — char(70)
- Field2 (description) — taxt
- Field3 (controlingDepartmentID) — char(5)
Untitled (LOCATION)
- Key (locationID) — int — Primary key — NOT NULL
- Field (locatiomName) — char(30)
- Field2 (address) — char(50)
Untitled (PART)
- Key (partNo) — Primary key — NOT NULL
- Field (price)
- Field2 (manual)
- Field3 (coperation)
- Field4 (description) — text
- Key (supID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (SUPPLIER)
- Key (supID) — int — Primary key — NOT NULL
- Field (supName) — char(30)
- Field2 (phon) — char(10)
- Field (address) — char(40)
- Field (fax) — char(10)
- Field (email) — email
- Field (description) — text
Untitled2 (PRODUCT)
- Key (productNo) — Primary key — NOT NULL
- Field (price) — int(10)
- Field2 (partID)
- Field3 (specificarion) — text
Untitled3 (PRODUCT_PART)
- Field4 (qty) — int(3)
- Key (productNo) — Foreign key → Untitled2.Key — NOT NULL
- Key (partNo) — Foreign key → Untitled.Key — NOT NULL