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)