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.
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.
Available time period
Description: This data type defines a master's working hours for a specific day of the week. It powers the scheduling system by storing time slots when services are available (e.g., "Mon 10:00-15:00").
duration in min
number
Calculated duration (in minutes) between start and end times.
end
work hours set (Option Set)
The end time of this availability period (e.g., 15:00). Must be after start time.
start
work hours set (Option Set)
The start time of this availability period (e.g., 10:00).
text version
text
Used to display the master's workday schedule. (e.g., "10:00-15:00").
work day m
Employee's Workday
Links to the day of week (e.g., Monday).
Booking
Description: The Booking data type serves as the core entity for managing appointments in the system. It stores all critical information about client reservations, service details, timing, payments, and status changes, enabling end-to-end appointment lifecycle management.
(client) email
Text
Information that can be used by staff to communicate with the customer. Displayed in the booking description.
(client) first name
Text
Client's first name. Displayed in the booking description.
(client) full name
Text
Client's full name. Displayed in the booking description.
(client) last name
Text
Client's surname. Displayed in the booking description.
(client) phone
Text
Information that can be used by staff to communicate with the customer. Displayed in the booking description.
cancellation reason
booking cancellation reason (Option Set)
Reason for cancellation (e.g., "Health reasons", "Financial reasons"...).
client
User
Reference to the client's User record.
date
Date
Appointment date (e.g., 2025-03-20).
discount %
Number
Percentage discount applied (e.g., 10%).
discount number
Number
Calculated discount amount (e.g., 10$).
duration conv in min
Number
Total appointment duration in minutes (e.g., 90 = 1h30m).
duration h
Number
Hour component of duration (e.g., 1 in 1h30m).
duration m
Number
Minute component of duration (e.g., 30 in 1h30m).
end h
Number
Scheduled end hour (24h format).
end m
Number
Scheduled end minute.
end time conv to min
Number
End time in minutes past midnight (e.g., 15:30 = 930).
Id
Number
Booking Id (e.g 1,2,3)
not show to
List of Users
Managers/admins who deleted info about this booking from their dashboard.
order note
Text
Notes to order created by client.
payment date
Date
Date of payment processing.
price
Number
Start price without discounts/refu
refund %
Number
Percentage refunded if canceled.
refund number
Number
alculated refund amount (e.g., 10$).
reminder
Text
Id of scheduled api workflow where a reminder notification creates 15 minutes before booking
review
Review
Link to client's post-service feedback.
service
Employee's service
Booked service
start
work hours set (Option Set)
Start time slot (e.g., "14:00").
start time conv to min
Number
Start time in minutes (e.g., 14:00 = 840).
status
booking status (Option Set)
Current state ("Pending", "Confirmed", "Arrived", "Waiting", "In progress", "Completed", "Rescheduled", "Cancelled").
status change
Text
Log of status updates with timestamps.
total amount
Number
Final price after discounts/refunds.
transaction
Transactions
Linked payment record.
Chat
Description: The Chat data type facilitates real-time communication between users (e.g., clients and service providers).
messages
List of Messages
All sent/received messages in the chat, with timestamps and sender info.
users
List of Users
Participants in the chat (e.g., client + dentist).
client (full name)
text
for searching
staff(full name)
text
for searching
Employee profile
Description: Represents staff members (masters, managers) within a clinic, tracking their employment status, schedules, portfolios, and performance metrics.
1 review, 2 review
Review
Pinned client reviews (featured on profile).
bookings
List of Bookings
Staff's upcoming/past appointments.
draft?
yes / no
Unpublished profile (hidden from clients).
manager?
yes / no
Managerial permissions flag.
motto
text
Small description
name
text
Display name (e.g., "Jane D.").
non-working days
List of dates
Specific dates unavailable (e.g., vacations).
non working days for edit
List of Employee non-working days
A list of non working dates, which exists only for editing master's non working days
porfolio img
List of images
Work gallery.
portfolio description
text
Portfolio summary.
position in salon
text
Job title (e.g., "Senior Instructor").
profile description
text
Bio/credentials.
rating
number
Average review score (1-5).
request status
Employee request Status (Option Set)
Defines if employee's request to work in this clinic is approved or declined.
reviews
List of Reviews
All reviews are regarding the master.
services
List of Employee's services
Offered services (e.g., "Hair Extensions").
show in requests?
yes / no
Defines if employee's request to work in this clinic should be desplaid in requests tab on admin dashboard.
status
Employee status (Option Set)
Work availability: Active, Sick, On Vacation, etc.
user
User
Linked user account.
views
number
Profile visit count.
work days
List of Employee's Workdays
Recurring weekly schedule.
Employee non-working days
Description: This data type manages a service provider's (master) availability exceptions, marking specific dates as "unavailable" (e.g., holidays, sick days) and automating status toggles between unavailable and available periods.
unavailable day
Date
The date when the master is unavailable (e.g., "2025-12-25").
schedule unavailable
Text
ID of the workflow that sets the master's status to "unavailable" on this date.
schedule available
Text
ID of the workflow that reverts the master's status to "available" the next day after unavailable day.
Employee's service
Description: This data type represents a specific service offered by a master (service provider) within a salon or business. It links the service details, pricing, duration, and master information, while also tracking bookings and reviews.
bookings
List of Bookings
All appointments booked for this service.
duration conv in min
Number
Total service duration in minutes (e.g., 90 for 1h30m).
duration h
Number
Hour component of duration (e.g., 1 in 1h30m).
duration min
Number
Minute component of duration (e.g., 30 in 1h30m).
master
Employee profile
Master assigned to this service.
master(user)
User
Reference to the master's User account.
price
Number
Standard price of the service.
rating
Number
Average client rating (e.g., 4.5/5) from reviews.
reviews
List of Reviews
Client feedback linked to this service.
service
Service
Reference to the general service type (e.g., "Haircut").
temp master
Employee profile
Temporary master (for editing).
temp price
Number
Temporary price (for editing).
title
Text
Display name of the service (e.g., "Premium Hair Coloring").
Employee's Workday
Description: Defines a master's (service provider) recurring weekly schedule by linking specific working days to available time slots. Used to generate long-term availability for appointment booking.
available time periods
List of Available time periods
Time slots when the master is open for appointments (e.g., 10:00-14:00).
master
Employee profile
Reference to the master's profile in the salon.
work day
days of week (Option Set)
Day of the week (e.g., Monday, Tuesday).
Message
Description: Stores individual messages within a chat.
chat
Chat
Reference to the parent chat session.
content
Text
The message body (supports plain text or formatted content).
Notification
Description: Tracks system-generated alerts for users (e.g., appointment reminders, status updates).
booking
Booking
Linked appointment (if notification is booking-related).
content
Text
Notification message (e.g., "Your appointment is confirmed for March 25 at 10:00").
seen?
yes / no (Boolean)
Whether the user has viewed the notification.
type
notification type
Category (e.g., "Reminder", "Cancellation", "Payment").
Post
Description: Stores blog posts for content marketing, including titles, categories, images, and draft status. Used to publish articles, news, or tutorials on the platform.
category
Categories (Option Set)
Topic classification.
content?
yes / no
Controls visibility in content.
draft?
yes / no
shows whether the post is a draft
image
image
Featured visual for social sharing and SEO.
post
text
Full article text.
title
text
Title of the post
Promo code
Description: Manages discount codes for services, including validity periods, applicable services, and usage limits.
active?
yes / no (Boolean)
Whether the promo code is currently redeemable.
bookings used
List of Bookings
Tracks appointments where the code was applied.
code
Text
Unique discount identifier (e.g., "SUMMER20").
discount %
Number
Percentage discount (e.g., 20 for 20% off).
end date
Date
Expiration date
services
List of Services
Eligible services for the discount.
start date
Date
Activation date.
user limit
Number
Max redemption count.
Review
Description: Stores client feedback for services/masters, including ratings and moderation requests.
content
Text
Review text from client.
demo content?
yes / no
The field responsible for whether a review is a demo review that cannot be deleted for display in the template.
master
Employee profile
Reviewed service provider.
master service
Employee's service
Specific service reviewed.
published?
yes / no
Shows whether reviews are displayed on pages or not.
seen by
List of Users
Used to display whether the user has read or not.
service
Service
Generic service type (e.g., "Haircut").
stars
Number
Rating (1-5 scale).
Service
Description: Defines services offered by salons, including pricing, descriptions, and associated professionals.
category
Category
Linked Category
content?
yes / no
Controls whether this service is displayed on the page or not
description
text
Service details (e.g., "Dental Sealants for Kids").
duration
Service Duration
Linked service duration time.(e.g., 1h 30 min).
image
image
Featured service image.
masters
List of Employee's services
Professionals offering this service.
price
number
Base cost (e.g., 50.00).
rating
number
Average review score (1-5).
reviews
List of Reviews
Client feedback for this service.
title
text
Service name (e.g., "Premium Haircut").
Subscriber to news
Description: Stores email addresses of users who opt-in to receive marketing newsletters, updates, and promotional offers.
Text
Must be unique.
Transactions
Description: Tracks customer payments for services, including amounts, refunds, and payment statuses.
amount
Number
Total charged amount (e.g., 100.00).
charge id
Text
Payment processor's transaction ID (e.g., Stripe).
refund
Number
Refunded amount.
status
Payment status (Option Set)
Current state (e.g., "Paid", "Refunded")
User
Description: Stores all user accounts (clients, admins, super admins) with personal data, permissions, and system interactions. Controls access to demo/test modes and notification preferences.
Chats
List of chats
List of chats to which this user is attached
demo_user?
yes / no
Demo account flag (restricts template editing).
employee profile
employee profile
Linked employee profile.
first name
text
User's given name.
full name
text
Auto-generated full name.
last name
text
User's surname.
last reminder
date
Date when was last reminder to complete public profile (for clinic admin or master)
my bookings
List of Bookings
User's appointments.
notifications
List of Notifications
User's alert history.
phone
text
Contact number.
profile_picture
image
Avatar/logo.
role
role (Option Set)
Account type ("Client", "Clinic manager", "Salon Admin", "Dentist").
saved services
List of Services
Client's bookmarked services.
test_user?
yes / no (Boolean)
Test account flag (restricts template changes).
unread_messages
List of Messages
Unread chat messages.
View
Description: Tracks clinic profile visits for analytics and popularity metrics.
Last updated
Was this helpful?