Starbucks
Tables (6)
allergy (Untitled3)
- id — int — Primary key — NOT NULL
- name — varchar — NOT NULL
beverage (Untitled)
- id — int — Primary key — NOT NULL
- name — varchar — Foreign key → category.name — NOT NULL
- name_en — varchar — NOT NULL
- name_kr — varchar — NOT NULL
- image — varchar — NOT NULL
- size — int — NOT NULL
- discription — varchar — NOT NULL
- calory (kcal) — int — NOT NULL — kcal
- natrium — int — NOT NULL — mg
- fat — int — NOT NULL — g
- sugar — int — NOT NULL — g
- protein — int — NOT NULL — g
- caffein — int — NOT NULL — mg
category (Untitled2)
- name — varchar — Primary key — NOT NULL
is_allergy (Untitled5)
- Key — int — Primary key — NOT NULL
- id (allergy_id) — int — Foreign key → allergy.id — NOT NULL
- id (beverage_id) — int — Foreign key → beverage.id — NOT NULL
price (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- naem (name) — varchar — Foreign key → size.naem — NOT NULL
- id (beverage_id) — int — Foreign key → beverage.id — NOT NULL
size (Untitled4)
- naem (name) — varchar — Primary key — NOT NULL
- capacity — int — NOT NULL