Kiosk
Tables (4)
CoffeeMenu (커피메뉴)
- Key — Primary key — NOT NULL
- menu_name (메뉴명) — text
- menu_eng (영문명) — text
- detail (부가설명) — text
- syrup (시럽) — text
- whipping (휘핑포함) — boolean
DesertMenu (디저트메뉴)
- Key — Primary key — NOT NULL
- menu_name (메뉴명) — text
- menu_eng (영문명) — text
- detail (부가설명) — text
- meterial (시럽) — List<text>
- kcal (열량) — number
- carbon (탄수화물) — number
- sugar (당류) — number
- protein (단백질) — number
- fat (지방) — number
- s_fat (포화지방) — number
- na (나트륨) — number
- Field
OrderList (주문내역)
- Key (카) — 타입 — Primary key — NOT NULL
- menu (메ㅠ) — text
- name (유저이름) — text
- email (메일주소) — text
- Field
- user (유저) — User — Foreign key → User.Key — NOT NULL
- Field2
User (사용자)
- Key (카) — 타입 — Primary key — NOT NULL
- user_id (유저아이디) — text
- name (유저이름) — text
- email (메일주소) — text
- Field