mutsa_vacation_session
Tables (14)
Cart (장바구니)
- cart_id (카트아이디) — Long — Primary key — NOT NULL
- user__id (유저아이디) — Long — Foreign key → User.user__id — NOT NULL
CartItem (장바구니아이템)
- cartitem_id (카트아이템아이디) — Long — Primary key — NOT NULL
- cart_id (카트아이디) — Long — Foreign key → Cart.cart_id — NOT NULL
- menu_id (메뉴아이디) — Long — Foreign key → Menu.menu_id — NOT NULL
- item_quantity (아이템수량) — Long
CartItemOption (카트아이템옵션)
- cio_id (카트아이템옵션아이디) — Long — Primary key — NOT NULL
- cartitem_id (카트아이템아이디) — Long — Foreign key → CartItem.cartitem_id — NOT NULL
- option_id (옵션아이디) — Long — Foreign key → Option.option_id — NOT NULL
Category (카테고리)
- category__id (카테고리아이디) — Long — Primary key — NOT NULL
- tag_name (태그이름) — String
CreditTransaction (크레딧거래내역)
- ct_id (크레딧거래내역아이디) — Long — Primary key — NOT NULL
- user__id (유저아이디) — Long — Foreign key → User.user__id — NOT NULL
- type (거래유형) — enum
- amount (충전/사용 금액) — Long
- balance_after (잔약) — Long
- order_id (주문아이디) — Long — Foreign key → Order.order_id — NOT NULL
Menu (메뉴)
- menu_id (메뉴아이디) — Long — Primary key — NOT NULL
- store_id (스토어아이디) — Long — Foreign key → Store.store_id — NOT NULL
- menu_name (메뉴이름) — String
- menu_price (메뉴가격) — Long
Option (옵션)
- option_id (옵션아이디) — Long — Primary key — NOT NULL
- option_name (옵션이름) — String
- extra_price (추가금액) — Long
- og_id (옵션그룹아이디) — Long — Foreign key → OptionGroup.og_id — NOT NULL
OptionGroup (옵션 그룹)
- og_id (옵션그룹아이디) — Long — Primary key — NOT NULL
- menu_id (메뉴아이디) — Long — Foreign key → Menu.menu_id — NOT NULL
- group_name (옵션그룹이름) — String
- selection_type (단일/다중선택) — enum
- is_required (필수선택) — Boolean
Order (주문)
- order_id (주문아이디) — Long — Primary key — NOT NULL
- user__id (유저아이디) — Long — Foreign key → User.user__id — NOT NULL
- total_price (총금액) — Long
- used_credit (차감크레딧) — Long
- order_status (주문상태) — enum
OrderItem (주문아이템)
- orderitem_id (주문아이템아이디) — Long — Primary key — NOT NULL
- menu_id (메뉴아이디) — Long — Foreign key → Menu.menu_id — NOT NULL
- order_store_id (주문가게아이디) — Long — Foreign key → OrderStore.order_store_id — NOT NULL
- item_quantity (아이템수량) — Long
- item_price (아이템가격) — Long
- item_name (아이템이름) — String
OrderItemOption (주문아이템옵션)
- oio_id (주문아이템옵션) — Long — Primary key — NOT NULL
- orderitem_id (주문아이템아이디) — Long — Foreign key → OrderItem.orderitem_id — NOT NULL
- option_id (옵션아이디) — Long — Foreign key → Option.option_id — NOT NULL
- option_price (옵션추가금액) — Long
- option_name (옵션이름) — String
OrderStore (주문가게)
- order_store_id (주문가게아이디) — Long — Primary key — NOT NULL
- order_id (주문아이디) — Long — Foreign key → Order.order_id — NOT NULL
- store_id (스토어아이디) — Long — Foreign key → Store.store_id — NOT NULL
- store_name (가게이름) — String
Store (가게)
- store_id (스토어아이디) — Long — Primary key — NOT NULL
- category__id (카테고리아이디) — Long — Foreign key → Category.category__id — NOT NULL
- store_name (가게이름) — String
- store_rating (가게평점) — Double
- image_url (이미지링크) — String
User (사용자)
- user__id (유저아이디) — Long — Primary key — NOT NULL
- login_id (로그인아이디) — String
- password (비밀번호) — String
- credit (결제크레딧) — Long