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 manualCategories
This data type stores the main titles of freelancer jobs.
Field Name | Type | Notes |
icon | image | Stores the category image. |
name | text | Stores the category name. |
subcategories | List of Subcategorises | A category can have more than one subcategory |
Celebrity Users
This data type stores the words of famous people who use Fairlance.
Field Name | Type | Notes |
brand | text | Stores the brand name. |
name | text | Stores the user name. |
picture | image | Stores the user picture. |
quote | text | Stores the quoted text. |
Conversation
This data type stores all the message information of the users.
Field Name | Type | Notes |
messages | List of Messageses | Stores the list of exchanged messages. |
participants | List of Users | Stores the list of chat participants. |
Conversation List
This data type stores all communications kept in the application.
Field Name | Type | Notes |
Conversation | List of Conversations | Stores the list of conversations. |
Freelancer Staff
This data type stores the data belonging to freelancer users, unlike the normal user.
Field Name | Type | Notes |
about | text | Stores the freelance description. |
address | text | Stores the freelance address. |
birthdate | date | Stores the freelance birthdate. |
jobcards | List of Job Cards | A freelancer can have more than one job cards. |
masterskills | List of Masterskillses | A freelancer can have more than one skill. |
numberofreviews | number | Number of users who rate Freelancer. |
profession | Profession | Freelancer's profession |
rating | number | Freelancer's in-app score (out of 5) |
sumofrating | number | Total of Freelancer's in-app score. (Necessary to calculate the overall average.) |
title | text | Stores the freelance title. |
user | User | Stores the related registered user. |
Job Card
This data type stores the job postings created by freelancers..
Field Name | Type | Notes |
banner | image | Job card photo appearing while listing |
description | text | Stores the job card description. |
duedate | number | Stores the job card due date. |
freelancer staff | Freelancer Staff | Stores the author of job card. |
images | List of images | Stores the list of related images. |
price | number | Stores the job price. |
price details | text | Stores the price details. |
subcategory | Subcategories | Subcategory the job card is linked to. |
title | text | Stores the job card title. |
Masterskills
This data type stores the skills that users can select and demonstrate.
Field Name | Type | Notes |
name | text | Stores the skill name. |
Messages
This data type stores the messages posted by users.
Field Name | Type | Notes |
content | text | Stores the message content. |
conversation | Conversation | Every message is linked to a conversation. |
Notifications
This data type stores the notification details that are used to inform users.
Field Name | Type | Notes |
content | text | Stores the notification content. |
is Read | yes / no | Boolean data field indicating whether a user has read the notification. |
user | User | Stores the notification author. |
Orders
This data type stores the ordered Freelancer jobs.
Field Name | Type | Notes |
is voted | yes / no | The data field used to determine whether the user was rated after an order. |
jobcard | Job Card | The job card the order is attached to. |
status | text | Stores the order status. |
Profession
This data type stores the business areas that you can create for users to show.
Field Name | Type | Notes |
name | text | Stores the profession name. |
Subcategories
This data type stores the subcategories under the main categories.
Field Name | Type | Notes |
category | Categories | Stores the related category. |
name | text | Stores the subcategory name. |
User
Bubble applications have a built-in User data type that acts like any type that is created in a database. For instance, you can modify a user, delete a user, list them in a repeating group, etc.
This data type stores the users' bio data (role, photo, etc.) and profile information like username and chats or discussions associated with the user.
Field Name | Type | Notes |
Conversation List | Conversation List | As each user is created, we create a blank conversation list so she/he can start talking.
At the same time, we keep user-specific conversations in this area. |
description | text | Stores the user description. |
firstname | text | Stores the user first name. |
freelancer staff | Freelance Staff | Stores the freelance staff. |
picture | image | Stores the user image. |
role | text | Stores the user role (Freelancer, Admin, User). |
surname | text | Stores the user surname. |
telephone number | text | Stores the user phone number. |
username | text | Stores the user nickname. |
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.
Variable
This data type is used to (not) allow users to use the admin features within the app.
Field Name | Type | Notes |
access rights | 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.
Screen Resolution
This field holds all the options available for the screen resolution options.
Attribute | Type | Notes |
pixel | number | Stores the pixel width value. |
The options for this set are:
Option | Types |
Desktop | Stores the screen resolution option. |
Laptop (L) | Stores the screen resolution option. |
Macbook | Stores the screen resolution option. |
Tablet Pro | Stores the screen resolution option. |
Tablet | Stores the screen resolution option. |
Mobile | Stores the screen resolution 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.
