starbucks_modeling

Tables (4)

Allergy

  • id — Primary key — NOT NULL
  • Field (allergy_name)

Copy Of Allergy (Category)

  • id — Primary key — NOT NULL
  • Field (name)

Copy Of Allergy2 (Drink)

  • id — Primary key — NOT NULL
  • id (category) — Foreign key → Copy Of Allergy.id — NOT NULL
  • Field (name)
  • Field2 (nutrition)
  • Field3 (created_at)
  • Field (updated_at)

Untitled (DrinkAllergy)

  • Key (id) — Primary key — NOT NULL
  • id (allergy_id) — Foreign key → Allergy.id — NOT NULL
  • id (drink_id) — Foreign key → Copy Of Allergy2.id — NOT NULL