> For the complete documentation index, see [llms.txt](https://mind-for-apps.gitbook.io/templates-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mind-for-apps.gitbook.io/templates-documentation/freelance-marketplace.-skillwise/data-types.md).

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

{% hint style="info" %}
✨ **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:

* [Working with Data](https://manual.bubble.io/help-guides/working-with-data)
* [Core Data Resources](https://manual.bubble.io/core-resources/data)
  {% endhint %}

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

{% @supademo/embed demoId="cm3hh7stn479j8hspgthilvbo" url="<https://app.supademo.com/demo/cm3hh7stn479j8hspgthilvbo>" %}

✨ **Tip: In the application there is also an internal system of notes with description of fields and data types.**

<figure><img src="https://184458815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LOc6TTUFXem91kZBFum%2Fuploads%2FMe434mwVkBEmS7QobOx8%2FNVIDIA_Overlay_1nKHObwHBU.png?alt=media&amp;token=5a7db501-f969-4252-a54b-03d57804fa86" alt=""><figcaption></figcaption></figure>

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

<table><thead><tr><th width="191">Field Name</th><th width="172">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>index</td><td>number</td><td>Sequence number for the app announcement.</td></tr><tr><td>receivers</td><td><a href="#user">List of Users</a></td><td>List of users who receive this announcement.</td></tr><tr><td>subject</td><td>text</td><td>The subject of the announcement, summarizing its content.</td></tr><tr><td>text</td><td>text</td><td>The main content of the announcement.</td></tr><tr><td>user type</td><td>user type</td><td>The type of user to whom the announcement is addressed.</td></tr><tr><td>viewed</td><td><a href="#user">List of Users</a></td><td>List of users who have already viewed the announcement.</td></tr></tbody></table>

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

<table><thead><tr><th width="189">Field</th><th width="177">Type</th><th>Description</th></tr></thead><tbody><tr><td>gig number</td><td>number</td><td>Number of gigs belonging to this category.</td></tr><tr><td>image black</td><td>image</td><td>Picture for category preview in black colour.</td></tr><tr><td>image white</td><td>image</td><td>Picture for category preview in white colour.</td></tr><tr><td>name</td><td>text</td><td>Name or title of the category</td></tr></tbody></table>

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

<table><thead><tr><th width="186">Field</th><th width="182">Type</th><th>Description</th></tr></thead><tbody><tr><td>certification</td><td>text</td><td>The name or description of the certification.</td></tr></tbody></table>

## Chat

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

<table><thead><tr><th width="189">Field</th><th width="186">Type</th><th>Description</th></tr></thead><tbody><tr><td>gig</td><td><a href="#gig">Gig</a></td><td>The specific gig associated with the chat.</td></tr><tr><td>messages</td><td><a href="#message">List of Messages</a></td><td>Collection of messages exchanged in the chat.</td></tr><tr><td>users</td><td><a href="#user">List of Users</a></td><td>List of users participating in the chat (client and seller).</td></tr></tbody></table>

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

<table><thead><tr><th width="186">Field</th><th width="174">Type</th><th>Description</th></tr></thead><tbody><tr><td>education</td><td>text</td><td>The name of the educational institution attended by the seller.</td></tr></tbody></table>

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

<table><thead><tr><th width="190">Field</th><th width="170">Type</th><th>Description</th></tr></thead><tbody><tr><td>cellations count</td><td>number</td><td>The number of cancelled orders for the current gig.</td></tr><tr><td>category</td><td><a href="#category">Category</a></td><td>Category associated with the gig.</td></tr><tr><td>demo content?</td><td>yes / no</td><td>Indicates whether the given gig is demo content created for viewing the template. Demo content cannot be deleted or modified by test users.</td></tr><tr><td>description</td><td>text</td><td>Detailed description of the gig.</td></tr><tr><td>highest price</td><td>number</td><td>The maximum price for the gig.</td></tr><tr><td>images</td><td>List of images</td><td>Collection of images associated with the gig.</td></tr><tr><td>index</td><td>number</td><td>The gig sequence number is unique for each seller individually.</td></tr><tr><td>is hidden?</td><td>yes / no</td><td>Indicates if the gig is hidden from view.</td></tr><tr><td>lowest price</td><td>number</td><td>The minimum price for the gig.</td></tr><tr><td>orders</td><td><a href="#order">List of orders</a></td><td>List of orders related to the gig.</td></tr><tr><td>orders count</td><td>number</td><td>Total count of orders for the gig.</td></tr><tr><td>packages</td><td><a href="#package">Packages</a></td><td>Different packages offered for the gig.</td></tr><tr><td>pdfs</td><td>List of files</td><td>Collection of PDF files related to the gig.</td></tr><tr><td>rating</td><td>number</td><td>Average rating for the gig.</td></tr><tr><td>reviews</td><td><a href="#review">List of Reviews</a></td><td>Collection of reviews for the gig.</td></tr><tr><td>tags</td><td>List of texts</td><td>Tags associated with the gig for search and categorization.</td></tr><tr><td>title</td><td>text</td><td>Title of the gig.</td></tr><tr><td>views</td><td><a href="#view">List of Views</a></td><td>List of views or view counts for the gig.</td></tr><tr><td>views number</td><td>number</td><td>Total number of views for the gig.</td></tr></tbody></table>

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

<table><thead><tr><th width="190">Field</th><th width="176">Type</th><th>Description</th></tr></thead><tbody><tr><td>language</td><td>text</td><td>The name of the language spoken by the seller.</td></tr></tbody></table>

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

<table><thead><tr><th width="195">Field</th><th width="177">Type</th><th>Description</th></tr></thead><tbody><tr><td>chat</td><td><a href="#chat">Chat</a></td><td>The chat session associated with the message.</td></tr><tr><td>content</td><td>text</td><td>The textual content of the message.</td></tr></tbody></table>

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

<table><thead><tr><th width="200">Field</th><th width="178">Type</th><th>Description</th></tr></thead><tbody><tr><td>buyer</td><td><a href="#user">User</a></td><td>The user who made the purchase (the client).</td></tr><tr><td>delivered at</td><td>date</td><td>The date the order was delivered.</td></tr><tr><td>delivery</td><td>Delivery Time (opts)</td><td>Expected amount of time to be spent on delivery (with option sets).</td></tr><tr><td>due on</td><td>date</td><td>The date by which the order is due.</td></tr><tr><td>gig</td><td><a href="#gig">Gig</a></td><td>The specific gig associated with the order.</td></tr><tr><td>gig name</td><td>text</td><td>The name of the gig being ordered.</td></tr><tr><td>index</td><td>number</td><td>The index used for displaying the order in the seller's order table (not unique).</td></tr><tr><td>note</td><td>number</td><td>Additional order notes left by the client.</td></tr><tr><td>package</td><td>Package Type (opts)</td><td>Type of package selected for the order (with option sets).</td></tr><tr><td>seller</td><td><a href="#user">User</a></td><td>The user who is selling the gig (the seller).</td></tr><tr><td>service fee</td><td>number</td><td>The fee charged for the service.</td></tr><tr><td>start date</td><td>date</td><td>The date the order was placed.</td></tr><tr><td>statuses</td><td>List of Statuses</td><td>History of statuses of the order (e.g., pending, In work, completed).</td></tr><tr><td>to seller $</td><td>number</td><td>The amount the seller will receive from this order.</td></tr><tr><td>total</td><td>number</td><td>The total amount charged for the order.</td></tr><tr><td>transaction</td><td><a href="#transaction">Transaction</a></td><td>The transaction details associated with the order.</td></tr></tbody></table>

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

<table><thead><tr><th width="203">Field</th><th width="179">Type</th><th>Description</th></tr></thead><tbody><tr><td>basic input type</td><td>Feature Input Type (opts)</td><td>Choice between feature types: "yes/no" or "text".</td></tr><tr><td>basic text</td><td>text</td><td>Descriptive text for the Basic feature.</td></tr><tr><td>basic yes/no</td><td>yes/no</td><td>Yes/No option for the Basic feature.</td></tr><tr><td>premium input type</td><td>Feature Input Type (opts)</td><td>Choice between feature types: "yes/no" or "text".</td></tr><tr><td>premium text</td><td>text</td><td>Descriptive text for the Premium feature.</td></tr><tr><td>premium yes/no</td><td>yes/no</td><td>Yes/No option for the Premium feature.</td></tr><tr><td>standart input type</td><td>Feature Input Type (opts)</td><td>Choice between feature types: "yes/no" or "text".</td></tr><tr><td>standart text</td><td>text</td><td>Descriptive text for the Standard feature.</td></tr><tr><td>standart yes/no</td><td>yes/no</td><td>Yes/No option for the Standard feature.</td></tr><tr><td>title</td><td>text</td><td>Title of the feature.</td></tr></tbody></table>

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

<table><thead><tr><th width="214">Field</th><th width="184">Type</th><th>Description</th></tr></thead><tbody><tr><td>delivery time basic</td><td>Delivery Time (opts)</td><td>Delivery time from 1 day to 4 weeks for the Basic package.</td></tr><tr><td>delivery time premium</td><td>Delivery Time (opts)</td><td>Delivery time from 1 day to 4 weeks for the Premium package.</td></tr><tr><td>delivery time standart</td><td>Delivery Time (opts)</td><td>Delivery time from 1 day to 4 weeks for the Standard package.</td></tr><tr><td>description basic</td><td>text</td><td>Description of the Basic package.</td></tr><tr><td>description premium</td><td>text</td><td>Description of the Premium package.</td></tr><tr><td>description standart</td><td>text</td><td>Description of the Standard package.</td></tr><tr><td>features</td><td><a href="#package-feature">List of Package features</a></td><td>List of features associated with the package.</td></tr><tr><td>gig</td><td><a href="#gig">Gig</a></td><td>The specific gig associated with the package.</td></tr><tr><td>price basic</td><td>number</td><td>Price of the Basic package.</td></tr><tr><td>price premium</td><td>number</td><td>Price of the Premium package.</td></tr><tr><td>price standart</td><td>number</td><td>Price of the Standard package.</td></tr></tbody></table>

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

<table><thead><tr><th width="213">Field</th><th width="181">Type</th><th>Description</th></tr></thead><tbody><tr><td>category</td><td><a href="#category">Category</a></td><td>The category to which the post belongs.</td></tr><tr><td>content</td><td>text</td><td>The main content of the blog post.</td></tr><tr><td>demo content?</td><td>yes / no</td><td>Indicates whether the given post is demo content created for viewing the template. Demo content cannot be deleted or modified by test users.</td></tr><tr><td>image</td><td>image</td><td>An image associated with the post.</td></tr><tr><td>section</td><td><a href="#section">Section</a></td><td>The section of the blog where the post is featured.</td></tr><tr><td>tags</td><td>List of texts</td><td>Tags associated with the post for easier categorization.</td></tr><tr><td>title</td><td>text</td><td>The title of the blog post.</td></tr><tr><td>views number</td><td>number</td><td>The number of views the post has received.</td></tr></tbody></table>

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

<table><thead><tr><th width="222">Field</th><th width="181">Type</th><th>Description</th></tr></thead><tbody><tr><td>content</td><td>text</td><td>The written content of the review.</td></tr><tr><td>gig</td><td><a href="#gig">Gig</a></td><td>The specific gig being reviewed.</td></tr><tr><td>total</td><td>number</td><td>The total rating score given in the review.</td></tr></tbody></table>

## Section

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

<table><thead><tr><th width="225">Field</th><th width="179">Type</th><th>Description</th></tr></thead><tbody><tr><td>demo content?</td><td>yes / no</td><td>Indicates whether the given section is demo content created for viewing the template. Demo content cannot be deleted or modified by test users.</td></tr><tr><td>image</td><td>image</td><td>Image associated with the section.</td></tr><tr><td>posts</td><td><a href="#post">List of Posts</a></td><td>Collection of posts included in this section.</td></tr><tr><td>posts number</td><td>number</td><td>The number of posts in the section.</td></tr><tr><td>title</td><td>text</td><td>Title of the section (e.g., News, Business).</td></tr><tr><td>views number</td><td>number</td><td>The total number of views for the section.</td></tr></tbody></table>

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

<table><thead><tr><th width="226">Field</th><th width="183">Type</th><th>Description</th></tr></thead><tbody><tr><td>skill</td><td><a href="#category">Category</a></td><td>Category in which the seller specialises</td></tr></tbody></table>

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

<table><thead><tr><th width="226">Field</th><th width="198">Type</th><th>Description</th></tr></thead><tbody><tr><td>note</td><td>text</td><td>A comment associated with the status.</td></tr><tr><td>order</td><td><a href="#order">Order</a></td><td>The specific order linked to this status.</td></tr><tr><td>title</td><td>text</td><td>The title of the status.</td></tr><tr><td>type</td><td>Order Status (opts)</td><td>The specific type of order status </td></tr></tbody></table>

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

<table><thead><tr><th width="228">Field</th><th width="200">Type</th><th>Description</th></tr></thead><tbody><tr><td>fee</td><td>number</td><td>The fee associated with the transaction.</td></tr><tr><td>gig name</td><td>text</td><td>The name of the gig related to the transaction.</td></tr><tr><td>id</td><td>text</td><td>A unique identifier for the transaction collected fron stripe.</td></tr><tr><td>order</td><td><a href="#order">Order</a></td><td>The specific order related to the transaction.</td></tr><tr><td>refund</td><td>number</td><td>The amount refunded, if applicable.</td></tr><tr><td>to</td><td>User</td><td>The user receiving the transaction.</td></tr><tr><td>to seller</td><td>number</td><td>The amount going to the seller from the transaction.</td></tr><tr><td>total</td><td>number</td><td>The total amount processed in the transaction.</td></tr></tbody></table>

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

<table><thead><tr><th width="229">Field</th><th width="196">Type</th><th>Description</th></tr></thead><tbody><tr><td>base language</td><td>languages (opts)</td><td>The primary language of the seller.</td></tr><tr><td>blocked</td><td>yes / no</td><td>Indicates if the user is blocked.</td></tr><tr><td>certification</td><td><a href="#certification">List of Certifications</a></td><td>Certifications the seller holds.</td></tr><tr><td>demo buyer?</td><td>yes / no</td><td>Indicates whether the user is a demo buyer for viewing the template.</td></tr><tr><td>demo user?</td><td>yes / no</td><td>Indicates whether the user is a demo user for viewing the template.</td></tr><tr><td>description</td><td>text</td><td>A brief description of the seller.</td></tr><tr><td>education</td><td><a href="#education">List of Education</a></td><td>Educational background of the seller.</td></tr><tr><td>first name</td><td>text</td><td>The first name of the user.</td></tr><tr><td>full name</td><td>text</td><td>The complete name of the user.</td></tr><tr><td>gig number</td><td>number</td><td>The number of gigs created by the user.</td></tr><tr><td>languages</td><td><a href="#language">List of languages</a></td><td>Languages spoken by the seller.</td></tr><tr><td>last name</td><td>text</td><td>The last name of the user.</td></tr><tr><td>location</td><td>text</td><td>The geographical location of the user.</td></tr><tr><td>my gigs</td><td><a href="#gig">List of Gigs</a></td><td>Gigs created by the user.</td></tr><tr><td>my orders</td><td><a href="#order">List of orders</a></td><td>Orders placed by the user.</td></tr><tr><td>orders number</td><td>number</td><td>The number of orders placed by the user.</td></tr><tr><td>profile picture</td><td>image</td><td>The profile picture of the user.</td></tr><tr><td>rating</td><td>number</td><td>The seller’s overall rating.</td></tr><tr><td>role</td><td>User roles (Opts)</td><td>The role of user (seller, buyer or admin)</td></tr><tr><td>saved gigs</td><td><a href="#gig">List of Gigs</a></td><td>Gigs saved by the user for later reference.</td></tr><tr><td>seller id</td><td>text</td><td>Unique identifier for the seller. (used for Stripe)</td></tr><tr><td>skills</td><td><a href="#skill">List of Skills</a></td><td>Skillset of the seller.</td></tr><tr><td>start selling</td><td>date</td><td>The date the user started selling.</td></tr><tr><td>suggested</td><td>List of texts</td><td>Suggested search tags created based on what the user has previously searched for.</td></tr><tr><td>test user?</td><td>yes / no</td><td>Determines if the user is a test user, test users cannot delete or edit demo content.</td></tr><tr><td>total to admin earnings</td><td>number</td><td>Total earnings that will go to the admin from the user.</td></tr><tr><td>unread messages</td><td><a href="#message">List of Messages</a></td><td>Messages that have not been read by the user</td></tr></tbody></table>

## View

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

<table><thead><tr><th width="235">Field</th><th width="185">Type</th><th>Description</th></tr></thead><tbody><tr><td>gig</td><td><a href="#gig">Gig</a></td><td>The specific gig being viewed.</td></tr></tbody></table>