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.
Important: See Bubble manual information when working with data: https://manual.bubble.io/help-guides/working-with-data; https://manual.bubble.io/core-resources/data.

Data Types

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

Business

This data type stores the details of businesses to be reviewed.
Field Name
Type
Notes
Address
geographic address
Stores the business geographic address.
Address line two
text
Stores the business address, and line.
Approve_delete
yes / no
Stores the business approval status.
block
yes / no
Stores the business blocking status.
Category
Category
Stores the related category.
City
geographic address
Stores the related city.
List of reviews
List of Reviews
Stores the business list of reviews.
Name
text
Stores the business name.
New
yes / no
Stores the business new status.
Open/closed time
List of Open days
Stores the list of times when business is open.
Pending_delete
yes / no
Stores the business pending status.
Phone number
text
Stores the business phone number.
Photos
List of images
Stores the business photos.
Price
text
Stores the business price.
Rating
number
Stores the business rating.
Status
Status
Stores the business status.
Status_delete
text
Stores the business delete status.
Website
text
Stores the business-associated website URL.
website menu
text
Stores the business-associated website URL.

Category

This data type stores the category details.
Field Name
Type
Notes
Cat name
text
Stores the category name.
Icon
image
Stores the category icon.

Open Day

This data type stores the convenient open days to allow for review-purpose visits.
Field Name
Type
Notes
biz Name
text
Stores the business name.
close time
text
Stores the closing time.
day of the week
text
Stores the weekday.
open time
text
Stores the opening time.

Review

This data type stores the reviews carried out on businesses.
Field Name
Type
Notes
Approve_delete
yes / no
Stores the review approval status.
Bussiness ID
Business
Stores the business ID.
Business name
text
Stores the business name.
Cool Rating
number
Stores the rating number.
Edited Review
yes / no
Stores the review editing status.
Funny Rating
number
Stores the rating number.
New
yes / no
Stores the review new status.
Rating
number
Stores the rating number.
Review body
text
Stores the review text.
Status
Status
Stores the review status. Default value - Pending.
Useful Rating
number
Stores the review usefulness rating number.

Search

This data type stores the search key fields.
Field Name
Type
Notes
Descending?
yes / no
Stores the search descending search status.
Display Name
text
Stores the display name.
Search type
text
Stores the search type.

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.
This data type stores the users' bio data (blog, website link, etc.) and profile information like comments made and admin status associated with the user.
Field Name
Type
Notes
admin
yes / no
Stores the admin status.
Age
number
Stores the user age.
blocked
yes / no
Stores the user block status.
Bussines ID
Business
Stores the business ID.
Current location
geographic address
Stores the current geographical location.
Facebook Link
text
Stores the link to Facebook profile.
First Name
text
Stores the user first name.
Gender
text
Stores gender.
Headline
text
Stores the headline text.
I Love…
text
Stores the affirmation.
Last Name
text
Stores the user last name.
My Blog or Website
text
Stores the link to website.
My Last Meal on Earth
text
Stores the affirmation.
My Second Website
text
Stores the website link.
Primary location
geographic address
Stores the user primary location.
Profile Photo
image
Stores the profile photo
The Last Great Book
text
Stores the affirmation.
Tik Tok link
text
Stores the Tik Tok link.
Twitter link
text
Stores the Twitter link.
Upvoted comments (cool)
List of Reviews
Stores the list of upvoted comments.
Upvoted comments (funny)
List of Reviews
Stores the list of upvoted comments.
Upvoted comments (useful)
List of Reviews
Stores the list of upvoted comments.
userSearch
UserSearch
Stores the earlier made searches.
When I'm Not Location-Based
text
Stores the affirmation.
Why You Should Read My Reviews
text
Stores the affirmation.
Youtube link
text
Stores the Youtube link.
ZIP Code
number
Stores the Zip code.
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

UserSearch

This data type stores the earlier made searches.
Field Name
Type
Notes
categorySearch
Category
Stores the category searches.
locationSeach
geographic address
Stores the location search.

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.

Status

This field holds all the options available for the business statuses. It comes with the default "Display" attribute.
The options for this set are:
Option
Types
Pending
Stores the pending status.
Approved
Stores the approved status.
Rejected
Stores the rejected status.
💡
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