> 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/appoint-hub/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>

***

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

<table><thead><tr><th width="182.33331298828125">Field</th><th width="177.5555419921875">Type</th><th>Description</th></tr></thead><tbody><tr><td>duration in min</td><td>number</td><td>Calculated duration (in minutes) between <strong>start</strong> and <strong>end</strong> times.</td></tr><tr><td>end</td><td>work hours set (Option Set)</td><td>The end time of this availability period (e.g., 15:00). Must be after start time.</td></tr><tr><td>start</td><td>work hours set (Option Set)</td><td>The start time of this availability period (e.g., 10:00).</td></tr><tr><td>text version</td><td>text</td><td>Used to display the master's workday schedule. (e.g., "10:00-15:00").</td></tr><tr><td>work day m</td><td>Master's Workday</td><td>Links to the day of week (e.g., Monday).</td></tr></tbody></table>

***

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

<table><thead><tr><th width="189">Field</th><th width="163.4444580078125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>(client) email</strong></td><td>Text</td><td>Information that can be used by staff to communicate with the customer. Displayed in the booking description.</td></tr><tr><td><strong>(client) first name</strong></td><td>Text</td><td>Client's first name. Displayed in the booking description.</td></tr><tr><td><strong>(client) full name</strong></td><td>Text</td><td>Client's full name. Displayed in the booking description.</td></tr><tr><td><strong>(client) last name</strong></td><td>Text</td><td>Client's surname. Displayed in the booking description.</td></tr><tr><td><strong>(client) phone</strong></td><td>Text</td><td>Information that can be used by staff to communicate with the customer. Displayed in the booking description.</td></tr><tr><td><strong>cancellation reason</strong></td><td>booking cancellation reason (Option Set)</td><td>Reason for cancellation (e.g., "Health reasons", "Financial reasons"...).</td></tr><tr><td><strong>client</strong></td><td>User</td><td>Reference to the client's User record.</td></tr><tr><td><strong>date</strong></td><td>Date</td><td>Appointment date (e.g., 2025-03-20).</td></tr><tr><td><strong>discount %</strong></td><td>Number</td><td>Percentage discount applied (e.g., 10%).</td></tr><tr><td><strong>discount number</strong></td><td>Number</td><td>Calculated discount amount (e.g., 10$).</td></tr><tr><td><strong>duration conv in min</strong></td><td>Number</td><td>Total appointment duration in minutes (e.g., 90 = 1h30m).</td></tr><tr><td><strong>duration h</strong></td><td>Number</td><td>Hour component of duration (e.g., 1 in 1h30m).</td></tr><tr><td><strong>duration m</strong></td><td>Number</td><td>Minute component of duration (e.g., 30 in 1h30m).</td></tr><tr><td><strong>end h</strong></td><td>Number</td><td>Scheduled end hour (24h format).</td></tr><tr><td><strong>end m</strong></td><td>Number</td><td>Scheduled end minute.</td></tr><tr><td><strong>end time conv to min</strong></td><td>Number</td><td>End time in minutes past midnight (e.g., 15:30 = 930).</td></tr><tr><td><strong>not show to</strong></td><td>List of Users</td><td>Managers/admins who deleted info about this booking from their dashboard.</td></tr><tr><td><strong>order note</strong></td><td>Text</td><td>Notes to order created by client.</td></tr><tr><td><strong>payment date</strong></td><td>Date</td><td>Date of payment processing.</td></tr><tr><td><strong>price</strong></td><td>Number</td><td>Start price without discounts/refu</td></tr><tr><td><strong>refund %</strong></td><td>Number</td><td>Percentage refunded if canceled.</td></tr><tr><td><strong>refund number</strong></td><td>Number</td><td>alculated refund amount (e.g., 10$).</td></tr><tr><td><strong>reminder</strong></td><td>Text</td><td>Id of scheduled api workflow where a reminder notification creates 15 minutes before booking</td></tr><tr><td><strong>review</strong></td><td>Review</td><td>Link to client's post-service feedback.</td></tr><tr><td><strong>service</strong></td><td>Master's service</td><td>Booked service (e.g., "Men's Haircut").</td></tr><tr><td><strong>start</strong></td><td>work hours set (Option Set)</td><td>Start time slot (e.g., "14:00").</td></tr><tr><td><strong>start time conv to min</strong></td><td>Number</td><td>Start time in minutes (e.g., 14:00 = 840).</td></tr><tr><td><strong>status</strong></td><td>booking status (Option Set)</td><td>Current state ("Pending", "Confirmed", "Arrived", "Waiting", "In progress", "Completed", "Rescheduled", "Cancelled").</td></tr><tr><td><strong>status change</strong></td><td>Text</td><td>Log of status updates with timestamps.</td></tr><tr><td><strong>total amount</strong></td><td>Number</td><td>Final price after discounts/refunds.</td></tr><tr><td><strong>transaction</strong></td><td>Transactions</td><td>Linked payment record.</td></tr></tbody></table>

