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)