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)