COMPANY
Tables (7)
Untitled (EMPLOYEE)
- Key (employeeNo) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field (email) — chat(30)
- Field (address) — char(30)
- Field (phone) — char(11)
- Key (depNo) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (supervisorNo) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (depNo) — integer — Primary key — NOT NULL
- Field (depName) — char(20)
- Field (phone) — char(20)
- Field (fax) — char(20)
- Field (startDate) — date
- Key (employeeNo) — 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 (depNo) — 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 (depNo) — 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
- Key (hours) — float — NOT NULL
- Field (yearmonth)
Untitled (DEPENDANT)
- Key (depNo) — integer — Primary key — NOT NULL
- Field (depName) — char(20)
- Field (gender) — char(10)
- Field (birthDate) — char(30)
- Field (relationship) — char(20)
- Key (employeeNo) — integer — Foreign key → Untitled.Key — NOT NULL