Mimi
Tables (5)
Untitled (EMPLOYEE)
- Key (ssn) — char(14) — Primary key — NOT NULL
- Field (name) — chart(20)
- Field (address) — chart(30)
- Field (phone) — chart(11)
- Key (depID) — char(3) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (depID) — char(3) — Primary key — NOT NULL
- Field (name) — chart(20)
- Field (manager)
- Field (managerStartDate)
- Key (managerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (projNo) — chart(10) — Primary key — NOT NULL
- Field (name)
- Key (depID) — char(3) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (WORKS ON)
- Key (ssn) — Primary key — NOT NULL
- Key (ssn2) — char(14) — Foreign key → Untitled.Key — NOT NULL
- Field (projNo)
- Field (hours)
Untitled (DEPENDENT)
- Key (dependentName) — Primary key — NOT NULL
- Field (gender)
- Field (birthDate)
- Field (relationship)
- Field (parent)
- Field (ssn)
- Field
- Key (ssn2) — char(14) — Foreign key → Untitled.Key — NOT NULL