f
Tables (7)
Untitled (employee)
- Key (emplid) — char(10) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (gender) — char(3)
- Field2 (adress) — char(10)
- Field2 (phone) — char(10)
- Field (salary) — char(10)
- Key (depid) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (superemplid2) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (department location)
- Key (depid) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (locid) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (location)
- Key (locid) — char(10) — Primary key — NOT NULL
- Field (locname) — char(10_
- Field (phone) — char(10)
- Field (email) — email
Untitled (project)
- Key (proid) — char(10) — Primary key — NOT NULL
- Field (startdate) — date
- Field (endeate) — date
- Field (descrition) — text
- Key (manaterdepid) — char(10) — Foreign key → Untitled2.Key — NOT NULL
Untitled (workson)
- Key (emplid) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (proid) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (hourperweek) — float
Untitled (dependent)
- Key (dependid) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (birthdate) — date
- Field (relation) — char(10_
- Key (emplid) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (department)
- Key (depid) — char(10) — Primary key — NOT NULL
- Field (name) — char(10)
- Field2 (managerid) — char(10)
- Field (maganestartdate) — char(10)
- Key (emplid) — char(10) — Foreign key → Untitled.Key — NOT NULL