starbucks

Tables (5)

Allergies (Untitled4)

  • id — varchar(20) — Foreign key → beverages.id — NOT NULL
  • contents
  • allergicNum (Field) — int

beverages (Untitled2)

  • id — varchar(20) — Primary key — NOT NULL
  • name_k — varchar(20)
  • name_e — varchar(20)
  • image — varchar(25)
  • contents — varchar(40)
  • id (id2) — varchar(20) — Foreign key → categorys.id — NOT NULL

categorys (Untitled)

  • id — varchar(20) — Primary key — NOT NULL
  • name — varchar(20)

ingredientinfos (Untitled3)

  • id — varchar(20) — Primary key — NOT NULL
  • size — varchar(30)
  • size_ml — int
  • cal — decimal(4,2)
  • fat — int
  • protein — int
  • na — int
  • sugar — int
  • cafein — int
  • id (id2) — varchar(20) — Foreign key → beverages.id — NOT NULL

sizes (Untitled5)

  • id — int — Primary key — NOT NULL
  • Field