2024_09_28

Tables (4)

Untitled (EMPLOYEE)

  • Key (ssn) — int(4) — Primary key — NOT NULL
  • Field (firstname) — char(15)
  • Field (middlenameinital) — char(1)
  • Field (lastname) — char(15)
  • Field (birthdate) — char(8)
  • Field (address) — char(30)
  • Field (gender) — char(1)
  • Field (salary) — int(9)
  • Field (supervisorssn) — int(1)
  • Field (departmentnumber) — int(1)

Untitled (PROJECT)

  • Key (projectnumber) — int(3) — Primary key — NOT NULL
  • Field (projectname) — char(15)
  • Field (projectlocation) — char(15)
  • Field (departmentnumber) — int(1)

Untitled (WORKSON)

  • Key (ssn) — int(1) — Primary key — NOT NULL
  • Field (projectnumber) — int(3)
  • Field (hours) — char(3)
  • Key (ssn2) — int(4) — Foreign key → Untitled.Key — NOT NULL
  • Key (projectnumber2) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (departmentnumber) — int(1) — Primary key — NOT NULL
  • Field (departmentname) — char(15)
  • Field (mgrssn) — char(9)
  • Field (mgrstardate) — char(8)
  • Key (ssn2) — int(4) — Foreign key → Untitled.Key — NOT NULL
  • Key (projectnumber) — int(3) — Foreign key → Untitled.Key — NOT NULL