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)