StarBucks

Tables (4)

Drinks (음료)

  • drink_ID — Integer — Primary key — NOT NULL
  • drink_type_ID (drink_type_ID2) — Integer — Foreign key → category.drink_type_ID — NOT NULL — 음료 종류 ID
  • drink_name_kor — VARCHAR — NOT NULL — 음료 이름(한글)
  • drink_name_eng — VARCHAR — NOT NULL — 음료 이름(영문)
  • drink_image (drink__image) — BLOB — NOT NULL — 음료 사진
  • drink_content — varchar — NOT NULL — 음료정보
  • drink_size_num — Decimal — NOT NULL
  • drink_new — tinyint — 신상정보
  • serving_size — decimal — NOT NULL
  • salt — decimal — NOT NULL
  • saturated_fat — decimal — NOT NULL
  • sugars — decimal — NOT NULL
  • protein — decimal — NOT NULL
  • caffeine — decimal — NOT NULL
  • drink_price — Integer — NOT NULL

allergy (알레르기정보)

  • allergy_ID — Interger — Primary key — NOT NULL — 알레르기 유발요인ID
  • drink_ID — Integer — Foreign key → Drinks.drink_ID — NOT NULL
  • allergy_name — VARCHAR — NOT NULL — 알레르기 유발 요인 명
  • alergy_code — varchar — NOT NULL

category (카테고리)

  • drink_type_ID — Integer — Primary key — NOT NULL — 음료 종류 ID
  • drink_type_name — VARCHAR — NOT NULL — 음료종류이름

drinks_size (Untitled3)

  • Key — Primary key — NOT NULL
  • drink_size_text — VARCHAR
  • drink_size_num — Decimal
  • drink_price — Integer