2024-ex(3)
Tables (5)
Untitled (CLIENT)
- Key (clientSsn) — char(15) — Primary key — NOT NULL
- Field (clientName) — char(20)
- Field (clientAddress) — char(30)
- Field (clientPhoneNumber) — char(11)
Untitled (DEPENDENT)
- Key (dependentSsn) — char(15) — Primary key — NOT NULL
- Field (dependentName) — char(20)
- Field (dependentAge) — char(3)
- Key (clientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceCode) — char(10) — Primary key — NOT NULL
- Field (description) — text
Untitled (SERVICE_PROVIDER)
- Key (proID) — char(10) — Primary key — NOT NULL
- Field (proName) — char(20)
- Field (proAddress) — char(30)
- Field (proPhoneNumber) — char(11)
Untitled (SERVICE-MATCHING)
- Key (clientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (proID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (serviceDate) — date