Exercise7
Tables (5)
SHOES (PRODUCT)
- Key (productCode) — Primary key — NOT NULL
- Field (productName)
- Field (productPrice)
- Field (description)
- Field (picture)
Untitled (PROVIDER)
- Key (provId) — Primary key — NOT NULL
- Field (provDate)
Untitled (PRODUCT_CATEGORY)
- Key (productCode) — Foreign key → SHOES.Key — NOT NULL
- Key (provId) — Foreign key → Untitled.Key — NOT NULL
Untitled (CUSTOMER)
- Key (customId) — Primary key — NOT NULL
- Field (customName)
- Field (customAddress)
- Field (customPhone)
- Field (customGender)
Untitled (PRODUCT_PURCHASE)
- Key (productCode) — Foreign key → SHOES.Key — NOT NULL
- Key (customId) — Foreign key → Untitled.Key — NOT NULL
- Field (purchaseDate)
- Field (purchaseCnt)