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