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.
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 manualComment
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 | 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 | 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.
