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

City

This data type stores several information about each city for other users to know.

Field Name	Type	Notes
`Airbnb (day)`	number	Stores the cost per day.
`Average Cost of Living`	number	Stores the value of average cost of living.
`Average Monthly Rent`	text	Stores the average monthly rent.
`Average Monthly Rent Description`	text	Stores the average monthly rent description.
`Best Air Carrier`	text	Stores the name of best air carrier.
`Best Coffee Place`	text	Stores the best coffee place.
`Best hospital`	text	Stores the best hospital.
`Best Taxi`	text	Stores the best taxi service.
`Best Telecom`	text	Stores the best telecom network.
`Best University`	text	Stores the best university.
`Budget`	text	Stores the city budget
`Climate description`	text	Stores the climate description.
`Connection description`	text	Stores the connection description.
`Continent`	`Continent`	Stores the continent.
`CostOfLiving description`	text	Stores the cost of living description.
`Country`	`Country`	Stores the country.
`Cultural Diversity`	text	Stores the description of cultural diversity.
`Demography description`	text	Stores the city demographical description.
`Dinner`	number	Stores the dinner cost.
`Economy description`	text	Stores the economy description.
`Education description`	text	Stores the education description.
`For Expath (month)`	number	Stores the costs per person.
`For Family (month)`	number	Stores the costs per family.
`For Local (month)`	number	Stores the costs per local citizen.
`Health description`	text	Stores the healthcare description.
`Hotel (day)`	number	Stores the hotel cost per day.
`Hotel (month)`	number	Stores the hotel cost per month.
`Image`	image	Stores the city-related images.
`Image blur`	image	Stores the blurred image.
`Internet Speed`	text	Stores the interned bandwidth capacity.
`Location`	geographic address	Stores the city location.
`Mark`	`Mark`	Stores the city mark.
`Name`	text	Stores the city name.
`Overview description`	text	Stores the city overview description.
`Population`	number	Stores the population number.
`Population (text)`	text	Stores the population description.
`Power`	text	Stores the city power type.
`Quality of Life Index`	text	Stores the quality of Life index.
`Quality of Life Index Description`	text	Stores the quality of Life index description.
`safety crime`	text	Stores the safety crime situation.
`Safety Description`	text	Stores the safety description.
`Summer High`	text	Stores the summer highest temperature.
`Summer max/min`	text	Stores the summer min and max temperature values.
`Tourism description`	text	Stores the tourism description.
`Transport description`	text	Stores the transport description.
`Unemployment Rate`	text	Stores the city unemployment rate.
`Unemployment Rate Description`	text	Stores the city unemployment rate description.
`Vote`	List of `Votes`	Stores the number of votes.
`Weather`	text	Stores the weather description.
`Winter Low`	text	Stores the winter low temperature value.
`Winter max/min`	text	Stores the winter max and min values.

Continent

This data type shows the continent's information.

Field Name	Type	Notes
`City`	List of `Citys`	Stores the list of cities on the continent.
`Country`	Lit of `Countrys`	Stores the list of countries on the continent.
`Location`	geographic address	Stores the location address.
`Name`	text	Stores the continent name.

Country

This data type stores the country's information.

Field Name	Type	Notes
`City`	List of `Citys`	Stores the list of cities in the country.
`Continent`	`Continent`	Stores the country’s continent.
`flag`	image	Stores the country’s flag.
`Name`	text	Stores the country’s name.

Mark

This data type stores information about the accorded mark.

Field Name	Type	Notes
`AverageRating`	number	Stores the average rating value.
`City`	City	Stores the related city.
`Icon`	image	Stores the score icon.
`Icon_NEW`	image	Stores the score's new icon.
`Number of ratings`	number	Stores the number of ratings.
`Text`	text	Stores the mark name.
`TotalRatingSum`	number	Stores the total rating sum.

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, photo, etc.) and profile information like a list of favorite cities.

Field Name	Type	Notes
`Admin`	yes / no	Stores the user admin status.
`Compare`	List of `Citys`	Stores the list of compared cities.
`Favorite`	List of `Citys`	Stores the list of favorite cities.
`First Name`	text	Stores the user's first name.
`Full Name`	text	Stores the user's full name.
`Last Name`	text	Stores the user's last name.
`Location`	geographic address	Stores the user location.
`Profile image`	image	Stores the profile image.
`Profile photo`	image	Stores the profile photo.
`Vote`	List of `Votes`	Stores the list of votes.

☝

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.

Vote

This data type stores details about voting and allows the user to make votes.

Field Name	Type	Notes
`City`	`City`	Stores the related city.
`Mark`	`Mark`	Stores the related mark.
`Score`	number	Stores the accorded score.
`User`	`User`	Stores the related user.

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.