20230306

Tables (5)

DEPARTMENT

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

DEPARTMENT (DEPARTMENT1)

  • dependentNo — int — Primary key — NOT NULL
  • depenedentName (dependentName) — char(50)
  • gender — char(1)
  • birthDate — date
  • ssn — char(14)
  • relation — char(20)
  • ssn (ssn2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL

EMPLOYEE

  • ssn — char(14) — Primary key — NOT NULL
  • empName — char(50)
  • address — char(70)
  • salary — int
  • birthDate — date
  • gender — char(1)
  • supervisor — char(14)
  • depNo — int — Foreign key → DEPARTMENT.depNo — NOT NULL

PROJECT

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

WORKSON

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