# 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="/files/mWpovB66bXt9p1L40VYM" 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>

***


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mind-for-apps.gitbook.io/templates-documentation/appoint-hub/data-types.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.