sb

Tables (12)

Address

  • addressId — bigint(20) — Primary key — NOT NULL
  • userId — bigint(20) — NOT NULL
  • address — varchar(255) — NOT NULL
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Carts

  • cartId — bigint(20) — Primary key — NOT NULL
  • userId — bigint(20) — NOT NULL
  • storeId — bigint(20) — NOT NULL
  • menuId — bigint(20) — NOT NULL
  • menuOptionId — bigint(20)
  • orderId — bigint(20)
  • quantity — int(11) — NOT NULL
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

CeoReviews

  • reviewId — bigint(20) — Foreign key → Reviews.reviewId — NOT NULL
  • content — varchar(255)
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Coupons

  • counponId — bigint(20) — Primary key — NOT NULL
  • userId — bigint(20) — NOT NULL
  • name — varchar(255) — NOT NULL
  • content — varchar(255)
  • deductedPrice — int(11) — NOT NULL
  • minDeliveryPrice — int(11) — NOT NULL
  • createdDate — timestamp — NOT NULL
  • expiredDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Dibs

  • userId — bigint(20) — Foreign key → Users.userId — NOT NULL
  • storeId — bigint(20) — Foreign key → Stores.storeId — NOT NULL
  • createdDate — timestamp — NOT NULL
  • modifidedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Menu

  • menuId — bigint(20) — Primary key — NOT NULL
  • storeId — bigint(20) — NOT NULL
  • category — varchar(100) — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — int(11) — NOT NULL
  • menuPictureUrl — text
  • popularity — tinyint(1) — NOT NULL — 일반, 인기
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

MenuOption

  • menuOptionId — bigint(20) — Primary key — NOT NULL
  • menuId — bigint(20) — NOT NULL
  • option — varchar(255) — NOT NULL
  • content — varchar(255) — NOT NULL
  • price — int(11) — NOT NULL
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Orders

  • orderId — bigint(20) — Primary key — NOT NULL
  • storeId — bigint(20) — NOT NULL
  • userId — bigint(20) — NOT NULL
  • paymentMethod — varchar(255) — NOT NULL
  • totalPrice — int(11) — NOT NULL
  • requests — varchar(255)
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Reviews

  • reviewId — bigint(20) — Primary key — NOT NULL
  • storeId — bigint(20) — NOT NULL
  • userId — bigint(20) — NOT NULL
  • menuId — bigint(20)
  • rating — int(1) — NOT NULL
  • content — varchar(255)
  • reviewPictureUrl — text
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

StoreImage

  • storeImageId — bigint(20) — Primary key — NOT NULL
  • storeId — bigint(20) — NOT NULL
  • storePictureUrl — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Stores

  • storeId — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — int(1) — NOT NULL
  • category — varchar(20) — NOT NULL
  • address — varchar(255) — NOT NULL
  • storePictureUrl — text
  • phone — varchar(20) — NOT NULL
  • content — varchar(255)
  • minDeliveryPrice — int(11) — NOT NULL
  • deliveryTip — int(11) — NOT NULL
  • minDeliveryTime — int(3)
  • maxDeliveryTime — int(3)
  • rating — decimal(2,1) — NOT NULL
  • dibsCount — int(11) — NOT NULL
  • reviewCount — int(11) — NOT NULL
  • operationHours — varchar(255)
  • closedDays — varchar(255)
  • deliveryAddress — varchar(255)
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL

Users

  • userId — bigint(20) — Primary key — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone — varchar(11) — NOT NULL
  • email — varchar(100) — NOT NULL
  • grade — varchar(100) — NOT NULL — 고마운분, 귀한분, 더귀한분, 천생연분
  • role — varchar(100) — NOT NULL
  • currentAddress — varchar(255)
  • createdDate — timestamp — NOT NULL
  • modifiedDate — timestamp — NOT NULL
  • status — varchar(255) — NOT NULL