0504workshop
Tables (4)
Center (center)
- Drink ID (drink_id) — INT(10) — Foreign key → Drink.Drink ID — NOT NULL
- Snack ID (snack_id) — INT(10) — Foreign key → Snack.Snack ID — NOT NULL
- Store ID (store_id) — INT(10) — Foreign key → Store.Store ID — NOT NULL
- Drink Count (drink_count) — INT(100)
- Snack Count (snack_count) — INT(100)
Drink (drink)
- Drink ID (drink_id) — INT(10) — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
- Price (price) — VARCHAR(100)
Snack (snack)
- Snack ID (snack_id) — INT(10) — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
- Price (price) — VARCHAR(100)
Store (store)
- Store ID (store_id) — INT(10) — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
- Location (location) — VARCHAR(255)
- Tel (tel) — VARCHAR(100)