Data Dictionary

CART_ENTRIES

Contains one row for every item that has been placed in a cart. For example, if an order is created with items X, Y, and Z, you can expect one row in CART_ENTRIES for each of X, Y, and Z. The INDEX column in CART_ENTRIES refers to the position of the entry in the cart. INDEX starts at zero.

This table does not include the options for each cart entry (e.g., pickles, mustard). For options, refer to CART_ENTRIES_OPTIONS.

Foreign Keys:

• ORDER_ID references DIGITAL_ORDERS.ORDERS.ORDER_ID.

• ORDER_ID references DIGITAL_ORDERS.ORDERS_HISTORY.ORDER_ID.

ORDERS

Contains the latest state for each digital order.

Foreign Keys:

• ORDER_ID references DIGITAL_ORDERS.ORDERS_HISTORY.ORDER_ID.

• HEADER_REF_ID references TLOG.HEADERS.HEADER_REF_ID.

• USER_ID references DIGITAL_USERS.USERS.USER_ID.

• USER_ID references DIGITAL_USERS.USERS_HISTORY.USER_ID.

USERS

Contains each user’s latest data.

USERS_HISTORY

Contains a row for a user’s initial state plus every subsequent change made to the user’s profile. The primary key for this table is USER_ID and UPDATE_TIME.

Foreign Keys:

• USER_ID references DIGITAL_USERS.USERS.USER_ID.

TRANSACTIONS and

Data representing the following actions that happen to a loyalty users. Actions include:

• Redeeming incentives.

• Earning or using points, for both guest users and identified users.

• The system granting points to the user through support agents, marketing campaigns, or completed quests.

• The system deducting points from the user due to expiration.

This table also includes information about the details of the purchase (when tied to an order) like subtotal amount, the payment type, which POS Vendor processed it, and so on. The transactions are tied back to the individual loyalty user or guest user (if available) and the RBI order (if applicable).

TRANSACTION_CART_ENTRIES

Contains one row for every item that has been placed in a cart. For example, if an order is created with items X, Y, and Z, you can expect one row in CART_ENTRIES for each of X, Y, and Z.

Foreign Keys:

• TRANSACTION_ID references TRANSACTIONS

USERS

Data representing the loyalty platform’s users. These users are different from an RBI user in the app. However, one is always tied to the other. These users are an extension to the RBI user allowing them to access the loyalty platform. This table includes some personal information about the user such as their birthday, email, and name. It also holds loyalty related information such as the user’s points balance.

DMP_ORDERS

Contains the most updated event for each order in the DOP platform

DMP_MENU_SELECTION

Each Menu item for the last event of the order

DMP_ORDER_HISTORY

Contains one row for every status state that each order has been in.

DMP_EVENT_STATUS

One row for every order containing the aggregated status in EVENTS_LIST column

DMP_COMPLAINTS

Contains all the complaints opening from the platform

DMP_PAUSE_SERVICE

Contains each change in the event of service availability