cafe
Tables (7)
DesertProduct (디저트상품)
- unique_id (고유키값) — text — Primary key — NOT NULL
- name (상품명) — text
- price (가격) — number
- image (상품이미지) — image
- description (설명) — text
- eng_name (상품 영문명) — text
- nuturition_description (영양정보 설명) — text
- kcal (열량) — number
- carbohydrates (탄수화물) — number
- sugar (당류) — number
- protein (단백질) — number
- fat (지방) — number
- saturated_fat (포화지방) — number
- sodium (나트륨) — number
- raw_materials (원재료) — text
- is_best (추천여부) — boolean
DrinkProduct (음료상품)
- unique_id (고유키값) — text — Primary key — NOT NULL
- name (상품명) — text
- price (가격) — number
- image (상품이미지) — image
- description (설명) — text
- eng_name (상품 영문명) — text
MilkOption (우유옵션)
- unique_id (고유키값) — number — Primary key — NOT NULL
- milk_option (우유옵션) — text
OrderDetails (주문내역)
- unique_id (고유키값) — text — Foreign key → User.unique_id — NOT NULL
ProductType (상품타입)
- unique_id (고유키값) — text — Primary key — NOT NULL
- product_type_display (옵션값디스플레이) — text
- product_type_real (실제 값) — text
SyrupOption (시럽옵션)
- unique_id (고유키값) — number — Primary key — NOT NULL
- syrup_option (시럽옵션) — text
User (유저)
- unique_id (고유키값) — text — Primary key — NOT NULL
- name (성함) — text
- username (아이디) — text
- email (이메일) — text
- password (비밀번호) — text