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 manualBusiness
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.
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.
