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. 
Image without caption

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.
Image without caption

Helpful?