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