COMPANY
Tables (7)
Untitled (DEPARTMENT)
- Key (deptNO) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field (manager) — char(20)
- Field (managerStarDate) — char(11)
- Key (employeeNO) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (employeeNO) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field (email) — char(30)
- Field (address) — char(30)
- Field (phone) — char(11)
- Key (deptNO) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (suvisorNO) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (LOCATION)
- Key (locNO) — integer — Primary key — NOT NULL
- Field (locName) — char(100)
- Field (phone) — char(15)
- Field (address) — char(100)
Untitled (DEPART-LOC)
- Key (deptNO) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (locNO) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (proNo) — integer — Primary key — NOT NULL
- Field (proName) — char(20)
- Field (description) — text
- Key (deptNO) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (WORKS-ON)
- Key (woNo) — integer — Primary key — NOT NULL
- Key (employeeNO) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (proNo) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (hour) — float
- Field (yearmonth) — char(10)
Untitled (DEPENDANT)
- Key (depNO) — integer — Primary key — NOT NULL
- Field (depName) — char(20)
- Field (age) — integer
- Field (birthdate) — date
- Field (gender) — char(10)
- Key (employeeNO) — integer — Foreign key → Untitled.Key — NOT NULL