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

Message

This data type is used to display the messages under each project.

Field Name	Type	Notes
`messageBody`	text	Holds the content of a message.
`messagePicture`	image	Holds pictures related to a message.

Project

This data type is used to display project-related information.

Field Name	Type	Notes
`projectArchive`	yes / no	Marks a project as archived.
`projectDescription`	image	Hold the first part of the description of a project.
`projectDescriptionProposal`	text	Hold the second part of the description of a project.
`projectFiles`	List of Files	Stores files related to a project.
`projectMessages`	List of `Messages`	Stores messages related to a project.
`projectStaff`	`User`	Determines the staff of the project.
`projectStatus`	`ProjectStatus`	Holds a project status.
`projectTitle`	text	Store the project title.
`projectType`	`ProjectType`	Determines the type of a project.
`projectWordCount`	number	Determines the word count for a project.

Testimonial

This data type is used to display testimonial messages.

Field Name	Type	Notes
`body`	text	Testimonial content will be stored here.
`creator`	text	This will store the testimonial creator.
`Creator_position`	text	This will store the position that the creator occupies.
`Picture`	image	This will store the picture of the testimonial if there is any.

User

This data type is used to display the user-related data.

Field Name	Type	Notes
`TotalActiveProjects`	number	Total number of active project for this user.
`userFullName`	text	User's full name.
`userNextBillingPeriod`	date	User next billing period for his subscription.
`userPhoto`	image	Contains user pic.
`userProjects`	List of `Projects`	Contains a list of projects that are related to this user.
`userSubscriptionActive`	yes / no	Determines whether the user has an active subscription at the moment.
`userSubscriptionCancel`	yes / no	Determines whether the user canceled his subscription.
`userType`	UserType	Determines the user type.

Variable

This data type holds information about variables that can be changed by the platform owner.

Field Name	Type	Notes
`Access_rights`	yes / no	Determines wether demo user has rights to change the platform content.
`TotalActiveProjects`	number	Stores the number of possible active projects.
`TotalArchiveProjects`	number	Stores the number of archived projects.

Variables

As described before this datatype object contains parameters used to speed up the system. If you want to delete it or modify it you should know that this object is linked to some workflows that will need to be modified too.

On the dashboard page find groups Project Archive Wrap and Project Submit Wrap and check the workflows related to them. There we are making changes to the Variable object.

On the API Workflows page find the go archive endpoint where we also are making changes to Variable object.

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.

ProjectStatus

The option set is used to store types of project statuses. It comes with one attribute:

Attribute	Type	Notes
`display`	text	Stores the status of the project.

The options for this set are:

Option	Types
Assigned	Project assigned.
Submitted	Project submitted.
Draft	Project draft.
Completed	Project completed.
Delivered	Project delivered.

ProjectType

The option set is used to determine the type of the project. It comes with one attribute:

Attribute	Type	Notes
`display`	text	Stores the project type.

The options for this set are:

Option	Types
Quora Answer	Quora Answer option.
Video Script	Video Script option.
Twitter Tweet	Twitter Tweet option.
Facebook Post	Facebook Post option.
Press Release	Press Release option.
Product Description	Product Description option.
E-mail Newsletter	E-mail Newsletter option.
Blog Post	Blog Post option.

UserType

The option set is used to determine the user type. It comes with one attribute:

Attribute	Type	Notes
`display`	text	Stores the user type.

The options for this set are:

Option	Types
Admin	Admin option.
Staff	Staff option.
Customer	Customer option.

💡

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 with the modification process.

In order to preview a Note of any data type or field, click on the 💬 icon.