9Block

Tables (39)

Addresses

  • id (addressID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • branchID — Int — Foreign key → Branches.id — NOT NULL
  • id (adminID) — Integer — Foreign key → Branches.adminID — NOT NULL
  • roadAddress — String
  • jibunAddress — String
  • sido — String
  • sigungu — String
  • bname — String
  • postcode — String
  • details — String

Admins

  • id (adminID) — Integer — Primary key — NOT NULL
  • clientScretKey (clientSecretKey) — String
  • email — String
  • password — String

Banners

  • id (bannerID) — Integer — Primary key — NOT NULL
  • title — String
  • description — String
  • type (bannerType) — Integer

BranchAccounts

  • id (branchAccountID) — Integer — Primary key — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • clientScretKey — String
  • username — String
  • password — String
  • type — Integer

BranchKeywords

  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • keywordID — Integer — Foreign key → Keywords.id — NOT NULL

BranchMenus

  • id (branchMenuID) — Integer — Primary key — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • menuID — Integer — Foreign key → Menus.id — NOT NULL
  • status (branchMenuStatus) — Integer

BranchServices

  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • serviceID — Integer — Foreign key → Services.id — NOT NULL

Branches

  • id (branchID) — Integer — Primary key — NOT NULL
  • adminID — Integer — Foreign key → Admins.id — NOT NULL
  • name (branchName) — String
  • mid — String

BusinessHours

  • id (businessHourID) — Integer — Primary key — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • weekdaysStartHour — Integer
  • weekdaysEndHour — Integer
  • weekendStartHour — Integer
  • weekendEndHour — Integer

ClientDevices

  • id (userDeviceID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • adminID — Integer — Foreign key → Admins.id — NOT NULL
  • kioskID — Integer — Foreign key → Kiosks.id — NOT NULL
  • branchAccountID — Integer — Foreign key → BranchAccounts.id — NOT NULL
  • operatingSystem — Integer
  • notificationStatus — Integer
  • fcmToken — String
  • type (clientType) — Integer
  • tid — String

Coupons

  • id (couponID) — Integer — Primary key — NOT NULL
  • discount — Integer
  • description (couponDescription) — String
  • expiryDate (couponExpiryDate) — Date
  • status (couponStatus) — Integer

EventWinners

  • userID — Integer — Foreign key → Users.id — NOT NULL
  • eventID — Integer — Foreign key → Events.id — NOT NULL

Events

  • id (eventID) — Integer — Primary key — NOT NULL
  • couponID — Integer — Foreign key → Coupons.id — NOT NULL
  • description — String
  • expiryDate — DateTime

Gifts

  • id (giftID) — Integer — Primary key — NOT NULL
  • orderID — Integer — Foreign key → Orders.id — NOT NULL
  • recipentID (userID) — Integer — Foreign key → Users.id — NOT NULL
  • id (branchID) — Integer — Foreign key → Orders.branchID — NOT NULL
  • id (userID2) — Integer — Foreign key → Orders.userID — NOT NULL
  • id (adminID) — Integer — Foreign key — NOT NULL
  • message — String
  • colorType — Integer
  • platform — Integer
  • isToMe — Boolean

Images

  • id (imageID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • menuID — Integer — Foreign key → Menus.id — NOT NULL
  • eventID — Integer — Foreign key → Events.id — NOT NULL
  • bannerID — Integer — Foreign key → Banners.id — NOT NULL
  • url (imageURL) — String
  • type (imageType) — Integer
  • status (imageStatus) — Integer

Keywords

  • id (keywordID) — Integer — Primary key — NOT NULL
  • name — String

Kiosks

  • id (kioskID) — Integer — Primary key — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • clientScretKey — String
  • tid — String
  • username — String
  • password — String

Labels

  • id (labelID) — Integer — Primary key — NOT NULL
  • name (labelName) — String

MenuCategories

  • id (menuCategoryID) — Integer — Primary key — NOT NULL
  • name (categoryName) — String
  • status (categoryStatus) — Integer

MenuLabels

  • menuID — Integer — Foreign key → Menus.id — NOT NULL
  • labelID — Integer — Foreign key → Labels.id — NOT NULL

MenuOrderOptions

  • id (menuOrderOptionID) — Integer — Primary key — NOT NULL
  • beverageChoice — Integer
  • beverageCondition — Integer
  • cupType — Integer
  • numberOfEspressoShot — Integer
  • warmBrunch — Boolean

MenuOrderPlatforms

  • menuID — Integer — Foreign key → Menus.id — NOT NULL
  • orderPlatformID — Integer — Foreign key → OrderPlatforms.id — NOT NULL

Menus

  • id (menuID) — Integer — Primary key — NOT NULL
  • menuCategoryID — Integer — Foreign key → MenuCategories.id — NOT NULL
  • name (menuName) — String
  • description (menuDescription) — String
  • nutritionInfo — String
  • price — Integer
  • status (menuStatus) — Integer
  • coffeeOptionType — Integer
  • beverageConditionType — Integer
  • chooseEspressoCount — Boolean
  • chooseBrunchCondition — Boolean

OrderMenus

  • menuID — Integer — Foreign key → Menus.id — NOT NULL
  • menuOrderOptionID — Integer — Foreign key → MenuOrderOptions.id — NOT NULL
  • orderID — Integer — Foreign key → Orders.id — NOT NULL

OrderPlatforms

  • id (orderPlatformID) — Integer — Primary key — NOT NULL
  • name (orderPlatformName) — String

Orders

  • id (orderID) — Integer — Primary key — NOT NULL
  • addressID — Integer — Foreign key → Addresses.id — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • type (orderType) — Integer
  • platform (orderPlatform) — Integer
  • totalAmount — Integer
  • status (orderStatus) — Integer

Payments

  • id (paymentID) — Integer — Primary key — NOT NULL
  • prepadCardID — Integer — Foreign key → PrepadCards.id — NOT NULL
  • tumblerUserRankID — Integer — Foreign key → TumblerUserRanks.id — NOT NULL
  • userCouponID — Integer — Foreign key → UserCoupons.id — NOT NULL
  • orderID — Integer — Foreign key → Orders.id — NOT NULL
  • type (paymentType) — Integer
  • paidAmount — Integer
  • discount — Integer
  • originalAmount — Integer

PointTransactions

  • id (pointTransactionID) — Integter — Primary key — NOT NULL
  • paymentID — Integer — Foreign key → Payments.id — NOT NULL
  • id (orderID) — Integer — Foreign key → Payments.orderID — NOT NULL
  • amount — Integer
  • type (transactionType) — Integer

PrepadCards

  • id (prepadCardID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Addresses.userID — NOT NULL
  • amount — Integer

Reloads

  • id (reloadID) — Integer — Primary key — NOT NULL
  • prepaidCardID — Integer — Foreign key → PrepadCards.id — NOT NULL
  • amount — Integer

Services

  • id (serviceID) — Integer — Primary key — NOT NULL
  • name (serviceName) — String

Tastes

  • id (tasteID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • menuID — Integer — Foreign key → Menus.id — NOT NULL

TumblerUserRanks

  • id (tumblerUserRankID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • type (rankType) — Integer
  • totalPoint — Integer

Tumblers

  • id (tumblerID) — Integer — Primary key — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL
  • name (tumblerName) — String
  • description (tumblerDescription) — String
  • price — Integer
  • imageURL (tumblerImageURL) — String
  • specs (tumblerSpecs) — String

UserBranches

  • userID — Integer — Foreign key → Users.id — NOT NULL
  • branchID — Integer — Foreign key → Branches.id — NOT NULL

UserCoupons

  • id (userCouponID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • couponID — Integer — Foreign key → Coupons.id — NOT NULL
  • status (couponStatus) — Integer

UserMenus

  • id (userMenuID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • menuID — Integer — Foreign key → Menus.id — NOT NULL

UserTumblers

  • id (userTumblerID) — Integer — Primary key — NOT NULL
  • userID — Integer — Foreign key → Users.id — NOT NULL
  • tumblerID — Integer — Foreign key → Tumblers.id — NOT NULL
  • uuid (tumblerUUID) — String

Users

  • id (userID) — Integer — Primary key — NOT NULL
  • uid — String
  • name — String
  • phoneNumber — String
  • email — String
  • passwords — String
  • clientSecretKey — String
  • type (userType) — Integer
  • status (userStatus) — Integer