Data Types
Last updated
Was this helpful?
Last updated
Was this helpful?
The Data section allows you to manage and structure all database elements essential to the template. To open it, click the database icon in the left panel of the Bubble Editor.
Each data type includes built-in fields that are automatically created and managed by the system. These fields cannot be modified or deleted, as they are essential for tracking ownership and changes to the data:
Creator: The user who created the entry.
Creation Date: The timestamp indicating when the entry was created.
Modified Date: The timestamp showing the last time the entry was updated.
โจ Tip: How to Find Where a Data Field is Used in the Application
โจ Tip: In the application there is also an internal system of notes with description of fields and data types.
Data type description: This data type is used to store information about announcements sent to application users from the application admin. It includes fields to identify the receivers, the content of the announcement, and to track who viewed it.
index
number
Sequence number for the app announcement.
receivers
List of users who receive this announcement.
subject
text
The subject of the announcement, summarizing its content.
text
text
The main content of the announcement.
user type
user type
The type of user to whom the announcement is addressed.
viewed
List of users who have already viewed the announcement.
Data type description: This data type is used to store category related information such as title, number of gigs in a given category and related images. It helps to organise different types of gigs such as โProgrammingโ, โMusic & Audioโ, โBusinessโ...
gig number
number
Number of gigs belonging to this category.
image black
image
Picture for category preview in black colour.
image white
image
Picture for category preview in white colour.
name
text
Name or title of the category
Data type description: This data type is used to store personal certificates that can be linked to a seller's profile for display. It allows for showcasing qualifications or achievements relevant to the seller's services.
certification
text
The name or description of the certification.
Data type description: This data type is designed to facilitate chat interactions between clients and sellers regarding specific gigs.
gig
The specific gig associated with the chat.
messages
Collection of messages exchanged in the chat.
users
List of users participating in the chat (client and seller).
Data type description: This data type stores information about the educational background of the seller, including the names of institutions where they studied. This information is displayed on the seller's profile.
education
text
The name of the educational institution attended by the seller.
Data type description: This data type is used to encapsulate all relevant information about a gig offered by a seller, including its description, pricing, associated media, and feedback from users.
cellations count
number
The number of cancelled orders for the current gig.
category
Category associated with the gig.
demo content?
yes / no
Indicates whether the given gig is demo content created for viewing the template. Demo content cannot be deleted or modified by test users.
description
text
Detailed description of the gig.
highest price
number
The maximum price for the gig.
images
List of images
Collection of images associated with the gig.
index
number
The gig sequence number is unique for each seller individually.
is hidden?
yes / no
Indicates if the gig is hidden from view.
lowest price
number
The minimum price for the gig.
orders
List of orders related to the gig.
orders count
number
Total count of orders for the gig.
packages
Different packages offered for the gig.
pdfs
List of files
Collection of PDF files related to the gig.
rating
number
Average rating for the gig.
reviews
Collection of reviews for the gig.
tags
List of texts
Tags associated with the gig for search and categorization.
title
text
Title of the gig.
views
List of views or view counts for the gig.
views number
number
Total number of views for the gig.
Data type description: This data type stores the languages that the seller can communicate in. This information is displayed on the seller's profile.
language
text
The name of the language spoken by the seller.
Data type description: This data type is used to represent messages exchanged within a chat. It associates each message with a specific chat session and contains the actual message content, allowing for effective communication tracking between clients and sellers.
chat
The chat session associated with the message.
content
text
The textual content of the message.
Data type description: This data type represents an order placed by a client for a seller's gig, encompassing details such as the buyer, seller, delivery terms, total cost, and statuses throughout the order process.
buyer
The user who made the purchase (the client).
delivered at
date
The date the order was delivered.
delivery
Delivery Time (opts)
Expected amount of time to be spent on delivery (with option sets).
due on
date
The date by which the order is due.
gig
The specific gig associated with the order.
gig name
text
The name of the gig being ordered.
index
number
The index used for displaying the order in the seller's order table (not unique).
note
number
Additional order notes left by the client.
package
Package Type (opts)
Type of package selected for the order (with option sets).
seller
The user who is selling the gig (the seller).
service fee
number
The fee charged for the service.
start date
date
The date the order was placed.
statuses
List of Statuses
History of statuses of the order (e.g., pending, In work, completed).
to seller $
number
The amount the seller will receive from this order.
total
number
The total amount charged for the order.
transaction
The transaction details associated with the order.
Data type description: This data type describes the features associated with a gig package. It includes feature types that can be either text or a Yes/No option, along with corresponding descriptive text for each feature.
basic input type
Feature Input Type (opts)
Choice between feature types: "yes/no" or "text".
basic text
text
Descriptive text for the Basic feature.
basic yes/no
yes/no
Yes/No option for the Basic feature.
premium input type
Feature Input Type (opts)
Choice between feature types: "yes/no" or "text".
premium text
text
Descriptive text for the Premium feature.
premium yes/no
yes/no
Yes/No option for the Premium feature.
standart input type
Feature Input Type (opts)
Choice between feature types: "yes/no" or "text".
standart text
text
Descriptive text for the Standard feature.
standart yes/no
yes/no
Yes/No option for the Standard feature.
title
text
Title of the feature.
Data type description: This data type defines the various packages available for a gig, including delivery times, descriptions, features, associated gig, and pricing for each package type (Basic, Standard, Premium).
delivery time basic
Delivery Time (opts)
Delivery time from 1 day to 4 weeks for the Basic package.
delivery time premium
Delivery Time (opts)
Delivery time from 1 day to 4 weeks for the Premium package.
delivery time standart
Delivery Time (opts)
Delivery time from 1 day to 4 weeks for the Standard package.
description basic
text
Description of the Basic package.
description premium
text
Description of the Premium package.
description standart
text
Description of the Standard package.
features
List of features associated with the package.
gig
The specific gig associated with the package.
price basic
number
Price of the Basic package.
price premium
number
Price of the Premium package.
price standart
number
Price of the Standard package.
Data type description: This data type represents a blog post that an admin can create, including details such as category, content, images, sections, tags, title, and view statistics.
category
The category to which the post belongs.
content
text
The main content of the blog post.
demo content?
yes / no
Indicates whether the given post is demo content created for viewing the template. Demo content cannot be deleted or modified by test users.
image
image
An image associated with the post.
section
The section of the blog where the post is featured.
tags
List of texts
Tags associated with the post for easier categorization.
title
text
The title of the blog post.
views number
number
The number of views the post has received.
Data type description: This data type represents a review for a gig that clients can leave only after they have completed an order for that gig with the seller.
content
text
The written content of the review.
gig
The specific gig being reviewed.
total
number
The total rating score given in the review.
Data type description: This data type defines a section for blog posts, categorizing them into groups such as News or Business.
demo content?
yes / no
Indicates whether the given section is demo content created for viewing the template. Demo content cannot be deleted or modified by test users.
image
image
Image associated with the section.
posts
Collection of posts included in this section.
posts number
number
The number of posts in the section.
title
text
Title of the section (e.g., News, Business).
views number
number
The total number of views for the section.
Data type description: This data type represents skills categorized on a seller's page. Each entry includes a type name (indicating it as a skill)
skill
Category in which the seller specialises
Data type description: This data type defines a status for orders. When the order type is set to "Individual action," it allows for the creation of custom statuses. Each status can have a title, be linked to a specific order, and include a note for additional context.
note
text
A comment associated with the status.
order
The specific order linked to this status.
title
text
The title of the status.
type
Order Status (opts)
The specific type of order status
Data type description: This data type represents a financial transaction, including details like the fee, gig name, unique ID, associated order, refund amount, involved users, and the total amount processed.
fee
number
The fee associated with the transaction.
gig name
text
The name of the gig related to the transaction.
id
text
A unique identifier for the transaction collected fron stripe.
order
The specific order related to the transaction.
refund
number
The amount refunded, if applicable.
to
User
The user receiving the transaction.
to seller
number
The amount going to the seller from the transaction.
total
number
The total amount processed in the transaction.
Data type description: This data type represents a user within the system, capturing various attributes including administrative status, language proficiency, certifications, personal details, order and gig associations, and financial information.
base language
languages (opts)
The primary language of the seller.
blocked
yes / no
Indicates if the user is blocked.
certification
Certifications the seller holds.
demo buyer?
yes / no
Indicates whether the user is a demo buyer for viewing the template.
demo user?
yes / no
Indicates whether the user is a demo user for viewing the template.
description
text
A brief description of the seller.
education
Educational background of the seller.
first name
text
The first name of the user.
full name
text
The complete name of the user.
gig number
number
The number of gigs created by the user.
languages
Languages spoken by the seller.
last name
text
The last name of the user.
location
text
The geographical location of the user.
my gigs
Gigs created by the user.
my orders
Orders placed by the user.
orders number
number
The number of orders placed by the user.
profile picture
image
The profile picture of the user.
rating
number
The sellerโs overall rating.
role
User roles (Opts)
The role of user (seller, buyer or admin)
saved gigs
Gigs saved by the user for later reference.
seller id
text
Unique identifier for the seller. (used for Stripe)
skills
Skillset of the seller.
start selling
date
The date the user started selling.
suggested
List of texts
Suggested search tags created based on what the user has previously searched for.
test user?
yes / no
Determines if the user is a test user, test users cannot delete or edit demo content.
total to admin earnings
number
Total earnings that will go to the admin from the user.
unread messages
Messages that have not been read by the user
Data type description: This data type represents a view associated with a gig. It is used for tracking and analyzing statistics in graphs.
gig
The specific gig being viewed.