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

Access Rights

This data type contains information about the current limitations of admin features.
It comes with one field:
Field Name
Type
Notes
access rights
yes / no
This field will store the current restriction status.

Bed

This data type contains information about the types of beds available within the listing.
It comes with the following fields:
Field Name
Type
Notes
bedType
Bed Type (OS)
Stores the bed type.
listing
Listing
Stores the related listing.
qty
number
Stores the bed quantity.

Category

This data type contains information about the created categories of the properties (apartments, bungalows, houses, etc.).
It comes with the following fields:
Field Name
Type
Notes
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.

Chat

This data type stores information about chats created between the users and the AI helper bot.
It comes with the following fields:
Field Name
Type
Notes
guest email
text
Stores the guest user's email.
List of Messages
Chat
Stores the list of messages within the chat.
Title
yes / no
Stores the chat title
User
User
Stores the User that initiated the chat.

Chat Message

This data type stores information about chat messages exchanged within the chatbot.
It comes with the following fields:
Field Name
Type
Notes
body
text
Stores the message body.
chat
Chat
Stores the related chat.
from bot?
yes / no
Stores the message status.
guest email
text
Stores the guest user's email.
User
User
Stores the current logged in user.

Conversation

This data type stores information about messages between users.
It comes with the following fields:
Field Name
Type
Notes
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:
Field Name
Type
Notes
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:
Field Name
Type
Notes
#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:
Field Name
Type
Notes
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? is 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:
Field Name
Type
Notes
#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:
Field Name
Type
Notes
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:
Field Name
Type
Notes
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:
Field Name
Type
Notes
#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.
This data type stores information about users who join the platform.
It comes with the following fields:
Field Name
Type
Notes
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