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

Bid

This data type stores the buyers' details and card information, it also shows the bidder's information.
Field Name
Type
Notes
Bidder
User
Stores the user who made the bid.
card_token
text
Stores card token used for bid.
Listing Reference
Listing
Stores the listing reference.
payment_id
text
Stores the payment ID.
Price
number
Stores the bid's price.
refunded
yes / no
Stores current state of the bid (refunded or not). Default value - no.
send_email
yes / no
Stores current state of notification emain (sent or not). Default value - no.

Chat

This data type stores messages exchanged between application customers.
Field Name
Type
Notes
chatParts
List of Users
Stores users which are involved in the chat.
messages
List of Messages
Stores the messages exchanged by users.

Comment

This data type store comments made on bids and list of bids. Using it, users can also determine recent comments.
Field Name
Type
Notes
Listings Attached
Listing
Stores the related listing.
Text
text
Stores the comment text.

Customer

This data type stores customers' details that include age, customer image, full name, and phone number.
Field Name
Type
Notes
customer
User
Stores the user that has the buyer role.
seller
User
Stores the user that has the seller role.
StripeCustomerID
text
Stores the Stripe Customer ID.

Fees

This data type stores the fee kept by admin for selling domains, apps, websites, and Amazon FPAs through the app.
Field Name
Type
Notes
amazon
number
Stores the fee retained for Amazon FPA selling.
apps
number
Stores the fee retained for application selling.
domains
number
Stores the fee retained for domain selling.
website
number
Stores the fee retained for website selling.

Listing

This data type stores the lists of bids and its several parameters like the buy it now price, list of interested buyers, list of comments made about the bid, the deadline for the sale, etc.
Field Name
Type
Notes
Bids
List of Bids
Stores the list of bids.
Buy it now Price
number
Stores the price for immediate purchase.
Buyer
User
Stores the user which is buying.
charge_amount
number
Stores the value charged for bid.
charge_id
text
Stores the charge ID.
Comments
List of Comments
Stores the list of comments made below the bid.
Deadline
date
Stores the end date of bid availability.
Domain Provider
text
Stores the domain provider
fee
number
Stores the value of the fee.
income p/mo
number
Stores the amount of income per month.
Item Age
number
Stores the period of sold product existence.
Item Category
text
Stored the item category.
Making money
text
Stores the value of earned money.
Minimum Bid Price
number
Stores the minimum price for bid.
Monthly visits
number
Stores the number of monthly visits on the sold product.
Number of Days
number
Stores the number of days until the deadline.
Plan
text
Stores the name of subscription plan on Listing
Platform
text
Stores the name of platform.
Screenshot
image
Stores the screenshot of the sold product.
Seller Notes
text
Stores seller notes.
Slogan
text
Stores the product's slogan.
Sold To
User
Stores the user who gets the product.
Sold_date
date
Stores the date when the product was sold.
Source of income
text
Stores the source of income.
Status
text
Stores the status of the listing.
Title
text
Stores the title of the listing.
Type
text
Stores the type of the listing.
Unique visits
number
Stores the number of unique visits on the sold product.
Watching
List of Users
Stores the list of users which viewed the listing.
zStatus
Listing Status
Stores listing status.

Message

This data type stores messages exchanged by users (including file attachments, text messages to picture messages). This type also contains the profile picture of the associated user.
Field Name
Type
Notes
Destination
user
Stores the user who will receive the message.
Message
text
Stores the message's text.
Seen_by
List of Users
Indicates if the message sent has been viewed by the destination user.
Subject
text
Stores the subject of the message.

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. To learn more, see the Bubble manual.
This data type stores the users' bio data (name, photo, gender, city, etc.) and profile information like comments made and chats or discussions associated with the user.
Field Name
Type
Notes
Address
text
Stores user's address.
Admin
yes / no
Indicates if the user has (not) the admin role.
amazon_fee
number
Stores the fee value for Amazon FPA products.
Balance
number
Stores the value of gained finances.
Bid
List of Bids
Stores the list of bids made.
BidListing
List of Listings
Stores the list of listings.
City
text
Stores user's city.
Country
text
Stores user's country.
customer_list
List of Users
Stores list of customers.
domains_fee
number
Stores the fee value for domain products.
Favourite Listings
List of Listings
Stores the list of favorite listings.
First Name
text
Stores the user's first name.
Full Name
text
Stores the user's full name.
Last Name
text
Stores the user's last name.
Last viewed
List of Listings
Stores the last viewed listings.
New Bid
yes / no
Indicates if the bid is (not) new.
New Message
yes / no
Indicates if the message is (not) new.
PlatformCustomerID
text
Stores the customer ID on the platform.
Profile Picture
image
Stores the user's profile picture.
State/Province
text
Stores the user's state/province.
Street Address
geographic address
Stores the user's street address.
stripe_loading
yes / no
Indicates if the seller is registered on Stripe. Default value - no.
stripe_secret
text
Stores the Stripe account secret key.
StripeClientID
text
Stores the buyer ID in the Stripe account.
StripeSellerID
text
Stores the seller ID in the Stripe account.
Username
text
Stores the user name, indicated on registration.
website_fee
number
Stores the fee value for website.
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

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.

Listing Status

This field holds all the options available for the product listing categories. It comes with the default "Display" attribute.
The options for this set are:
Option
Types
All
Display all listings with "All" status.
Unsold
Display all listings with "Unsold" status.
Sold
Display all listings with "Sold" status.
Expires soon
Display all listings with the "Expires soon" status.
Draft
Display all listings with "Draft" status.
Live
Display all listings with "Live" status.
💡
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

Helpful?