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