2023_SLI_ EX0

Tables (7)

DEPENDENT

  • Key (ssn) — Primary key — NOT NULL
  • Field (dependentName)
  • Field2 (birthDate)
  • Field3 (relationship)
  • Field4 (parent)
  • Key2 (employeeID) — char(10) — Foreign key → Untitled.Key2 — NOT NULL

Untitled (EMPLOYEE)

  • Key2 (employeeID) — char(10) — Primary key — NOT NULL
  • Field (ssn) — char(12)
  • Field (name) — char(30)
  • Field2 (gender) — char(1)
  • Field (address) — char(50)
  • Field (degree) — char(50)
  • Field (salary) — int(10)
  • Field (birthDate) — date
  • Key (workdeforDpartmentID) — char(s) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (employeeID2) — char(10) — Foreign key → Untitled.Key2 — NOT NULL

Untitled (DEPARTMENT)

  • Key (departmentID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field2 (lacation) — char(10)
  • Field (manageDate) — date
  • Key2 (manageEmpID) — char(10) — Foreign key → Untitled.Key2 — NOT NULL

Untitled (PROJECT)

  • Key (projectID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field2 (description) — text
  • Field

Untitled (WORKSON)

  • Key (workson) — Primary key — NOT NULL
  • Key2 (employeeID) — char(10) — Foreign key → Untitled.Key2 — NOT NULL
  • Key (projectID) — Foreign key → Untitled.Key — NOT NULL

Untitled (ISAT)

  • Key (locationID) — Foreign key → Untitled.Key — NOT NULL
  • Key (departmentID) — char(s) — Foreign key → Untitled.Key — NOT NULL

Untitled (LOCATION)

  • Key (locationID) — Primary key — NOT NULL
  • Field (locationNAme)
  • Field (sddress)