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