This section consists of Database Things and fields description for every thing which is part of the template.

Introduction

To get to the Data section, click the database icon on the left side tabs in Bubble Editor.

Data Types

Most of the template content is directly pulled from the database. Please do not delete an entire Data Thing unless you are sure of what you are doing. However, feel free to delete any template content you prefer.
Note: In case you have accidentally deleted a data type - no worries! Bubble lets you restore💪the deleted data type. Clicking on 'show deleted types' or 'show deleted fields' from the Data → Data types tab will reveal the deleted items, and a 'restore' button will appear next to each deleted entry. Simply click 'restore', to restore a field or data type.
💡
Tip: Aside from the below-listed data types and fields, Bubble creates these default fields visible in each data type: Creator, Modified Date, Created Date and Slug, except for the User data type. The User data type will have the following fields: email, Modified Date, Created Date and Slug. These fields' values can be used in workflows, conditional formatting, etc. To learn more, see the Bubble manual.

Alpha_num

This data type is used to categorize brands by the first letter or number in their name. It contains a list of brands with the said alphanumeric as their first character.
Field Name
Type
Notes
brands
List of brands
Stores the list of brands.
is_number
yes / no
Stores the brand numerical status.
value
text
Stores the first letter of the brand name.

Brand

This data type contains the name, logo, description website, and gift card of the specific brand. It also contains offers, giftcards and giftcard sales related info. Also, it tells the specific categories the brand falls under.
Field Name
Type
Notes
categories
List of categories
Stores the brand category.
description
text
Stores the brand description.
featured
yes / no
Stores the brand featured status.
giftbit_code
text
Stores the brand giftbit code.
giftcard_details
text
Stores the brand gift card details.
giftcard_thumb
image
Stores the gift card thumbnail image.
giftcards
List of giftcards
Stores the list of giftcards.
giftcards_sold
number
Stores the number of sold giftcards.
giftcards_sold_amount
number
Stores the amount of giftcards sold.
logo
image
Stores the brand logo image.
max_giftcard_cashback
number
Stores the gift card cashback value.
name
text
Stores the brand name.
offers
List of offers
Stores the list of offers.
slug
text
Stores the brand slug.
website
text
Stores the brand link.

Category

This data type contains information about the list of brands that are under each category, it also contains the specific name of the category.
Field Name
Type
Notes
brands
List of brands
Stores the list of brands within category.
brands_count
number
Stores the number of brands.
name
text
Stores the category name.
slug
text
Stores the category slug.
tags
List of texts
Stores the list of category tags.
tags_text
text
Stores the tags text.

Gift Card

This data type contains the information on each gift cards supplied by the specific brand, it contains the price of the gift card, an optional cashback amount, and also has a field that determines whether the giftcard should be visible for purchase or not.
Field Name
Type
Notes
amount
number
Stores the gift card value.
available
yes / no
Stores the gift card availability status.
brand
brand
Stores the related brand.
cashback
number
Stores the cashback value.
cashback_percentage
number
Stores the cashback percentage.
number_sold
number
Stores the number of sold giftcards.
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Offer

This data type contains information about the various offers of a particular brand, it contains the discount on that offer, the offer type (promo or sale), the offer code or sale link, the offer expiry date, offer usage, and some descriptive info.
Field Name
Type
Notes
brand
brand
Stores the related brand.
code
text
Stores the offer code.
description
text
Stores the offer description.
discount_amount
number
Stores the discount amount.
discount_percentage
number
Stores the discount percentage value.
discount_type
text
Stores the discount type.
expiry_date
date
Stores the expiry date.
featured
yes / no
Stores the offer featured status.
label
text
Stores the offer label.
latest_usage_date
date
Stores the lates usage date.
offer_type
text
Stores the offer type (sale, code).
picture
image
Stores the offer picture.
sale_link
text
Stores the sale link.
usage_count_total
number
Stores the total usage count.
users
List of Users
Stores the list of users that used the offer.

