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