StarbucksTest
Tables (6)
Beverages
- id — int — Primary key
- name — varchar(20) — NOT NULL
- id (id2) — int — Foreign key → Categorys.id
Beverages_Info
- id (id2) — int — Foreign key → Beverages.id
- eng_name — varchar(30) — NOT NULL
- desc — varchar(100) — NOT NULL
- size (size2) — varchar(10) — Foreign key → Size.size — NOT NULL
Categorys
- id — int — Primary key
- name — varchar(20) — NOT NULL
Nutrient
- id (id2) — int — Foreign key → Beverages_Info.id
- kcal — int — NOT NULL
- salt — tinyint — NOT NULL
- saturated_fatty_acid — tinyint — NOT NULL
- sugars — tinyint — NOT NULL
- protein — tinyint — NOT NULL
- caffeine — tinyint — NOT NULL
Size
- size — varchar(10) — Primary key — NOT NULL
- ml (ml) — int — NOT NULL
- fl_oz — tinyint — NOT NULL