배달의민족

테이블 (9)

Basket

  • Key (basketId) — int — 기본 키 — NOT NULL
  • Field (userId) — int
  • Field (storeId) — int
  • Field (menuId) — int
  • Field (menuCounts) — int
  • Field (createAt) — timestamp
  • Field (updateAt) — timestamp

Coupon

  • Key (couponId) — int — 기본 키 — NOT NULL
  • Field (storeId) — int
  • Field (contents) — text
  • Field (expirationDate) — timestamp
  • Field (createAt) — timestamp
  • Field (updateAt) — timestamp

Menu

  • Key (menuId) — int — 기본 키 — NOT NULL
  • Field (storeId) — int
  • Field (price) — int
  • Field (title) — varchar(50)
  • Field (info) — text
  • Field (imageUrl) — text
  • Field (createAt) — timestamp
  • Field (updateAt) — timestamp

Order

  • Key (orderId) — int — 기본 키 — NOT NULL
  • Field (reqRiderContents) — varchar(100)
  • Field (reqStoreContents) — varchar(100)
  • Field (payment) — char(1)
  • Field (createAt) — timestamp
  • Field (updateAt) — timestamp

Point

  • Key (pointId) — int — 기본 키 — NOT NULL
  • Field (userId) — int
  • Field (storeId) — int
  • Field (savedPoint) — int
  • Field (expirationDate) — timestamp
  • Field (createAt) — timestamp

Review

  • Key (reviewId) — int — 기본 키 — NOT NULL
  • Field (storeId) — int
  • Field (menuId) — int
  • Field (userId) — int
  • Field4 (rate) — int
  • Field (contents) — text
  • Field (comment) — text

Store

  • Key (storeId) — int — 기본 키 — NOT NULL
  • Field (categoryId) — int
  • Field (title) — varchar(100)
  • Field (contents) — text
  • Field (minimumOrderPrice) — int
  • Field (recentReviewCounts) — int
  • Field (recentCommentCounts) — int
  • Field (phoneNum) — varchar(20)
  • Field (wishedCounts) — int
  • Field (OpeningTime) — datestamp
  • Field (closingTime) — time
  • Field (closedDayd)
  • Field (deliveryArea) — varchar(50)
  • Field (deliveryTip) — int
  • Field (ownerName) — varchar(20)
  • Field (businessName) — varchar(20)
  • Field (businessAddress) — text
  • Field (businessId) — int

User

  • Key (userId) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(20)
  • Field (nickname) — varchar(20)
  • Field (profileImg) — text
  • Field (email) — varchar(50)
  • Field (phoneNum) — varchar(20)
  • Field (address) — text
  • Field (mailFlag) — char(1)
  • Field (smsFlag) — char(1)
  • Field (status) — char(1)
  • Field (createAt) — timestamp
  • Field (updateAt) — timestamp

UserCoupon

  • Key (userId) — int — 기본 키 — NOT NULL
  • Field (couponId) — int
  • Field (used) — char(1)