2023

Tables (5)

DEPARTMENT (Untitled)

  • depNO (Key) — int — Primary key — NOT NULL
  • depName (Field) — char(30)
  • managerNO (Field2) — int
  • manageStartDate (Field3) — date
  • location (Field4) — char(30)
  • ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL

DEPENDENT (Untitled4)

  • dependentNO (Key) — int — Primary key — NOT NULL
  • dependetName (Field) — char(50)
  • gender (Field2) — char(1)
  • birthDate (Field3) — date
  • ssn (Field4) — char(14)
  • relation (Field5) — char(20)
  • ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled3)

  • ssn (Key) — char(14) — Primary key — NOT NULL
  • empName (Field) — char(50)
  • address (Field2) — char(70)
  • salary (Field3) — int
  • birthDate (Field4) — date
  • gender (Field5) — char(1)
  • supervisor (Field6) — char(14)
  • depNO (Key2) — int — Foreign key → DEPARTMENT.depNO — NOT NULL

PROJECT (Untitled2)

  • proNO (Key) — int — Primary key — NOT NULL
  • proNAME (Field) — char(50)
  • desaription (Field2) — text
  • manageDepartment (Field3) — int

WORKSON (CopyOfUntitled5)

  • woNO (Key3) — int — Primary key — NOT NULL
  • ssn (Key) — char(14) — Foreign key → PROJECT.proNO — NOT NULL
  • proNO (Key2) — int — Foreign key → EMPLOYEE.ssn — NOT NULL