starbucks

Tables (5)

allergic_factor

  • menu_name — varchar(50) — Foreign key → products.menu_name — NOT NULL
  • soy_bean — TINYINT(1) — NOT NULL
  • milk — TINYINT(1) — NOT NULL
  • eggs — TINYINT(1) — NOT NULL
  • wheat — TINYINT(1) — NOT NULL
  • nuts — TINYINT(1) — NOT NULL
  • seafood — TINYINT(1) — NOT NULL
  • peach — TINYINT(1) — NOT NULL

categories

  • category_id — tinyint — Primary key — NOT NULL
  • category_name — varchar(20) — NOT NULL

menu_size

  • id — varchar(10) — Primary key — NOT NULL
  • size — varchar(30) — NOT NULL
  • capacity — smallint — NOT NULL

nutritions

  • menu_name — varchar(50) — Foreign key → products.menu_name — NOT NULL
  • calory — smallint — NOT NULL
  • carbo — decimal
  • protein — decimal
  • sodium — decimal
  • saturated_fat — decimal
  • caffeine — decimal
  • id — varchar(10) — Foreign key → menu_size.id — NOT NULL

products

  • menu_name — varchar(50) — Primary key — NOT NULL
  • category_id — tinyint — NOT NULL — fk
  • menu_eng_name — varchar(50) — NOT NULL
  • menu_description — varchar(200) — NOT NULL
  • menu_image — longblob — NOT NULL
  • is_new — TINYINT(1) — NOT NULL
  • is_limited — TINYINT(1)
  • category_id (category_id2) — tinyint — Foreign key → categories.category_id — NOT NULL