***

## Chat

**Description:** The *Chat* data type facilitates real-time communication between users (e.g., clients and service providers).

<table><thead><tr><th width="190.111083984375">Field</th><th width="152">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>messages</strong></td><td>List of Messages</td><td>All sent/received messages in the chat, with timestamps and sender info.</td></tr><tr><td><strong>users</strong></td><td>List of Users</td><td>Participants in the chat (e.g., client + stylist).</td></tr></tbody></table>

***

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

<table><thead><tr><th width="206.4444580078125">Field</th><th width="136.7779541015625">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>unavailable day</strong></td><td>Date</td><td>The date when the master is unavailable (e.g., "2025-12-25").</td></tr><tr><td><strong>schedule unavailable</strong></td><td>Text</td><td>ID of the workflow that sets the master's status to "unavailable" on this date.</td></tr><tr><td><strong>schedule available</strong></td><td>Text</td><td>ID of the workflow that reverts the master's status to "available" <em>the next day</em> after <code>unavailable day</code>.</td></tr></tbody></table>

***

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

<table><thead><tr><th width="201.22222900390625">Field</th><th width="150.7777099609375">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>bookings</strong></td><td>List of Bookings</td><td>All appointments booked for this service.</td></tr><tr><td><strong>duration conv in min</strong></td><td>Number</td><td>Total service duration in minutes (e.g., 90 for 1h30m).</td></tr><tr><td><strong>duration h</strong></td><td>Number</td><td>Hour component of duration (e.g., 1 in 1h30m).</td></tr><tr><td><strong>duration min</strong></td><td>Number</td><td>Minute component of duration (e.g., 30 in 1h30m).</td></tr><tr><td><strong>master</strong></td><td>User in Salon</td><td>Master assigned to this service.</td></tr><tr><td><strong>master user</strong></td><td>User</td><td>Reference to the master's User account.</td></tr><tr><td><strong>price</strong></td><td>Number</td><td>Standard price of the service.</td></tr><tr><td><strong>rating</strong></td><td>Number</td><td>Average client rating (e.g., 4.5/5) from reviews.</td></tr><tr><td><strong>reviews</strong></td><td>List of Reviews</td><td>Client feedback linked to this service.</td></tr><tr><td><strong>salon</strong></td><td>Salon</td><td>The business location where the service is offered.</td></tr><tr><td><strong>service</strong></td><td>Service</td><td>Reference to the general service type (e.g., "Haircut").</td></tr><tr><td><strong>temp master</strong></td><td>User in Salon</td><td>Temporary master (for editing).</td></tr><tr><td><strong>temp price</strong></td><td>Number</td><td>Temporary price (for editing).</td></tr><tr><td><strong>title</strong></td><td>Text</td><td>Display name of the service (e.g., "Premium Hair Coloring").</td></tr></tbody></table>

***

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

<table><thead><tr><th width="185.66668701171875">Field</th><th width="146.5555419921875">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>available time periods</strong></td><td>List of Available time periods</td><td>Time slots when the master is open for appointments (e.g., 10:00-14:00).</td></tr><tr><td><strong>master</strong></td><td>User in Salon</td><td>Reference to the master's profile in the salon.</td></tr><tr><td><strong>work day</strong></td><td>days of week (Option Set)</td><td>Day of the week (e.g., Monday, Tuesday).</td></tr></tbody></table>

