2022_2_NGS(1stweek)

Tables (4)

Untitled (project)

  • Key (projectID) — char(100) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Key (deptID) — char(3) — Foreign key → department.Key — NOT NULL

department

  • Key (deptID) — char(3) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (phone) — char(10)
  • Field (location) — char(20)

employee

  • Key (employeeNo) — char(8) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — char(11)
  • Field (departmentID) — char(4)
  • Field (sex) — char(6)
  • Field (socialID) — char(13)
  • Field (birthdate) — char(6)
  • Key (deptID) — char(3) — Foreign key → department.Key — NOT NULL

workson

  • Key (woID) — char(10) — Primary key — NOT NULL
  • Key (employeeNo) — char(8) — Foreign key → employee.Key — NOT NULL
  • Key (projectID) — char(100) — Foreign key → Untitled.Key — NOT NULL