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

Category

This data type contains information about the created categories of the properties (apartments, bungalows, houses, etc.).
It comes with the following fields:
  • color - text - This field will store the color you pick for a category.
  • icon - image - This field will store the icon you pick for a category.
  • id - number - This field will store an id for the category.
  • title - text - This field will store the name you pick for a category.

Conversation

This data type stores the information about messages between users.
It comes with the following fields:
  • listing id - text - This field will store the ID for the listing that is in the conversation.
  • Message List - List of Messages​ - This field will store a list of messages from this conversation.
  • Recipient - ​User​ - This field registers the recipient user of the conversation.

Facility

This data type contains information about the facilities of the property added by the host, e.g. Wi-Fi, TV, etc.
It comes with the following fields:
  • id - number - This field stores the id of a facility.
  • title - text - This field stores a facility title.

Listing

This data type contains information about property details (number of guests that it can fit, location, photos, cost, reviews, etc.).
It comes with the following fields:
  • #of guests - number - This field will store the number of guests in a number format.
  • #of guests (text) - text - This field will store the number of guests in a text format.
  • Category - ​Category​ - This field links the category object with the listing.
  • city - geographic address - This field will store city.
  • country - geographic address - This field will store country.
  • description - text - This field will store the description for the listing.
  • Facilities - List of Facilitys​ - This field stores a list of facilities related to the listing.
  • id - text - This field stores the ID for a listing.
  • location - geographic address - This field stores the geographic location.
  • name - text - This field stores the title of the listing.
  • photolist - List of images - This field stores a list of images that are related to the current listing.
  • price - number - This field stores the price of this listing.
  • rating - number - This field stores the listing's rating.
  • Reservations - List of Reservations​ - This field holds a list of reservations that are related to the listing.
  • review rating - number - This field stores the review rating.
  • reviews - List of Reviews​ - This field attributes a list of reviews to a listing.
  • RoomType - ​RoomType​ - This field stores the room type for the listing.
  • unavailable dates - List of dates - This field stores the dates when this listing is unavailable.

Message

This data type contains information about the message body.
It comes with the following fields:
  • body - text - This field stores the message body.
  • new message?- yes / no - This field marks a message as new/read.
💡
Tip: Boolean field new message? used for highlighting new unread messages.

Reservation

This data type contains information about property booking (who booked it, for what dates, for how long, etc.). It comes with the following fields:
  • #of guests - number - This field stores the number of guests.
  • check-in date - date - This field stores the check-in date.
  • check-out date - date - This field stores the check-out date.
  • date range - date range - This field stores the range of dates.
  • Listing​ - Listing​ - This field stores the listing for which a reservation was made.
  • listing name - text - This field stores the listing's name.
  • nights - number - This field stores the number of nights for a reservation.
  • Owner - ​User​ - This field stores the owner of the listing from this owner.
  • price - number - This field stores the reservation price.
  • Rented By - ​User​ - This field stores the renter.
  • room id - text - This field stores room ID.

Review

Users can rate and review properties after checkout and this information is held in this data type.
It comes with the following fields:
  • Listing - ​Listing​ - This field will store the listing for which the review was created.
  • listing id - text - This field stores the id of a listing.
  • rating - number - This field stores the rating number of a review.
  • review body - text - This field stores body of a review.
  • review rating - number - This field stores the rating number of a review.

RoomType

This data type contains information about the type of room (private room, shared room, entire house).
It comes with the following fields:
  • id - number - This field stores the id of a room type.
  • title - text - This field stores the title of a room type

Search

This data type contains information about search filters that can be used when users want to find a property.
It comes with the following fields:
  • #of guests - number - This field will contain the number of guests.
  • check-in date - date - This field will contain the check in date.
  • check-out date - date - This field will contain the check out date.
  • city - geographic address - This field will contain the geographical address of a city.
  • country - geographic address - This field will contain the geographical address of a country.
  • list of dates - List of dates - This field will contain a list of dates.
  • location - geographic address - This field is used for the location.
Note: The data type has privacy rule applied. See the 💬 in database under Privacy section for details.

User

Bubble applications have a built-in User data type that acts like any type that it is created in database. For instance, you can modify a user, delete a user, list them in a repeating group, etc. To learn more, see Bubble manual.This data type stores information about users who join the platform.
It comes with the following fields:
  • about me - text - This field will store the about me information of a user.
  • admin - yes / no - This field determines the admin rights for a user.
  • Conversations - List of Conversations​ - This field will store a list of conversations a user started with another user.
  • first name - text - This field will store a user's first name.
  • id - text - This field stores a unique ID for a user at the registration phase.
  • last name - text - This field will store a user's last name.
  • new message? - yes / no - This field determines if a use has new messages.
  • phone Number - text - This field will store a user phone number.
  • profile photo - image - This field will store a user's photo.
  • seller id - text - This field will store the seller ID of a user.
  • User Favorites - List of Listings​ - This field will store a list of listing a user has added to his favorites.
  • User Listings - List of Listings​ - This field will store a list of listings created by a user.
  • User Reviews - List of Reviews​ - This field will store a list of listing a user has added to his favorites.
Note: The data type has privacy rule applied. See the 💬 in database under Privacy section for details.

Embedded Notes in Bubble Editor

This template comes with explicit notes for Data types and their 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 chat icon.
Image without caption

Helpful?