company
Tables (7)
Untitled4 (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 (depNo) — integer — Foreign key → Untitled4.Key — NOT NULL
- Key (employeeNo2) — integer — Foreign key → Untitled4.Key — NOT NULL
Untitled4 (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 → Untitled4.Key — NOT NULL
Untitled4 (LOCATION)
- Key (locNo) — integer — Primary key — NOT NULL
- Field (locName) — char(100)
- Field (phone) — char(15)
- Field (address) — char(100)
Untitled4 (DEPART. LOC)
- Key (depNo2) — integer — Foreign key → Untitled4.Key — NOT NULL
- Key (locNo2) — integer — Foreign key → Untitled4.Key — NOT NULL
Untitled4 (PROJECT)
- Key (pro.No) — integer — Primary key — NOT NULL
- Field (pro.Home) — char(20)
- Field (description) — text
- Key (depNo) — integer — Foreign key → Untitled4.Key — NOT NULL
Untitled4 (WORKS. ON)
- Key (woNo) — integer — Primary key — NOT NULL
- Field (hours) — float
- Field (year.month) — char(10)
- Key (employeeNo) — integer — Foreign key → Untitled4.Key — NOT NULL
- Key (pro.No) — integer — Foreign key → Untitled4.Key — NOT NULL
Untitled4 (DEPENDANT)
- Key (depNo) — integer — Primary key — NOT NULL
- Field (depName) — char(20)
- Field (age)
- Key (employeeNo) — integer — Foreign key → Untitled4.Key — NOT NULL