Delivery

Tables (15)

Address (Untitled7)

  • 주소ID (addressId) — LONG — Primary key — NOT NULL
  • 고객ID (customerId) — LONG — Foreign key → USER.유저ID — NOT NULL
  • 주소 (address) — STRING
  • 기본주소여부 (isDefault) — BOOLEAN

Base (Untitled6)

  • 생성일 (createdAt) — TIMESTAMP — NOT NULL
  • 수정일 (updatedAt) — TIMESTAMP

Cart (Untitled8)

  • 장바구니ID (cartId) — LONG — Primary key — NOT NULL
  • 고객ID (customerId) — LONG — Foreign key → USER.유저ID — NOT NULL
  • 가게ID (storeId) — LONG — Foreign key → Store.가게ID — NOT NULL

CartItem (Untitled9)

  • 항목ID (cartItemId) — LONG — Primary key — NOT NULL
  • 장바구니ID (cartId) — LONG — Foreign key → Cart.장바구니ID — NOT NULL
  • 메뉴ID (menuId) — LONG — Foreign key → Menu.메뉴ID — NOT NULL
  • 수량 (quantity) — INTEGER
  • 옵션 (Field)

Category (Untitled12)

  • 카테고리ID (categoryId) — Primary key — NOT NULL
  • 이름 (name) — String

CategoryStore (Untitled13)

  • 카테고리스토어 (ca_store_id) — LONG — Primary key — NOT NULL
  • 카테고리ID (categoryId) — Foreign key → Category.카테고리ID — NOT NULL
  • 가게ID (storeId) — LONG — Foreign key → Store.가게ID — NOT NULL

Menu (Untitled4)

  • 메뉴ID (menuId) — LONG — Primary key — NOT NULL
  • 카테고리ID (categoryId) — LONG — Foreign key → MenuCategory.카테고리ID — NOT NULL
  • 이름 (name) — STRING
  • 설명 (descryption) — STRING
  • 가격 (price) — INTEGER
  • 판매여부 (isAvailable) — BOOLEAN

MenuCategory (Untitled3)

  • 카테고리ID (categoryId) — LONG — Primary key — NOT NULL
  • 가게ID (storeId) — LONG — Foreign key → Store.가게ID — NOT NULL
  • 이름 (name) — STRING
  • 우선순위 (priority) — INTEGER

Option (CopyOfUntitled5)

  • 옵션Id (optionId) — LONG — Primary key — NOT NULL
  • 옵션그룹Id (optionGrId) — LONG — Foreign key → OptionGroup.옵션그룹Id — NOT NULL
  • 이름 (name) — STRING
  • 가격 (price) — INTEGER

OptionGroup (Untitled5)

  • 옵션그룹Id (optionGrId) — LONG — Primary key — NOT NULL
  • 메뉴ID (menuId) — LONG — Foreign key → Menu.메뉴ID — NOT NULL
  • 이름 (name) — STRING
  • 다중선택여부 (isMultiple) — BOOLEAN
  • 필수여부 (isRequired) — BOOLEAN

Order (Untitled10)

  • 주문ID (orderId) — LONG — Primary key — NOT NULL
  • 가게ID (storeId) — LONG — Foreign key → Store.가게ID — NOT NULL
  • 고객ID (customerId) — LONG — Foreign key → USER.유저ID — NOT NULL
  • 총금액 (totalPrice) — INTEGER
  • 주문상태 (status) — ENUM

OrderItem (Untitled11)

  • 주문항목ID (orderItemId) — LONG — Primary key — NOT NULL
  • 주문ID (orderId) — LONG — Foreign key → Order.주문ID — NOT NULL
  • 메뉴ID (menuId) — LONG — Foreign key → Menu.메뉴ID — NOT NULL
  • 수량 (quantity) — Integer
  • 금액 (price) — INTEGER
  • 옵션리스트 (options) — LIST

Review (Untitled)

  • 리뷰ID (reviewId) — LONG — Primary key — NOT NULL
  • 고객ID (customerId) — LONG — Foreign key → USER.유저ID — NOT NULL
  • 가게ID (storeId) — LONG — Foreign key → Store.가게ID — NOT NULL
  • 주문ID (orderId) — LONG — Foreign key → Order.주문ID — NOT NULL
  • 내용 (contents) — TEXT
  • 별점 (rating) — TINYINT

Store (Untitled2)

  • 가게ID (storeId) — LONG — Primary key — NOT NULL
  • 고객ID (customerId) — LONG — Foreign key → USER.유저ID — NOT NULL
  • 이름 (name) — STRING
  • 주소 (address) — STRING
  • 전화번호 (phone) — STRING
  • 오픈시간 (openHour) — STRING
  • 마감시간 (closeHour) — STRING
  • 최소주문금액 (minAmount) — BIGDECIMAL

USER (CopyOfUntitled)

  • 유저ID (userId) — LONG — Primary key — NOT NULL
  • 이름 (name) — STRING
  • 이메일 (email) — STRING
  • 비밀번호 (password) — STRING
  • 역할 (userRole) — ENUM