Data Types

Introduction

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.

โœจ Tip: To make the most out of your template and avoid issues while customizing data elements, itโ€™s helpful to review Bubble's data management manuals:

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.

App announcement

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.

Field Name
Data Type
Description

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.

Category

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โ€™...

Field
Type
Description

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

Certification

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.

Field
Type
Description

certification

text

The name or description of the certification.

Chat

Data type description: This data type is designed to facilitate chat interactions between clients and sellers regarding specific gigs.

Field
Type
Description

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

Education

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.

Field
Type
Description

education

text

The name of the educational institution attended by the seller.

Gig

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.

Field
Type
Description

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.

Language

Data type description: This data type stores the languages that the seller can communicate in. This information is displayed on the seller's profile.

Field
Type
Description

language

text

The name of the language spoken by the seller.

Message

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.

Field
Type
Description

chat

The chat session associated with the message.

content

text

The textual content of the message.

Order

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.

Field
Type
Description

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.

Package feature

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.

Field
Type
Description

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.

Package

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

Field
Type
Description

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.

Post

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.

Field
Type
Description

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.

Review

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.

Field
Type
Description

content

text

The written content of the review.

gig

The specific gig being reviewed.

total

number

The total rating score given in the review.

Section

Data type description: This data type defines a section for blog posts, categorizing them into groups such as News or Business.

Field
Type
Description

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.

Skill

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)

Field
Type
Description

skill

Category in which the seller specialises

Status

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.

Field
Type
Description

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

Transaction

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.

Field
Type
Description

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.

User

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.

Field
Type
Description

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

View

Data type description: This data type represents a view associated with a gig. It is used for tracking and analyzing statistics in graphs.

Field
Type
Description

gig

The specific gig being viewed.

Last updated

Was this helpful?