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.

Conversation

This data type stores information about the conversation between admin and user sending his inquiry.

Field Name	Type	Notes
`messages`	List of `messages`	This field stores messages related to a conversation.
`users`	List of `Users`	This field stores users related to a conversation.

Drafts

This data type stores drafts of posts made by users.

Field Name	Type	Notes
`content1`	text	Stores text of the draft.
`content2`	text	Stores text of draft of thread message.
`date`	date	Stores the date when draft was made.
`image1`	image	Stores the image inside the image post.
`image2`	image	Stores the image inside the image thread post.
`posted`	yes / no	Specifies if the post was published or not, used as display filtering option for RG.
`social`	`Social`	Stores the name of SM where the draft will be posted.
`thread`	yes / no	Specifies if the post contains a thread.
`type`	text	Specifies the type of the post (text, image or video).
`video1`	file	Stores the information about the video inside the video post.
`video2`	file	Stores the information about the video inside the video thread post.

MenuTab

This data type stores information about tabs names available on the mobile version

Field Name	Type	Notes
`name`	text	Stores the names of tab categories.
`number`	number	Stores the tab order number.

Message

Stores information about the message within a conversation between the admin and the user.

Field Name	Type	Notes
`content`	text	Contains the text of the message.
`conversation`	`Conversation`	Stores information about the conversation of the admin with the user.
`guest`	yes / no	Specifies if the conversation implies a guest user.
`guestName`	text	Stores the name of the guest user who sent the message.
`new`	yes / no	Specifies if the message is new.
`reply`	text	Contains the reply to the message.
`user_email`	text	Contains the email of the user who sent the. message.

Post

Stores information about the post text.

Field Name	Type	Notes
`cancelScheduleAPI`	text	Stores the publication ID, to be used for editing or publication.
`content1`	text	Stores the taxt of the post
`content2`	text	Stores the information about the text inside the text thread post.
`date`	date	Stores the date when the post was published.
`draft`	Drafts	Stores information about the post Draft.
`image1`	image	Stores the information about the image inside the image post.
`image2`	image	Stores the information about the image inside the image thread post.
`posted`	yes / no	Specifies if the post was published or not.
`publishing`	yes / no	Value publishing = yes is used as a display condition for "publishing ..." text, when a post is created.
`social`	`Social`	Stores the SM where the post will be published.
`thread`	yes / no	Specifies if the post contains a thread.
`type`	text	Specifies the type of the post (text, image, video).
`video1`	file	Stores the video inside the video post.
`video2`	file	Stores the video inside the video thread post.

Posting_Day

Stores information about the date when post is scheduled for posting.

Field Name	Type	Notes
`day_number`	text	Stores information about the week date number of the publishing date.
`day_text`	text	Stores information about the week day of the publishing date.
`posting_times`	List of dates	Stores information about the time for the scheduled publishing.

Posting_Schedule

Stores information about the posting schedule.

Field Name	Type	Notes
`Posting_days`	List of `Posting_days`	Stores information about the posting days that a posting schedule includes.

Social

Social contains within itself information about the connected social media on both the front and backend part of the app.

Field Name	Type	Notes
`picture`	image	Contains social media's logo
`posting`	`Posting_Schedule`	Stores information about the posting schedule for this SM.
`posts`	List of `posts`	Stores information about the list of posts for this SM.
`social`	text	Stores the name of the SM.
`socialConst`	`socialConst`	Contains the name of the SM.
`socialType`	`socialConstType`	Specifies the type of SM used (for test purposes we added Twitter, FB and Linkedin, but just Twitter is configured.)
`timeZone`	`timeZone`	Stores information about the time zone used for publishing posts.
`twitter_oAuth`	text	It allows an authorized Twitter developer App to access private account information or perform a Twitter action on behalf of a Twitter account.
`twitter_oAuth_secret`	text	Stores information about Twitter access token. An access token and access token secret are user-specific credentials used to authenticate OAuth 1.0a API requests. They specify the Twitter account the request is made on behalf of.
`twitterBanner`	image	Stores Twitter banner image.
`user`	`User`	This field is used to separate the current user from other users, as everywhere is it used the Current user value.
`username`	text	Contains information about the username used for this SM.

SocialMedia

Stores information about the social media connected.

Field Name	Type	Notes
`icon`	image	Stores information about the icon of the social media connected.
`soon`	yes / no	Specifies if the SM is has a "coming soon" icon.
`title`	text	Stores information about the title of the social media connected.

Subscription

Stores information about user's subscription to the platform.

Field Name	Type	Notes
`canceledByAdminDate`	date	This stores information about the date of user's subscription cancellation by the admin.
`stripeSubscription`	`Stripe Subscription`	This stores information about the Stripe ID of the user's subscriptions.
`SubscriptionActive`	yes / no	Specifies if thee subscription is currently active.
`SubscriptionCanceled`	yes / no	Specifies if thee subscription is currently cancelled.
`SubscriptionID`	text	Stores to the subscription ID.
`SubscriptionNextBilling`	date	Stores the next date of subscription billing.
`SubscriptionPlanName`	text	Stores the name of the Subscription (Plan).

Token

This data type is used for the Twitter API call setup.

Field Name	Type	Notes
`data`	text	Stores the token required for Twitter API call.

User

Stores information about platform users.

Field Name	Type	Notes
`admin`	yes / no	Specifies if the user has admin rights.
`currentSocial`	`Social`	Specifies currently used SM.
`currentSocialMedia`	`socialMedia`	Stores the name of the most recently added SM.
`email`	text	Contain user's email.
`name`	text	Contain user's name.
`picture`	image	Stores user's avatar.
`posts`	List of `posts`	Contains information about posts published by the user.
`socialsList`	List of `Socials`	Stores the number of social accounts.
`subscription`	`Subscription`	Stores information about the current subscription of the user.
`trialStarted`	date	Specifies the date when trial subscription was started.

Variable

This data type is used to (not) allow users to use the admin features within the app.

Field Name	Type	Notes
`writeRights`	yes / no	This field determines demo user permissions.

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.

SocialConstType

This option set is used for choosing between registered social networks.

Attribute	Type	Notes
`logo`	image	Stores the Social Media logo.
`soon`	yes / no	Stores the status of SM in the template (already added or not).

The options for this set are:

Option	Notes
Twitter	Twitter option.
Facebook	Facebook option.
Instagram	Instagram option.
LinkedIn	LinkedIn option.

TimeZone

This option set is used for timezone setup.

Attribute	Type	Notes
`hour`	number	Stores the hour.
`seconds`	number	Stores seconds.

The options for this set are:

Option	Notes
Local time zone	Local time zone selection
+14:00	An option.
+13:45	An option.
+13:00	An option.
+12:00	An option.
+11:00	An option.
+10:30	An option.
+10:00	An option.
+9:30	An option.
+9:00	An option.
+8:45	An option.
+8:00	An option.
+7:00	An option.
+6:30	An option.
+6:00	An option.
+5:45	An option.
+5:30	An option.
+5:00	An option.
+4:30	An option.
+4:00	An option.
+3:30	An option.
+3:00	An option.
+2:00	An option.
+1:00	An option.
-1:00	An option.
-2:00	An option.
-3:00	An option.
-3:30	An option.
-4:00	An option.
-5:00	An option.
-6:00	An option.
-7:00	An option.
-8:00	An option.
-9:00	An option.
-9:30	An option.
-10:00	An option.
-11:00	An option.
-12:00	An 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 through the modification process. In order to preview a Note of any data type or field, click on the 💬 icon.