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
Master'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).
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
Master's service
Booked service (e.g., "Men's Haircut").
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 + stylist).
Master 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.
Master'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
User in Salon
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.
salon
Salon
The business location where the service is offered.
service
Service
Reference to the general service type (e.g., "Haircut").
temp master
User in Salon
Temporary master (for editing).
temp price
Number
Temporary price (for editing).
title
Text
Display name of the service (e.g., "Premium Hair Coloring").
Master'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
User in Salon
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
Pricing plan
Description: Defines subscription plans or service packages with tiered benefits, pricing, and billing cycles. Integrates with payment processors (e.g., Stripe via id)
benefit 1 to benefit 7
Text
Features included in the plan (e.g., "24/7 Support", "5 Appointments/Month").
id
Text
Stripe Plan ID (e.g., "price_1LN8JZJZ").
name
Text
Plan title (e.g., "Premium Monthly").
period
pricing plan period (Option Set)
Billing cycle (e.g., "Monthly", "Annual").
price
Number
Cost (e.g., 199). Local currency implied.
type
pricing plan type (Option Set)
Tier classification (e.g., "Basic", "Pro", "Premium").
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
salon
Salon
The salon to which the promo code is linked.
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.
master
User in Salon
Reviewed service provider.
master service
Master's service
Specific service reviewed.
request to delete
Text
Moderation request from salon manager to superadmin (e.g., "Fake review").
salon
Salon
Salon linked to review.
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).
Salon
Description: Stores comprehensive business profiles, including contact details, visual assets, staff, bookings, and operational settings.
address
geographic address
Physical location with map integration.
admin
User
Primary administrator/owner.
bookings
List of Bookings
All appointments for this salon.
category
Categories (Option Set)
Business type (e.g., "Hair Salon", "Spa").
demo salon?
yes / no
Flags demo accounts for showcasing.
draft?
yes / no
Unpublished salon profile.
employees
List of User in Salons
Hired masters/staff.
hidden?
yes / no
Temporarily hides from public listings.
logo
image
Brand logo.
name
text
Business name (e.g., "Glam Studio").
overview
text
Description.
phone
text
Contact number.
portfolio pic 1 to 6
image
Gallery images showcasing the salon.
promo codes
List of Promo codes
Active discounts for this salon.
rating
number
Average review score (1-5 scale).
reviews
List of Reviews
Client feedback.
salon photos
List of Images
Additional gallery images.
services
List of Services
Offered services (e.g., "Hair Coloring").
services photo
image
Hero image for services section.
views
number
Profile visit count.
work hours
List of Work day salons
Weekly operating hours.
Service
Description: Defines services offered by salons, including pricing, descriptions, and associated professionals.
content?
yes / no
Controls whether this service is displayed on the page or not
description
text
Service details (e.g., "Includes haircut and styling").
image
image
Featured service image.
masters
List of Master'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.
salon
Salon
Business offering the 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.
Subscription
Description: Manages salon admin's app subscriptions, controlling salon visibility and feature access. Determines if a salon appears in public listings.
active?
yes / no
Whether the subscription is active or not
cancelDate
Date
When the subscription was manually canceled.
client name
Text
The name of the person who is subscribed. Used for display in tables.
delayed unsub date
Date
This date is responsible for when the salon becomes inactive when the subscription is canceled, i.e. the end date of the payment period.
last payment
Date
Most recent successful payment date.
next payment
Date
Upcoming billing date.
plan
Pricing plan
Current subscription plan.
status
Salon subscription status (Option Set)
Lifecycle stage (e.g., "Active", "Inactive").
subscription date
Date
Original signup date.
subscription id
Text
Payment processor's subscription ID (e.g., in Stripe "sub_...")
Subscription transaction
Description: Records individual payment transactions for salon subscription plans, linking to users and subscription tiers.
amount
Number
Charged amount (e.g., 29.99).
client
User
Admin user who owns the subscription.
client name
Text
The name of the person who is subscribed. Used for display in tables.
next payment
Date
Scheduled renewal date.
plan
Pricing plan
Subscription tier purchased.
status
Subscription Transaction Status (Option Set)
Payment outcome ("Paid", "Cancelled").
subscription
Subscription
Linked parent subscription.
transaction id
Text
Payment gateway's transaction ID (e.g., in Stripe "ch_...").
Super admin notifications
Description: Manages system alerts sent exclusively to the app owner (super admin), tracking subscription changes and other critical events with notification preferences.
content
Text
Notification message (e.g., "Salon has purchased a subscription..")
notification type
superadmin notification types (Option Set)
Category (e.g., "Purchase Alerts", "Cancellation Alerts", "Plan change Alerts").
removed from db
List of Users
Admins who disabled this notification type in their settings.
seen by
List of Users
Super admins who viewed the alert.
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.
demo_user?
yes / no
Demo account flag (restricts template editing).
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 salon admin or master)
location
text
Salon admin's address (prefills Stripe onboarding).
my bookings
List of Bookings
User's appointments.
my salon
Salon
Linked salon (for admins).
notifications
List of Notifications
User's alert history.
phone
text
Contact number.
profile_picture
image
Avatar/logo.
role
role (Option Set)
Account type ("Client", "Salon manager", "Salon Admin", "Super Admin").
saved salons
List of Salons
Client's favorited salons.
saved services
List of Services
Client's bookmarked services.
seller_id
text
Stripe Connect seller ID (for salon admins).
subscription
Subscription
Active salon subscription (for admins).
sup-admin email notific
List of superadmin notification types (Option Set)
Email alert preferences (super admin).
sup-admin in-app alerts
List of superadmin notification types (Option Set)
In-app notification preferences (super admin).
test_user?
yes / no (Boolean)
Test account flag (restricts template changes).
unread_messages
List of Messages
Unread chat messages.
work in salon
User in Salon
Linked salon employment (for staff).
User in Salon
Description: Represents staff members (masters, managers) within a salon, 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.
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 Master 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 Stylist").
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 salon is approved or declined.
reviews
List of Reviews
All reviews are regarding the master.
salon
Salon
Employing business.
services
List of Master's services
Offered services (e.g., "Hair Extensions").
show in requests?
yes / no
Defines if employee's request to work in this salon 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 Master's Workdays
Recurring weekly schedule.
View
Description: Tracks salon profile visits for analytics and popularity metrics.
salon
Salon
Viewed salon profile.
Work day salon
Description: Defines a salon's operating hours for specific days of the week, including regular and temporary schedules.
closed temp?
yes / no
Temporary closure status.
closed?
yes / no
Permanent closure for this weekday.
end
work hours set (Option Set)
Regular closing time (e.g., "18:00").
end temp
work hours set (Option Set)
Temporary closing time (e.g., "15:00" for holidays).
salon
Salon
Linked salon.
start
work hours set (Option Set)
Regular opening time (e.g., "09:00").
start temp
work hours set (Option Set)
Temporary opening time.
work day
days of week (Option Set)
Weekday (e.g., "Monday").
Last updated
Was this helpful?