61315

Tables (5)

DEPARTMENT (Untitled)

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

DEPENDENT (Untitled4)

  • dependentNo (Key) — int — Primary key — NOT NULL
  • depenedentName (Field) — char(50)
  • gender (Field2) — char(1)
  • birthDate (Field3) — dete
  • 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 (int) — int — Foreign key → DEPARTMENT.depNo — NOT NULL

PROJECT (Untitled2)

  • proNo (Key) — int — Primary key — NOT NULL
  • proName (Field) — char(50)
  • description (Field2) — text
  • manageDepartment (Field3) — int

WORKSON (Untitled5)

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