20221013ex3
Tables (4)
Untitled (CUSTOMER)
- Key (customerID) — ingeger — Primary key — NOT NULL
- Field (ssn) — char(20)
- Field (name) — char(20)
- Field (address) — char(20)
- Field (phone) — integer(20)
- Key (serviceCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPENDANT)
- Key (depenID) — char(10) — Primary key — NOT NULL
- Key (customerID) — ingeger — Foreign key → Untitled.Key — NOT NULL
- Field (ssn) — char(14)
- Field (name) — char(20)
- Field (age) — char(14)
- Key (providerID) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceCode) — char(20) — Primary key — NOT NULL
- Field (description) — text
Untitled (SERVICE PROVIDER)
- Key (providerID) — char(20) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (phone) — char(11)
- Key (customerID) — ingeger — Foreign key → Untitled.Key — NOT NULL