delivery
Tables (10)
Cart (장바구니)
- id (장바구니아이디) — BIGINT — Primary key — NOT NULL
- member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
CartItem (장바구니메뉴)
- id (장바구니메뉴아이디) — BIGINT — Primary key — NOT NULL
- cart_id (장바구니아이디) — BIGINT — Foreign key → Cart.id — NOT NULL
- menu_id (메뉴아이디) — BIGINT — Foreign key → Menu.id — NOT NULL
- quantity (수량) — INT
CartItemOption (장바구니메뉴옵션)
- id (장바구니메뉴옵션아이디) — BIGINT — Primary key — NOT NULL
- cart_item_id (장바구니메뉴아이디) — BIGINT — Foreign key → CartItem.id — NOT NULL
- menu_option_id (메뉴옵션아이디) — BIGINT — Foreign key → MenuOption.id — NOT NULL
Member (회원)
- id (회원아이디) — BIGINT — Primary key — NOT NULL
- login_id (아이디) — VARCHAR
- password (비밀번호) — VARCHAR
- name (이름) — VARCHAR
- credit (크레딧) — INT
Menu (메뉴)
- id (메뉴아이디) — BIGINT — Primary key — NOT NULL
- store_id (가게아이디) — BIGINT — Foreign key → Store.id — NOT NULL
- name (메뉴이름) — VARCHAR
- description (메뉴설명) — VARCHAR
- price (가격) — INT
MenuOption (메뉴옵션)
- id (메뉴옵션아이디) — BIGINT — Primary key — NOT NULL
- menu_id (메뉴아이디) — BIGINT — Foreign key → Menu.id — NOT NULL
- option (옵션) — VARCHAR
- content (내용) — VARCHAR
- price (가격) — INT
Order (주문)
- id (주문아이디) — BIGINT — Primary key — NOT NULL
- member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
- total_price (총주문금액) — INT
- status (주문상태) — VARCHAR
OrderItem (주문메뉴)
- id (주문메뉴아이디) — BIGINT — Primary key — NOT NULL
- order_id (주문아이디) — BIGINT — Foreign key → Order.id — NOT NULL
- menu_id (메뉴아이디) — BIGINT — Foreign key → Menu.id — NOT NULL
- quantity (수량) — INT
- order_price (주문시가격) — INT
OrderItemOption (주문메뉴옵션)
- id (주문메뉴옵션아이디) — BIGINT — Primary key — NOT NULL
- order_item_id (주문메뉴아이디) — BIGINT — Foreign key → OrderItem.id — NOT NULL
- menu_option_id (메뉴옵션아이디) — BIGINT — Foreign key → MenuOption.id — NOT NULL
- order_price (주문시가격) — INT
Store (가게)
- id (가게아이디) — BIGINT — Primary key — NOT NULL
- name (가게이름) — VARCHAR
- address (주소) — VARCHAR
- thumbnail (음식썸네일) — VARCHAR
- category (음식카테고리) — VARCHAR
- rating (평점) — DECIMAL(2,1)