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