배달의민족
테이블 (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)