ex3
Tables (6)
Untitled (CLIENTS)
- Key (client ssn) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(40)
- Field (phone number) — char(11)
Untitled (DEOENDENTS)
- Key (dependent ssn) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (age) — int (10)
- Key (client ssn) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE JOIN)
- Key (join id) — char(30) — Primary key — NOT NULL
- Key (client ssn) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (association id) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (provider id) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (service identifier) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Field (date) — date
Untitled (SERVICE ASSOCIATION)
- Key (association id) — char(30) — Primary key — NOT NULL
- Key (provider id) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (service identifier) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (PROVIDERS)
- Key (provider id) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(40)
- Field (phone number) — char(11)
Untitled (SERVICES)
- Key (service identifier) — char(30) — Primary key — NOT NULL
- Field (description) — text