***

## **Message**

**Description:** Stores individual messages within a chat.

<table><thead><tr><th width="185.66668701171875">Field</th><th width="148.77783203125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>chat</strong></td><td>Chat</td><td>Reference to the parent chat session.</td></tr><tr><td><strong>content</strong></td><td>Text</td><td>The message body (supports plain text or formatted content).</td></tr></tbody></table>

***

## **Notification**

**Description:** Tracks system-generated alerts for users (e.g., appointment reminders, status updates).

<table><thead><tr><th width="193.44439697265625">Field</th><th width="155.888916015625">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>booking</strong></td><td>Booking</td><td>Linked appointment (if notification is booking-related).</td></tr><tr><td><strong>content</strong></td><td>Text</td><td>Notification message (e.g., "Your appointment is confirmed for March 25 at 10:00").</td></tr><tr><td><strong>seen?</strong></td><td>yes / no (Boolean)</td><td>Whether the user has viewed the notification.</td></tr><tr><td><strong>type</strong></td><td>notification type</td><td>Category (e.g., "Reminder", "Cancellation", "Payment").</td></tr></tbody></table>

***

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

<table><thead><tr><th width="183.4444580078125">Field</th><th width="172">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>category</strong></td><td>Categories (Option Set)</td><td>Topic classification.</td></tr><tr><td><strong>content?</strong></td><td>yes / no</td><td>Controls visibility in content.</td></tr><tr><td><strong>draft?</strong></td><td>yes / no</td><td>shows whether the post is a draft</td></tr><tr><td><strong>image</strong></td><td>image</td><td>Featured visual for social sharing and SEO.</td></tr><tr><td><strong>post</strong></td><td>text</td><td>Full article text.</td></tr><tr><td><strong>title</strong></td><td>text</td><td>Title of the post</td></tr></tbody></table>

***

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

<table><thead><tr><th width="186.77777099609375">Field</th><th width="172.2222900390625">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>benefit 1</strong> to <strong>benefit 7</strong></td><td>Text</td><td>Features included in the plan (e.g., "24/7 Support", "5 Appointments/Month").</td></tr><tr><td><strong>id</strong></td><td>Text</td><td>Stripe Plan ID (e.g., "price_1LN8JZJZ").</td></tr><tr><td><strong>name</strong></td><td>Text</td><td>Plan title (e.g., "Premium Monthly").</td></tr><tr><td><strong>period</strong></td><td>pricing plan period (Option Set)</td><td>Billing cycle (e.g., "Monthly", "Annual").</td></tr><tr><td><strong>price</strong></td><td>Number</td><td>Cost (e.g., 199). Local currency implied.</td></tr><tr><td><strong>type</strong></td><td>pricing plan type (Option Set)</td><td>Tier classification (e.g., "Basic", "Pro", "Premium").</td></tr></tbody></table>

***

## Promo code

**Description:** Manages discount codes for services, including validity periods, applicable services, and usage limits.

<table><thead><tr><th width="192.33331298828125">Field</th><th width="167">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>active?</strong></td><td>yes / no (Boolean)</td><td>Whether the promo code is currently redeemable.</td></tr><tr><td><strong>bookings used</strong></td><td>List of Bookings</td><td>Tracks appointments where the code was applied.</td></tr><tr><td><strong>code</strong></td><td>Text</td><td>Unique discount identifier (e.g., "SUMMER20").</td></tr><tr><td><strong>discount %</strong></td><td>Number</td><td>Percentage discount (e.g., 20 for 20% off).</td></tr><tr><td><strong>end date</strong></td><td>Date</td><td>Expiration date</td></tr><tr><td><strong>salon</strong></td><td>Salon</td><td>The salon to which the promo code is linked.</td></tr><tr><td><strong>services</strong></td><td>List of Services</td><td>Eligible services for the discount.</td></tr><tr><td><strong>start date</strong></td><td>Date</td><td>Activation date.</td></tr><tr><td><strong>user limit</strong></td><td>Number</td><td>Max redemption count.</td></tr></tbody></table>

