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

Categories

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