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