***

## Review

**Description:** Stores client feedback for services/masters, including ratings and moderation requests.

<table><thead><tr><th width="192.33331298828125">Field</th><th width="172.5555419921875">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>content</strong></td><td>Text</td><td>Review text from client.</td></tr><tr><td><strong>master</strong></td><td>User in Salon</td><td>Reviewed service provider.</td></tr><tr><td><strong>master service</strong></td><td>Master's service</td><td>Specific service reviewed.</td></tr><tr><td><strong>request to delete</strong></td><td>Text</td><td>Moderation request from salon manager to superadmin (e.g., "Fake review").</td></tr><tr><td><strong>salon</strong></td><td>Salon</td><td>Salon linked to review.</td></tr><tr><td><strong>seen by</strong></td><td>List of Users</td><td>Used to display whether the user has read or not.</td></tr><tr><td><strong>service</strong></td><td>Service</td><td>Generic service type (e.g., "Haircut").</td></tr><tr><td><strong>stars</strong></td><td>Number</td><td>Rating (1-5 scale).</td></tr></tbody></table>

***

## Salon

**Description:** Stores comprehensive business profiles, including contact details, visual assets, staff, bookings, and operational settings.

<table><thead><tr><th width="194.5555419921875">Field</th><th width="170.4444580078125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>address</strong></td><td>geographic address</td><td>Physical location with map integration.</td></tr><tr><td><strong>admin</strong></td><td>User</td><td>Primary administrator/owner.</td></tr><tr><td><strong>bookings</strong></td><td>List of Bookings</td><td>All appointments for this salon.</td></tr><tr><td><strong>category</strong></td><td>Categories (Option Set)</td><td>Business type (e.g., "Hair Salon", "Spa").</td></tr><tr><td><strong>demo salon?</strong></td><td>yes / no </td><td>Flags demo accounts for showcasing.</td></tr><tr><td><strong>draft?</strong></td><td>yes / no </td><td>Unpublished salon profile.</td></tr><tr><td><strong>employees</strong></td><td>List of User in Salons</td><td>Hired masters/staff.</td></tr><tr><td><strong>hidden?</strong></td><td>yes / no</td><td>Temporarily hides from public listings.</td></tr><tr><td><strong>logo</strong></td><td>image</td><td>Brand logo.</td></tr><tr><td><strong>name</strong></td><td>text</td><td>Business name (e.g., "Glam Studio").</td></tr><tr><td><strong>overview</strong></td><td>text</td><td>Description.</td></tr><tr><td><strong>phone</strong></td><td>text</td><td>Contact number.</td></tr><tr><td><strong>portfolio pic 1</strong> to <strong>6</strong></td><td>image</td><td>Gallery images showcasing the salon.</td></tr><tr><td><strong>promo codes</strong></td><td>List of Promo codes</td><td>Active discounts for this salon.</td></tr><tr><td><strong>rating</strong></td><td>number</td><td>Average review score (1-5 scale).</td></tr><tr><td><strong>reviews</strong></td><td>List of Reviews</td><td>Client feedback.</td></tr><tr><td><strong>salon photos</strong></td><td>List of Images</td><td>Additional gallery images.</td></tr><tr><td><strong>services</strong></td><td>List of Services</td><td>Offered services (e.g., "Hair Coloring").</td></tr><tr><td><strong>services photo</strong></td><td>image</td><td>Hero image for services section.</td></tr><tr><td><strong>views</strong></td><td>number</td><td>Profile visit count.</td></tr><tr><td><strong>work hours</strong></td><td>List of Work day salons</td><td>Weekly operating hours.</td></tr></tbody></table>

***

## Service

**Description:** Defines services offered by salons, including pricing, descriptions, and associated professionals.

