Exercise3
Tables (4)
ServiceProvider (Untitled)
- Key (ServiceCode) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (CusID) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (DepenID) — int(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (Customer)
- Key (CusID) — int(13) — Primary key — NOT NULL
- Field (CusName) — char(20)
- Field (CusADD) — text
- Field (CusPhone) — int(15)
Untitled (Dependents)
- Key (DepenID) — int(13) — Primary key — NOT NULL
- Field (DepenName) — char(20)
- Field (DepenADD) — text
- Field (DepenAge) — int(2)
- Key (CusID) — int(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (Service)
- Key (ServiceCode) — int(20) — Primary key — NOT NULL
- Key (CusID) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (DepenID) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Field (ServiceDes) — longtext
- Field (ServiceRec) — date