mutsa_vacation

Tables (12)

Cart (장바구니)

  • id (장바구니아이디) — Long — Primary key — NOT NULL
  • member_id (회원아이디) — Long — Foreign key → Member.id — NOT NULL

CartItem (장바구니상품)

  • id (장바구니메뉴아이디) — Long — Primary key — NOT NULL
  • menu_id (메뉴아이디) — Long — Foreign key → Menu.id — NOT NULL
  • cart_id (장바구니아이디) — Long — Foreign key → Cart.id — NOT NULL
  • quantity (수량) — Long

CartItemOption (Untitled5)

  • id (장바구니메뉴옵션아이디) — Long — Primary key — NOT NULL
  • cart_item_id (장바구니메뉴아이디) — Long — Foreign key → CartItem.id — NOT NULL
  • option_id (옵션아이디) — Long — Foreign key → Option.id — NOT NULL

Category (Untitled2)

  • id (카테고리아이디) — Long — Primary key — NOT NULL
  • name (카테고리이름) — String

Member (회원)

  • id (회원아이디) — Long — Primary key — NOT NULL
  • login_id (로그인아이디) — String
  • password (비밀번호) — String
  • credit (보유크레딧) — Long

Menu (메뉴)

  • id (메뉴아이디) — Long — Primary key — NOT NULL
  • store_id (가게아이디) — Long — Foreign key → Store.id — NOT NULL
  • name (메뉴이름) — String
  • price (가격) — Long

Option (Untitled4)

  • id (옵션아이디) — Long — Primary key — NOT NULL
  • id (옵션그룹아이디) — Long — Foreign key → OptionGroup.id — NOT NULL
  • name (옵션항목명) — String
  • price (추가금) — Long
  • Field

OptionGroup (Untitled3)

  • id (옵션그룹아이디) — Long — Primary key — NOT NULL
  • id (메뉴아이디) — Long — Foreign key → Menu.id — NOT NULL
  • name (그룹이름) — String
  • Field

OrderItem (Untitled)

  • id (주문메뉴아이디) — Long — Primary key — NOT NULL
  • order_id (주문아이디) — Long — Foreign key → Orders.id — NOT NULL
  • menu_id (메뉴아이디) — Long — Foreign key → Menu.id — NOT NULL
  • quantity (수량) — Long
  • order_price (주문당시가격) — Long

OrderItemOption (Untitled6)

  • id (주문메뉴옵션) — Long — Primary key — NOT NULL
  • option_id (옵션아이디) — Long — Foreign key → Option.id — NOT NULL
  • order_id (주문메뉴아이디) — Long — Foreign key → OrderItem.id — NOT NULL
  • order_price (주문시옵션가격) — Long

Orders (주문)

  • id (주문아이디) — Long — Primary key — NOT NULL
  • member_id (회원아이디) — Long — Foreign key → Member.id — NOT NULL
  • toral_price (주문금액) — Long
  • Field

Store (가게)

  • id (가게아이디) — Long — Primary key — NOT NULL
  • category_id (카테고리아이디) — Long — Foreign key → Category.id — NOT NULL
  • name (가게이름) — String