<table><thead><tr><th width="202.33331298828125">Field</th><th width="159.7777099609375">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>content?</strong></td><td>yes / no </td><td>Controls whether this service is displayed on the page or not</td></tr><tr><td><strong>description</strong></td><td>text</td><td>Service details (e.g., "Includes haircut and styling").</td></tr><tr><td><strong>image</strong></td><td>image</td><td>Featured service image.</td></tr><tr><td><strong>masters</strong></td><td>List of Master's services</td><td>Professionals offering this service.</td></tr><tr><td><strong>price</strong></td><td>number</td><td>Base cost (e.g., 50.00).</td></tr><tr><td><strong>rating</strong></td><td>number</td><td>Average review score (1-5).</td></tr><tr><td><strong>reviews</strong></td><td>List of Reviews</td><td>Client feedback for this service.</td></tr><tr><td><strong>salon</strong></td><td>Salon</td><td>Business offering the service.</td></tr><tr><td><strong>title</strong></td><td>text</td><td>Service name (e.g., "Premium Haircut").</td></tr></tbody></table>

***

## **Subscriber to news**

**Description:** Stores email addresses of users who opt-in to receive marketing newsletters, updates, and promotional offers.&#x20;

<table><thead><tr><th width="196.77777099609375">Field</th><th width="159.4444580078125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>email</strong></td><td>Text</td><td>Must be unique.</td></tr></tbody></table>

***

## **Subscription**

**Description:** Manages salon admin's app subscriptions, controlling salon visibility and feature access. Determines if a salon appears in public listings.

<table><thead><tr><th width="195.66668701171875">Field</th><th width="164.8887939453125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>active?</strong></td><td>yes / no</td><td>Whether the subscription is active or not</td></tr><tr><td><strong>cancelDate</strong></td><td>Date</td><td>When the subscription was manually canceled.</td></tr><tr><td><strong>client name</strong></td><td>Text</td><td>The name of the person who is subscribed. Used for display in tables.</td></tr><tr><td><strong>delayed unsub date</strong></td><td>Date</td><td>This date is responsible for when the salon becomes inactive when the subscription is canceled, i.e. the end date of the payment period.</td></tr><tr><td><strong>last payment</strong></td><td>Date</td><td>Most recent successful payment date.</td></tr><tr><td><strong>next payment</strong></td><td>Date</td><td>Upcoming billing date.</td></tr><tr><td><strong>plan</strong></td><td>Pricing plan</td><td>Current subscription plan.</td></tr><tr><td><strong>status</strong></td><td>Salon subscription status (Option Set)</td><td>Lifecycle stage (e.g., "Active", "Inactive").</td></tr><tr><td><strong>subscription date</strong></td><td>Date</td><td>Original signup date.</td></tr><tr><td><strong>subscription id</strong></td><td>Text</td><td>Payment processor's subscription ID (e.g., in Stripe "sub_...")</td></tr></tbody></table>

***

## **Subscription transaction**

**Description:** Records individual payment transactions for salon subscription plans, linking to users and subscription tiers.

<table><thead><tr><th width="196.77777099609375">Field</th><th width="166.111083984375">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>amount</strong></td><td>Number</td><td>Charged amount (e.g., 29.99).</td></tr><tr><td><strong>client</strong></td><td>User</td><td>Admin user who owns the subscription.</td></tr><tr><td><strong>client name</strong></td><td>Text</td><td>The name of the person who is subscribed. Used for display in tables.</td></tr><tr><td><strong>next payment</strong></td><td>Date</td><td>Scheduled renewal date.</td></tr><tr><td><strong>plan</strong></td><td>Pricing plan</td><td>Subscription tier purchased.</td></tr><tr><td><strong>status</strong></td><td>Subscription Transaction Status (Option Set)</td><td>Payment outcome ("Paid", "Cancelled").</td></tr><tr><td><strong>subscription</strong></td><td>Subscription</td><td>Linked parent subscription.</td></tr><tr><td><strong>transaction id</strong></td><td>Text</td><td>Payment gateway's transaction ID (e.g., in Stripe "ch_...").</td></tr></tbody></table>

***

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

