2023_webDB_week3_ex3
Tables (5)
Untitled (FAMILY)
- Key (famSsn) — char(14) — Primary key — NOT NULL
- Field (famName) — char(30)
- Field (famAge) — int
- Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceCode) — char(2꙼̈0) — Primary key — NOT NULL
- Field (description) — text
Untitled (PROVIDER)
- Key (provNo) — int — Primary key — NOT NULL
- Field (provName) — char(2꙼̈0)
- Field (address) — char(70)
- Field (phone) — char(13)
- Key (serviceCode) — char(2꙼̈0) — Foreign key → Untitled.Key — NOT NULL
Untitled (CUSTOMER)
- Key (customerSsn) — char(14) — Primary key — NOT NULL
- Field (customerName) — char(30)
- Field (address) — char(70)
- Field (phone) — char(13)
Untitled (PROVIDED SERVICE)
- Key (serviceDate) — date — Primary key — NOT NULL
- Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceCode) — char(2꙼̈0) — Foreign key → Untitled.Key — NOT NULL