exercise5
Tables (6)
Untitled (ORGANIZATION)
- Key (orgaId) — Primary key — NOT NULL
- Field (orgaName)
Untitled (PRODUCTOR)
- Key (prodId) — Primary key — NOT NULL
- Field (prodName)
- Field (prodAddress)
- Field2 (prodPhone)
- Key (orgaId) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceCode) — Primary key — NOT NULL
- Key (prodId) — Foreign key → Untitled.Key — NOT NULL
- Field (serviceContent)
- Field (serviceDate)
Untitled (CUSTOMER)
- Key (custId) — Primary key — NOT NULL
- Field (custName)
- Field (custAddress)
- Field (custPhone)
- Key (orgaId) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (dependId) — Primary key — NOT NULL
- Field (dependName)
- Field (dependAge)
- Key (custId) — Foreign key → Untitled.Key — NOT NULL
Untitled (PER_SERVICE)
- Key (custId) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceCode) — Foreign key → Untitled.Key — NOT NULL
- Key (prodId) — Foreign key → Untitled.Key — NOT NULL