starbucks

Tables (4)

allergy

  • id — int — Foreign key → products.id — NOT NULL
  • subjects — varchar

categories

  • id — int — Primary key — NOT NULL — 카테고리이름
  • name — varchar — NOT NULL
  • info — varchar

nutrition_info

  • id — int — Foreign key → products.id — NOT NULL
  • serving_size — tinyint — NOT NULL
  • natrium — tinyint — NOT NULL
  • saturated_fat — tinyint — NOT NULL
  • sugars — tinyint — NOT NULL
  • protein — tinyint — NOT NULL
  • caffeine — tinynt — NOT NULL

products

  • id — int — Primary key — NOT NULL
  • image — varchar
  • name_kor — varchar — NOT NULL
  • name_eng — varchar
  • info — varchar
  • allergy — varchar
  • id (id2) — int — Foreign key → categories.id — NOT NULL — 카테고리이름