2023_webDB_ex03
Tables (6)
Untitled (CUSTOMER)
- Key (customerSsn) — char(14) — Primary key — NOT NULL
- Field (customerName) — char(20)
- Field (customerAddress) — char(200)
- Field (customerPhone) — char(13)
Untitled (FAMILY)
- Key (familySsn) — char(14) — Primary key — NOT NULL
- Field (familyName) — char(20)
- Field (familyAge) — int
- Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceCode) — char(10) — Primary key — NOT NULL
- Field (serviceDescription) — text
- Key (agentID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE_AGENT)
- Key (agentID) — char(10) — Primary key — NOT NULL
- Field (agentName) — char(20)
- Field (agentAddress) — char(200)
- Field (agentPhone) — char(13)
Untitled (PROVIDE_SERVICE)
- Key (customerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (provideDate) — date
Untitled (NOTE)
- Key (noteId) — char(10) — Primary key — NOT NULL
- Field (description) — text
- Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL