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

Comment

This data type is used to display the comments under each post.
Field Name
Type
Notes
comment
text
Stores the text body of comment.
Downvoters
List of Users
Stores the list of users that downvoted this comment.
points
number
Indicates the number of points allocated to a comment by users.
post
post
Attributes the comment to a post.
Replies
List of Replys
Stores the replies to a comment.
Upvoters
List of Users
Stores the list of users that upvoted the comment.
user
User
Indicates the author of comment.

Community

This data type is used to display the data specific to a certain community.
Field Name
Type
Notes
Category
Community_Category
This field determines the category for this community.
image
image
This field holds the image for the community.
Members
List of Users
This field holds a list of users that belong to this community.
name
text
This field holds community's name.
Posts
List of Posts
This field stores a list of posts related to this community.

Community_Category

This data type is used to display the category of certain community.
It comes only with 1 field:
Field Name
Type
Notes
name
text
Stores the name of community category.

Conversation

This data type is used to display the conversation between users.
Field Name
Type
Notes
ConversationUsers
List of Users
This field stores the participants of a conversation.
Messages
List of messages
This field stores the messages from within a conversation.

Message

This data type is used to display the message text and associated files.
Field Name
Type
Notes
body
text
This field stores the body of the message.
image
image
This field store an image from a message.
NewFor
List of Users
This field stores a list of users who this message is new for.
read
yes/no
This field determines whether a comment is read or not. Default value - no.
recipient
User
This field stores the recipient of the message.
sender
User
This field stores the message sender.
subject
text
This field stores the subject of a message.

Post

This data type is used to display the information related to a specific post.
Field Name
Type
Notes
aggregate_vote_count
number
This field is used for storing the difference value obtained from downvotes - upvotes.
Comments
List of Comments
This field stores a list of comments related to this post.
community
This field stores the community to which this post belongs.
controversy_score
number
This is the score that we receive from division between aggregate vote count and vote count.
created-by
User
Records the creator of the post.
details
text
Stores details about a post.
downvote_count
number
This is the number of downvotes a post gets.
Downvoters
List of Users
This is a list of users who downvoted a particular post.
exclude_from_all
yes/no
Used for filtering results.
exclude_from_popular
yes/no
Used for filtering results.
image
image
Stores an image related to the post.
is_reported
yes/no
Marks a post as reported.
reported_reason
text
Contains reason for reporting.
title
text
Post's title.
total_interactions
number
Records total interactions per hour.
total_interactions_hour
number
Records total interactions per hour.
total_vote_count
number
Records total number of votes.
upvote_count
number
Records total number of upvotes.
Upvoters
List of Users
Stores a list of upvoters.
views_count
number
Stores the number of views a post had.

Reply

This data type is used to display the replies on comments.
Field Name
Type
Notes
body
text
Body of the reply.
comment
This field stores the comment for which a reply was created.
Downvoters
List of Users
This field stores a list of users who downvoted a reply.
points
number
This field stores a reply points.
Upvoters
List of Users
List of users who upvoted the reply.
user
User
Stores the user who left a reply.

User

This data type is used to display the user related information.
Field Name
Type
Notes
admin
yes / no
Indicates if user has admin rights or not.
ban
yes / no
Indicates if user is banned or not. Default value - no.
followers
List of Users
Indicates the number of followers.
following
List of Users
Stores the list of followed users.
image
image
Stores the user avatar image.
username
text
Stores the user name.

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?