<table><thead><tr><th width="199">Field</th><th width="174">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>content</strong></td><td>Text</td><td>Notification message (e.g., "Salon has purchased a subscription..")</td></tr><tr><td><strong>notification type</strong></td><td>superadmin notification types (Option Set)</td><td>Category (e.g., "Purchase Alerts", "Cancellation Alerts", "Plan change Alerts").</td></tr><tr><td><strong>removed from db</strong></td><td>List of Users</td><td>Admins who disabled this notification type in their settings.</td></tr><tr><td><strong>seen by</strong></td><td>List of Users</td><td>Super admins who viewed the alert.</td></tr></tbody></table>

***

## **Transactions**

**Description:** Tracks customer payments for services, including amounts, refunds, and payment statuses.

<table><thead><tr><th width="202.33331298828125">Field</th><th width="170.888916015625">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>amount</strong></td><td>Number</td><td>Total charged amount (e.g., 100.00).</td></tr><tr><td><strong>charge id</strong></td><td>Text</td><td>Payment processor's transaction ID (e.g., Stripe).</td></tr><tr><td><strong>refund</strong></td><td>Number</td><td>Refunded amount.</td></tr><tr><td><strong>status</strong></td><td>Payment status (Option Set)</td><td>Current state (e.g., "Paid", "Refunded")</td></tr></tbody></table>

***

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

<table><thead><tr><th width="200.11114501953125">Field</th><th width="171.8887939453125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>demo_user?</strong></td><td>yes / no </td><td>Demo account flag (restricts template editing).</td></tr><tr><td><strong>first name</strong></td><td>text</td><td>User's given name.</td></tr><tr><td><strong>full name</strong></td><td>text</td><td>Auto-generated full name.</td></tr><tr><td><strong>last name</strong></td><td>text</td><td>User's surname.</td></tr><tr><td><strong>last reminder</strong></td><td>date</td><td>Date when was last reminder to complete public profile (for salon admin or master)</td></tr><tr><td><strong>location</strong></td><td>text</td><td>Salon admin's address (prefills Stripe onboarding).</td></tr><tr><td><strong>my bookings</strong></td><td>List of Bookings</td><td>User's appointments.</td></tr><tr><td><strong>my salon</strong></td><td>Salon</td><td>Linked salon (for admins).</td></tr><tr><td><strong>notifications</strong></td><td>List of Notifications</td><td>User's alert history.</td></tr><tr><td><strong>phone</strong></td><td>text</td><td>Contact number.</td></tr><tr><td><strong>profile_picture</strong></td><td>image</td><td>Avatar/logo.</td></tr><tr><td><strong>role</strong></td><td>role (Option Set)</td><td>Account type ("Client", "Salon manager", "Salon Admin", "Super Admin").</td></tr><tr><td><strong>saved salons</strong></td><td>List of Salons</td><td>Client's favorited salons.</td></tr><tr><td><strong>saved services</strong></td><td>List of Services</td><td>Client's bookmarked services.</td></tr><tr><td><strong>seller_id</strong></td><td>text</td><td>Stripe Connect seller ID (for salon admins).</td></tr><tr><td><strong>subscription</strong></td><td>Subscription</td><td>Active salon subscription (for admins).</td></tr><tr><td><strong>sup-admin email notific</strong></td><td>List of superadmin notification types (Option Set)</td><td>Email alert preferences (super admin).</td></tr><tr><td><strong>sup-admin in-app alerts</strong></td><td>List of superadmin notification types (Option Set)</td><td>In-app notification preferences (super admin).</td></tr><tr><td><strong>test_user?</strong></td><td>yes / no (Boolean)</td><td>Test account flag (restricts template changes).</td></tr><tr><td><strong>unread_messages</strong></td><td>List of Messages</td><td>Unread chat messages.</td></tr><tr><td><strong>work in salon</strong></td><td>User in Salon</td><td>Linked salon employment (for staff).</td></tr></tbody></table>

***

## User in Salon

**Description:** Represents staff members (masters, managers) within a salon, tracking their employment status, schedules, portfolios, and performance metrics.

