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 — 카테고리이름