Order

This data type contains information on all orders purchased by customers, it contains the basic details of the specific customer and also includes the order_items, date of payment, the channel of payment, payment reference, status of the order and additional info.
Field Name
Type
Notes
email
text
Stores the user email.
first_name
text
Stores user first name.
id
text
Stores user ID.
items
List of order_items
Stores the list of ordered items.
last_name
text
Stores the user last name.
method
text
Stores the payment method.
paid_date
date
Stores the paid date.
purchased_giftcards
List of purchased_giftcards
Stores the list of purchased gift cards.
reference
text
Stores the charge ID.
status
text
Stores the order status.
total
number
Stores the order total amount.
total_due
number
Stores the order total due.

Order_item

This data type stores a giftcard and the quantity being purchased by the customer. The user's cart contains a list of order items before they are stored in order.
Field Name
Type
Notes
brand
brand
Stores the item’s brand.
cashback_subtotal
number
Stores the amount of cashback.
giftcard
giftcard
Stores the used giftcard.
quantity
number
Stores the item quantity.
quantity_list
List of numbers
Stores the quantity list.
subtotal
number
Stores the subtotal amount.

Purchased_giftcards

This data type stores data about singular giftcard units that have been purchased (via Giftbit API or other). They contain a unique redemption link for said giftcard amount and some additional info.
Field Name
Type
Notes
brand
brand
Stores the related brand.
campaign_id
text
Stores the campaign ID.
cashback
number
Stores the cashback amount.
giftcard
giftcard
Stores the related gift card.
link
text
Stores the link to purchased gift card.
order
order
Stores the related order.

User

Bubble applications have a built-in User data type that acts like any type that is created in a database. For instance, you can modify a user, delete a user, list them in a repeating group, etc. To learn more, see the Bubble manual.
This data type contains information about the users like name, photo, phone number etc. It has a cart, list of orders & purchased giftcards, list of saved offers as well as a wallet for storing rewards (cashback earnings).
Field Name
Type
Notes
cart
List of order_items
Stores the cart list of ordered items.
current_order
order
Stores the current order.
favorite_brands
List of brands
Stores the list of favorite brands.
first_name
text
Stores the user first name.
full_name
text
Stores the user full name.
giftcards
List of purchasedgiftcards
Stores the user’s list of gift cards.
is_admin
yes / no
Stores the user admin status.
last_name
text
Stores the user last name.
orders
List of orders
Stores the list of orders.
phone
text
Stores the user phone.
photo
image
Stores the user photo.
saved_offers
List of offers
Stores the list of saved offers.
signup_channel
text
Stores the type of signup channel.
state
text
Stores the user’s state.
wallet
number
Stores the user wallet.
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Variable

This data type is used to (not) allow users to use the admin features within the app.
Field Name
Type
Notes
writeRights
yes / no
This field determines demo user permissions.

Option Sets

💡
Tip: Option sets define a static list of choices for use in dropdowns, pop-ups, etc. Options inside the sets have at least a text display, but they can have additional attributes defined in the Data tab. To learn more, see Bubble Manual.
Below you can find the list of option set attributes and options.

Categories

This field holds all the options available for the product listing categories.
Attribute
Type
Notes
img
image
Stores the category image.
link
text
Stores the category link.
The options for this set are:
Option
Types
Fitness
Stores the category name.
Fashion
Stores the category name.
Beauty
Stores the category name.
Travel
Stores the category name.
Restaurants
Stores the category name.
Electronics
Stores the category name.
💡
Tip: To find the pages where the options sets are used, use the App Search Tool within the editor.
Image without caption

Embedded Notes in Bubble Editor

This template comes with explicit Notes for Database fields, Option sets and their fields, and Privacy rules, which will guide you through the modification process.
In order to preview a Note of any data type or field, click on the 💬 icon.
Image without caption