2023_webDB_ex0

Tables (5)

DEPARTMENT

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

EMPLOYEE

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

PROJECT

  • proNo — int — Primary key — NOT NULL
  • proName — char(30)
  • description — text
  • manageDeaprtment (manageDaprtment) — int

Untitled (DEPENDENT)

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

Untitled (WORKSON)

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