---
description: >-
  This section consists of Database Things and fields description for every
  thing which is part of the template.
---

# Data Types



{% hint style="success" %}
See Bubble manual information when working with data: [https://manual.bubble.io/help-guides/working-with-data](https://manual.bubble.io/help-guides/working-with-data) & [https://manual.bubble.io/core-resources/data](https://manual.bubble.io/core-resources/data).
{% endhint %}

## Data Types



## Cart Item

| Field        | Type     | Notes                                                    |
| ------------ | -------- | -------------------------------------------------------- |
| Gross Amount | number   | Stores the Price \*Quantity.                             |
| In Order     | yes / no | "no" means the product is in the current cart.           |
| Net Amount   | number   | Stores the Price \*Quantity + Shipping fee.              |
| Product      | product  | Stores all the data attached to the product.             |
| Quantity     | number   | Stores the number of products the customer wants to buy. |
| Shipping Fee | number   | Stores the shipping fee                                  |
| Unit Price   | number   | Stores the the Price of a product.                       |



## Category

| Field | Type | Notes                          |
| ----- | ---- | ------------------------------ |
| Name  | text | Stores the name of a category. |

## Conversation

| Field  | Type | Notes                                  |
| ------ | ---- | -------------------------------------- |
| Seller | User | Stores the data related to the seller. |

## Coupon

| Field    | Type   | Notes                                                                                     |
| -------- | ------ | ----------------------------------------------------------------------------------------- |
| Code     | text   | Stores the text that can create discount for the customer.                                |
| Discount | number | Stores how many % will be applied as a discount for the customer on the total cart value. |

## Message

| Field        | Type         | Notes                                 |
| ------------ | ------------ | ------------------------------------- |
| Content      | text         | Stores the text value of a message.   |
| Conversation | Conversation | Link the conversation to the message. |



## Order

| Field            | Type               | Notes                                                  |
| ---------------- | ------------------ | ------------------------------------------------------ |
| Coupon           | number             | Stores the coupon value for an order.                  |
| Gross Amount     | number             | Stores the Price \*Quantity of an order.               |
| Items            | List of Cart Items | Stores the list of all items from the cart.            |
| Net Amount       | number             | Stores the Price \*Quantity + Shipping fee of an order |
| Plateform Amount | number             | Stores the money collected by the plateform.           |
| Reference        | text               | Stores the number that allows to identify an order.    |
| Sellers          | List of Users      | Stores the Sellers' data.                              |
| Status           | text               | Either Pending, Shipped or Received.                   |

## Platform Fee

| Field | Type   | Notes                                          |
| ----- | ------ | ---------------------------------------------- |
| Fee   | number | Stores the fee % that belongs to the platform. |



## Product

| Field                | Type           | Notes                                                                                                                                                                        |
| -------------------- | -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Category             | Category       | Stores the data related to the category.                                                                                                                                     |
| Description          | text           | Stores the data related to the description of a product.                                                                                                                     |
| Images               | List of Images | Stores 3 pictures max. for the product.                                                                                                                                      |
| Name                 | text           | Stores the data related to the title of a product.                                                                                                                           |
| Number of Items Sold | number         | Stores the data related to the number of item sold.                                                                                                                          |
| Rating               | number         | Stores the data related to the ratings by customers of a product.                                                                                                            |
| Sale price           | number         | <p>Stores the data related to the sale price (after discount from the seller) of a prouct.<br><br>This is <strong>not</strong> the Voucher (controlled by the Platform).</p> |
| Shipping Fee         | number         | Stores the data related to the shipping fee of a product.                                                                                                                    |
| Standard Price       | number         | Stores the data related to the category.                                                                                                                                     |
| Stock                | number         | Stores the data related to the number of products in stock.                                                                                                                  |



## Review

| Field   | Type    | Notes                                                                   |
| ------- | ------- | ----------------------------------------------------------------------- |
| Comment | text    | Stores the data related to the comment made by a customer for a review. |
| Product | Product | Stores the data related that links the Product to the Review.           |
| Rating  | number  | Stores the data related to the review (out of 5 stars).                 |



## User

| Field                | Type              | Notes                                                                |
| -------------------- | ----------------- | -------------------------------------------------------------------- |
| Adress               | geographic adress | Stores the data related to the Adress of the customer for shippment. |
| Compagny Adress      | geographic adress | Stores the data related to the sellers adress.                       |
| Compagny Description | text              | Stores the data related to the seller's description.                 |
| Compagny Email       | email             | Stores the data related to the sellers email.                        |
| Compagny Logo        | picture           | This is the profile picture of the seller.                           |
| Compagny Name        | text              | This is the seller's official brand name.                            |
| Compagny Phone       | US Phone          | Stores the phone number of the seller.                               |
| First Name           | text              | First name of the User                                               |
| Last Name            | text              | Last name of the User                                                |
| Type                 | text              | Either Customer, Seller or Admin.                                    |
| Wishlist             | List of Products  | Stores the list of product / wishlist of a customer.                 |

