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

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

Article_new

This data type stores the list of all article content displayed on the story page.
Field Name
Type
Notes
description
text
Stores the list of booked orders.
image
image
Stores the article-related images.
link
text
Stores the links mentioned in article
name
text
Stores the article name.

BookedOrders

This data type stores the list of all services booked by users to display statistics in admin dashboard.
Field Name
Type
Notes
BookedOrders
List of Orders
Stores the list of booked orders.

CartItem

This data type stores the data on itemd added to the cart.
Field Name
Type
Notes
Product
Product
Stores the name of the added product.
Quantity
number
Stores the number of added products.

Certificates_new

This data type stores the data about added certificates.
Field Name
Type
Notes
image
image
Stores the certificate image.
link
text
Stores the certificate source.
name
text
Stores the certificate name.

Doctor_main_info

This data type stores the data about doctor and clinicians.
Field Name
Type
Notes
Address
geographic address
Stores the clinic address.
BusinessEmail
text
Stores the business email.
CompanyName
text
Stores the company name. Default name - goSPA.
DiscountAmount
number
Stores the discount amount.
DiscountDay
number
Stores the number of days when discount is applied.
DiscountHour
number
Stores the number of hours when discount applied.
Logo
image
Stores the clinic logo.
PhoneNumber
text
Stores the clinic phone number.
ShowThankYouMsg
yes / no
Stores thank you message status.
ThankYouCardBGcolor
text
Stores the background color of thank you message.
ThankYouCardMessage
text
Stores the thank you message text.
ThankYouCardSymbol
image
Stores the thank you message symbol.

Faq

This data type stores the data about frequently asked questions.
Field Name
Type
Notes
answer
text
Stores the answer text.
question
text
Stores the question text,

Feedback

This data type stores the feedback messages submitted by users via contact form located on the contact-us page.
Field Name
Type
Notes
feedbackMessaage
text
Stores the feedback message.
feedbackUser
text
Stores the feedback message author.
feaadbackUserEmail
text
Stores the feedback message author email.

GuestReview

This data type stores the guest reviews details.
Field Name
Type
Notes
GuestName
text
Stores the guest name.
Review
text
Stores the review text.

MedicalCategory

This data type stores the medical categories available.
Field Name
Type
Notes
CategoryName
text
Stores the category name.
image
image
Stores the medical category image.

Message

This data type stores the messages sent by users to the admin.
Field Name
Type
Notes
Email
text
Stores the message author's email.
messageText
text
Stores the message text.
Name
text
Stores the message author's name.

Order

This data type stores the details about medical services booked by the current user.
Field Name
Type
Notes
DiscountAmount
number
Stores the discount amount.
Discounted
yes / no
Stores the discounting status.
Email
text
Stores the user’s email
First Name
text
Stores the user first name.
Last Name
text
Stores the user first name.
Order Details
text
Stores the order details.
OrderColor
text
Stores the order color.
OrderCost
number
Stores the overall order cost.
OrderDate
date
Stores the order date.
OrderedProcedure
Procedure
Stores the ordered procedure.
Phone
text
Stores the user phone.
Time
text
Stores the order time.
User
User
Stores the order author.

Procedure

This data type stores the basic information about salon and beauty care services with pricing and other info.
Field Name
Type
Notes
isAvailable
yes / no
Stores the availability status. Default value - yes.
listdate
List of dates
Stores the availability list of dates.
ProcedureCategory
text
Stores the procedure category.
ProcedureColor
text
Stores the procedure color.
ProcedureDescription
text
Stores the procedure description.
ProcedureDuration
text
Stores the procedure duration.
ProcedureImage
image
Stores the procedure image.
ProcedurePrice
number
Stores the procedure price.
ProcedureDate
date
Stores the procedure date.

Product

This data type stores the basic information about the product in the shop.
Field Name
Type
Notes
inStock
yes / no
Stores the availability status.
isDiscounted
yes / no
Stores the discounting status.
ProductCategory
ShopCategory
Stores the product category.
ProductDescription
text
Stores the product description.
ProductImage
image
Stores the product image.
ProductName
text
Stores the product name.
ProductPrice
number
Stores the product price.
ProductPriceOld
number
Stores the old product price.
ProductRatingNew
List of Ratings
Stores the overall product rating.

Rating

This data type stores the ratings for the products on the website,
Field Name
Type
Notes
Rating
number
Stores the accorded rating.
RatingProduct
product
Stores the rated product.
Review
text
Stores the review text.

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 (Name, Last Name, Phone etc.) and profile information like ordered items associated with the user.
Field Name
Type
Notes
CartItemsList
List of CartItems
Stores the list of items added to the cart.
isAdmin
yes / no
Stores the admin status.
LastName
text
Stores the last name.
Name
text
Stores the name.
OrderedItems
List of CartItems
Stores the list of ordered items.
Phone
text
Stores the phone number.
Type
userType
Stores the user type.
UserBookedOrderList
List of BookedOrderses
Stores the list of booked orders.
UserOrders
List of Orders
Stores the list of orders.
writeRights
yes / no
Stores the write rights status.
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
access rights
yes / no
This field determines demo user permissions.

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