Starbucks

Tables (6)

allergy (Untitled3)

  • id — int — Primary key — NOT NULL
  • name — varchar — NOT NULL

beverage (Untitled)

  • id — int — Primary key — NOT NULL
  • name — varchar — Foreign key → category.name — NOT NULL
  • name_en — varchar — NOT NULL
  • name_kr — varchar — NOT NULL
  • image — varchar — NOT NULL
  • size — int — NOT NULL
  • discription — varchar — NOT NULL
  • calory (kcal) — int — NOT NULL — kcal
  • natrium — int — NOT NULL — mg
  • fat — int — NOT NULL — g
  • sugar — int — NOT NULL — g
  • protein — int — NOT NULL — g
  • caffein — int — NOT NULL — mg

category (Untitled2)

  • name — varchar — Primary key — NOT NULL

is_allergy (Untitled5)

  • Key — int — Primary key — NOT NULL
  • id (allergy_id) — int — Foreign key → allergy.id — NOT NULL
  • id (beverage_id) — int — Foreign key → beverage.id — NOT NULL

price (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • naem (name) — varchar — Foreign key → size.naem — NOT NULL
  • id (beverage_id) — int — Foreign key → beverage.id — NOT NULL

size (Untitled4)

  • naem (name) — varchar — Primary key — NOT NULL
  • capacity — int — NOT NULL