company

Tables (7)

DEPARTMENT (Untitled2)

  • DPNo (Key) — integer — Primary key — NOT NULL
  • DPname (Field) — char(20)
  • DPphone (Field2) — char(20)
  • DPfax (Field3) — char(20)
  • startDate (Field4) — date
  • EmployeeNo (Key2) — integer — Foreign key → EMPLOYEE.EmployeeNo — NOT NULL

DEPART_LOC (Untitled4)

  • DPNo (Key) — integer — Foreign key → DEPARTMENT.DPNo — NOT NULL
  • LOCNo (Key2) — integer — Foreign key → LOCATION.LOCNo — NOT NULL

DEPENDANT (Untitled7)

  • depNo (Key) — integer — Primary key — NOT NULL
  • depName (Field) — char(20)
  • age (Field2) — integer
  • EmployeeNo (Key2) — integer — Foreign key → EMPLOYEE.EmployeeNo — NOT NULL

EMPLOYEE (Untitled)

  • EmployeeNo (Key) — integer — Primary key — NOT NULL
  • name (Field) — char(20)
  • email (Field2) — char(30)
  • adress (Field3) — char(30)
  • phone (Field4) — char(11)
  • DPNo (Key2) — integer — Foreign key → DEPARTMENT.DPNo — NOT NULL
  • supervisorNo (Key3) — integer — Foreign key → EMPLOYEE.EmployeeNo — NOT NULL

LOCATION (Untitled3)

  • LOCNo (Key) — integer — Primary key — NOT NULL
  • LOCName (Field) — char(100)
  • phone (Field2) — char(15)
  • address (Field3) — char(100)

PROJECT (Untitled5)

  • ProNO (Key) — integer — Primary key — NOT NULL
  • proName (Field) — char(20)
  • description (Field2) — text
  • DPNo (Key2) — integer — Foreign key → DEPARTMENT.DPNo — NOT NULL

WORKS_ON (Untitled6)

  • woNo (Key3) — interger — Primary key — NOT NULL
  • EmployeeNo (Key) — integer — Foreign key → EMPLOYEE.EmployeeNo — NOT NULL
  • ProNO (Key2) — integer — Foreign key → PROJECT.ProNO — NOT NULL
  • hours (Field) — float
  • yearmonth (Field2) — char(10)