company

Tables (7)

DEPART-LOC (Untitled4)

  • depNO (Key) — integer — Foreign key → DEPARTMENT.depNO — NOT NULL
  • locNO (Key2) — integer — Foreign key → LOCATION.locNO — NOT NULL

DEPARTMENT (Untitled2)

  • depNO (Key) — integer — Primary key — NOT NULL
  • depName (Field) — char(20)
  • phone (Field2) — char(20)
  • fax (Field3) — char(20)
  • employeeNo (Key2) — integer — Foreign key → EMPLOYEE.employeeNo — NOT NULL

DEPENDANT (Untitled7)

  • depNo (Key) — integer — Primary key — NOT NULL
  • depName (Field) — char(20)
  • age (Field2) — integer
  • sex (Field3) — integer
  • birthDate (Field4) — char(10)
  • 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)
  • address (Field3) — char(30)
  • phone (Field4) — char(11)
  • depNO (Key2) — integer — Foreign key → DEPARTMENT.depNO — NOT NULL
  • suvisorNo (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
  • depNO (Key2) — integer — Foreign key → DEPARTMENT.depNO — NOT NULL

WORK-ON (Untitled6)

  • woNo (Key3) — integer — 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)