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