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

Untitled