2023_SLI_EX3
Tables (5)
Untitled (CLIENT)
- Key (clientID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (phone) — integer(20)
Untitled (DEPENDENT)
- Key (ssn) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (age) — char(100)
- Key (clientID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceID) — char(10) — Primary key — NOT NULL
- Field (service provider) — char(20)
- Field (description) — text
- Field (serviceDate) — date
Untitled (SERVICE PROVIDER)
- Key (providerID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (phone) — integer(20)
- Key (serviceID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Service Use)
- Key (serviceID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (clientID) — char(10) — Foreign key → Untitled.Key — NOT NULL