ㅁㅇㄻㅇㄹ
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