<table><thead><tr><th width="203.4444580078125">Field</th><th width="170.888916015625">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>1 review</strong>, <strong>2 review</strong></td><td>Review</td><td>Pinned client reviews (featured on profile).</td></tr><tr><td><strong>bookings</strong></td><td>List of Bookings</td><td>Staff's upcoming/past appointments.</td></tr><tr><td><strong>draft?</strong></td><td>yes / no</td><td>Unpublished profile (hidden from clients).</td></tr><tr><td><strong>manager?</strong></td><td>yes / no</td><td>Managerial permissions flag.</td></tr><tr><td><strong>name</strong></td><td>text</td><td>Display name (e.g., "Jane D.").</td></tr><tr><td><strong>non-working days</strong></td><td>List of dates</td><td>Specific dates unavailable (e.g., vacations).</td></tr><tr><td><strong>non working days for edit</strong></td><td>List of Master non-working days</td><td>A list of non working dates, which exists only for editing master's non working days </td></tr><tr><td><strong>porfolio img</strong></td><td>List of images</td><td>Work gallery.</td></tr><tr><td><strong>portfolio description</strong></td><td>text</td><td>Portfolio summary.</td></tr><tr><td><strong>position in salon</strong></td><td>text</td><td>Job title (e.g., "Senior Stylist").</td></tr><tr><td><strong>profile description</strong></td><td>text</td><td>Bio/credentials.</td></tr><tr><td><strong>rating</strong></td><td>number</td><td>Average review score (1-5).</td></tr><tr><td><strong>request status</strong></td><td>Employee request Status (Option Set)</td><td>Defines if employee's request to work in this salon is approved or declined.</td></tr><tr><td><strong>reviews</strong></td><td>List of Reviews</td><td>All reviews are regarding the master.</td></tr><tr><td><strong>salon</strong></td><td>Salon</td><td>Employing business.</td></tr><tr><td><strong>services</strong></td><td>List of Master's services</td><td>Offered services (e.g., "Hair Extensions").</td></tr><tr><td><strong>show in requests?</strong></td><td>yes / no</td><td>Defines if employee's request to work in this salon should be desplaid in requests tab on admin dashboard.</td></tr><tr><td><strong>status</strong></td><td>Employee status (Option Set)</td><td>Work availability: <code>Active</code>, <code>Sick</code>, <code>On Vacation</code>, etc.</td></tr><tr><td><strong>user</strong></td><td>User</td><td>Linked user account.</td></tr><tr><td><strong>views</strong></td><td>number</td><td>Profile visit count.</td></tr><tr><td><strong>work days</strong></td><td>List of Master's Workdays</td><td>Recurring weekly schedule.</td></tr></tbody></table>

***

## View

**Description:** Tracks salon profile visits for analytics and popularity metrics.

<table><thead><tr><th width="204.5555419921875">Field</th><th width="181">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>salon</strong></td><td>Salon</td><td>Viewed salon profile.</td></tr></tbody></table>

***

## **Work day salon**

**Description:** Defines a salon's operating hours for specific days of the week, including regular and temporary schedules.

<table><thead><tr><th width="210.11114501953125">Field</th><th width="176.8887939453125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>closed temp?</strong></td><td>yes / no </td><td>Temporary closure status.</td></tr><tr><td><strong>closed?</strong></td><td>yes / no </td><td>Permanent closure for this weekday.</td></tr><tr><td><strong>end</strong></td><td>work hours set (Option Set)</td><td>Regular closing time (e.g., "18:00").</td></tr><tr><td><strong>end temp</strong></td><td>work hours set (Option Set)</td><td>Temporary closing time (e.g., "15:00" for holidays).</td></tr><tr><td><strong>salon</strong></td><td>Salon</td><td>Linked salon.</td></tr><tr><td><strong>start</strong></td><td>work hours set (Option Set)</td><td>Regular opening time (e.g., "09:00").</td></tr><tr><td><strong>start temp</strong></td><td>work hours set (Option Set)</td><td>Temporary opening time.</td></tr><tr><td><strong>work day</strong></td><td>days of week (Option Set)</td><td>Weekday (e.g., "Monday").</td></tr></tbody></table>

***