E3
Tables (5)
CUSTOMER
- Key (cID) — char(13) — Primary key — NOT NULL
- Field (cName) — char(30)
- Field (address) — char(50)
- Field (phone) — char(11)
- Field (typeNeed) — char(30)
Untitled (DEPENDENT)
- Key (dID) — char(13) — Primary key — NOT NULL
- Field (dName) — char(30)
- Key (cID) — char(13) — Foreign key → CUSTOMER.Key — NOT NULL
- Field (relation) — char(10)
Untitled (SERVICE)
- Key (sID) — char(5) — Primary key — NOT NULL
- Field (sName) — char(30)
- Field (type) — char(30)
- Field (descrription) — text
Untitled (SERVICE_PROVIDER)
- Key (pID) — char(5) — Primary key — NOT NULL
- Key (sID) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Field (pName) — char(30)
- Field (address) — char(50)
- Field (phone) — char(11)
- Field (affiliation) — char(30)
Untitled (SERVICE_DATE)
- Key (sID) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Field (sDate) — date
- Key (cID) — char(13) — Foreign key → CUSTOMER.Key — NOT NULL