baemin
Tables (21)
Address
- memberID — bigint — Foreign key → MemberInfo.memberID — NOT NULL
- address — text
- postCode — int
- type — char(1)
- status — char(1)
Coupon
- couponID — bigint — Primary key — NOT NULL
- memberID — bigint — Foreign key → Member.memberID
- totalPrice — int — NOT NULL
- leastPrice — int — NOT NULL
- name — text — NOT NULL
- code — text — NOT NULL
- status — char(1) — NOT NULL
- receivedAt — timestamp — NOT NULL
- expiresAt — timestamp — NOT NULL
FeeDetail
- shopID — bigint — Foreign key → Shop.shopID — NOT NULL
- fee — int — NOT NULL
- minPrice — int
- maxPrice — int — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
GiftCard
- giftCardID — bigint — Primary key — NOT NULL
- memberID — bigint — Foreign key → Member.memberID
- totalPrice — int — NOT NULL
- leftPrice — int — NOT NULL
- name — text — NOT NULL
- from — text — NOT NULL
- imgURL — text
- status — char(1) — NOT NULL
- receivedAt — timestamp — NOT NULL
- expiresAt — timestamp — NOT NULL
Heart
- heartID — bigint — Primary key — NOT NULL
- memberID — bigint — Foreign key → Member.memberID — NOT NULL
- shopID — bigint — Foreign key → Shop.shopID — NOT NULL
- status — char(1)
- createdAt — timestamp
- updatedAt — timestamp
Level
- levelID — int — Primary key — NOT NULL
- orderCount — bigint
Member
- memberID — bigint — Primary key — NOT NULL
- levelID — int — Foreign key → Level.levelID — NOT NULL
- name — varchar(20) — NOT NULL
- nickname — varchar(20)
- email — text
- password — text
- createdAt — timestamp
- updatedAt — timestamp
- status — char(1)
MemberInfo
- memberID — bigint — Foreign key → Member.memberID — NOT NULL
- profileURL — text
- phone — varchar(12)
- createdAt — timestamp
- updatedAt — timestamp
MemberSettings
- memberID — bigint — Foreign key → Member.memberID — NOT NULL
- mailReceive — char(1)
- smsReceive — char(1)
- shopNumberSave — char(1)
- allowMultiLogin — char(1)
- useSafeNumber — char(1)
- showOrderCount — char(1)
- privacyPolicy — char(1)
Menu
- menuID — bigint — Primary key — NOT NULL
- shopID — bigint — Foreign key → Shop.shopID — NOT NULL
- menuName — varchar(50) — NOT NULL
- price — int — NOT NULL
- description — text
- imgURL — text
- type — text — NOT NULL
- limit — char(1) — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
MenuOption
- optionID — bigint — Primary key — NOT NULL
- menuID — bigint — Foreign key → Menu.menuID — NOT NULL
- optionType — VARCHAR(30) — NOT NULL
- optionDescription — text
OptionDetail
- optionID — bigint — Foreign key → MenuOption.optionID — NOT NULL
- optionName — VARCHAR(30)
- optionPrice — int
Order
- orderID — bigint — Primary key — NOT NULL
- memberID — bigint — Foreign key → Member.memberID — NOT NULL
- address — text
- disposable — char(1) — NOT NULL
- sideDish — char(1) — NOT NULL
- requestShop — text
- saveShop — char(1) — NOT NULL
- requestDeliver — text
- saveDelivery — char(1) — NOT NULL
- status — char(1) — NOT NULL
- estimatedArrival — timestamp
- createdAt — timestamp — NOT NULL
- orderedAt — timestamp — NOT NULL
OrderDriver
- orderID — bigint — Foreign key → Order.orderID — NOT NULL
- driverID(FK) (driverID) — bigint
OrderLine
- orderLineID — bigint — Primary key — NOT NULL
- orderID — bigint — Foreign key → Order.orderID — NOT NULL
- menuID — bigint — Foreign key → Menu.menuID — NOT NULL
- quantity — int — NOT NULL
OrderPay
- paymentID — int — Foreign key → Payment.paymentID — NOT NULL
- orderID — bigint — Foreign key → Order.orderID — NOT NULL
- totalPrice — int — NOT NULL
- deliveryFee — int — NOT NULL
Payment
- paymentID — int — Primary key — NOT NULL
- cashReceipt — char(1)
- cashReceiptNumber — varchar(12)
- status — char(1) — NOT NULL
Review
- reviewID — bigint — Primary key — NOT NULL
- orderID — bigint — Foreign key → Order.orderID — NOT NULL
- shopID — bigint — Foreign key → Shop.shopID — NOT NULL
- content — text
- rating — float
- imgURL — text
- createdAt — timestamp
- updatedAt — timestamp
- status — char(1)
ReviewComment
- reviewID — bigint — Foreign key → Review.reviewID — NOT NULL
- shopID — bigint — Foreign key → Review.shopID — NOT NULL
- content — text
- createdAt — timestamp
- updatedAt — timestamp
- statuss (status) — char(1)
- Field
Shop
- shopID — bigint — Primary key — NOT NULL
- shopName — varchar(50) — NOT NULL
- shopAddress — text
- deliveryFee — int — NOT NULL
- leastPrice — int
- operationHours — text — NOT NULL
- type — text
- imgURL — text — NOT NULL
- status — text — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
ShopDetail
- shopID — bigint — Foreign key → Shop.shopID — NOT NULL
- shopDescription — text — NOT NULL
- holidays — text — NOT NULL
- origin — text
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL