1. Nail Studio Management
  2. Data model
Reference

The tables behind Nail Studio Management

Nail Studio Management ships with 12 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.

Tables
12
Features
6, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Clients and appointments

Clients identify the person; Appointments hold the requested service window, station and visit status.

Station and team work

Stations hold capacity and readiness; service tasks link work to the station, appointment and assigned team members.

Treatments

Treatment bookings identify the service planned against an appointment; treatment charges record its financial entry.

Visit account

Service charges and Payments both reference the appointment so the Finance Officer can review the same visit.

Reference records

Service rates hold effective service prices. Users connect to team members. Exchange rates hold effective currency rates.

Every table, by feature

Appointments

8 tablesAbout this feature
  • Appointments

    Client appointments with station, status, service rate and requested service window.

    Linked to Clients, Stations
  • Clients

    Nail studio clients whose appointments, service charges and payments are tracked.

  • Stations

    Nail stations and treatment rooms used to deliver scheduled services.

  • Treatment bookings

    Treatment service bookings captured against an appointment for a studio service line.

    Linked to Appointments
  • Service tasks

    Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.

    Linked to Stations, Team members, Appointments
  • Service charges

    Service charges raised against an appointment and their posted state.

    Linked to Appointments
  • Treatment charges

    Treatment charges captured at the studio and their draft, posted or voided state.

    Linked to Appointments
  • Payments

    Guest payments received against a reservation, pending through confirmed or refunded.

    Linked to Appointments

Clients

4 tablesAbout this feature
  • Clients

    Nail studio clients whose appointments, service charges and payments are tracked.

  • Appointments

    Client appointments with station, status, service rate and requested service window.

    Linked to Clients, Stations
  • Treatment bookings

    Treatment service bookings captured against an appointment for a studio service line.

    Linked to Appointments
  • Payments

    Guest payments received against a reservation, pending through confirmed or refunded.

    Linked to Appointments

Stations

4 tablesAbout this feature
  • Stations

    Nail stations and treatment rooms used to deliver scheduled services.

  • Appointments

    Client appointments with station, status, service rate and requested service window.

    Linked to Clients, Stations
  • Service tasks

    Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.

    Linked to Stations, Team members, Appointments
  • Team members

    Nail technicians and front desk team members who deliver and capture studio work.

    Linked to Users

Treatments

4 tablesAbout this feature
  • Treatment bookings

    Treatment service bookings captured against an appointment for a studio service line.

    Linked to Appointments
  • Treatment charges

    Treatment charges captured at the studio and their draft, posted or voided state.

    Linked to Appointments
  • Appointments

    Client appointments with station, status, service rate and requested service window.

    Linked to Clients, Stations
  • Service rates

    Service price list by service type with effective dates and minimum sessions.

Studio Work

5 tablesAbout this feature
  • Service tasks

    Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.

    Linked to Stations, Team members, Appointments
  • Team members

    Nail technicians and front desk team members who deliver and capture studio work.

    Linked to Users
  • Users

    Users

    Linked to Users
  • Stations

    Nail stations and treatment rooms used to deliver scheduled services.

  • Appointments

    Client appointments with station, status, service rate and requested service window.

    Linked to Clients, Stations

Charges and Payments

4 tablesAbout this feature
  • Service charges

    Service charges raised against an appointment and their posted state.

    Linked to Appointments
  • Treatment charges

    Treatment charges captured at the studio and their draft, posted or voided state.

    Linked to Appointments
  • Payments

    Guest payments received against a reservation, pending through confirmed or refunded.

    Linked to Appointments
  • Appointments

    Client appointments with station, status, service rate and requested service window.

    Linked to Clients, Stations

Shared and settings

1 table
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

Each appointment points to one client and one station. Each payment, service charge, treatment booking and treatment charge points to an appointment. A service task points to an appointment, station and assigned team member. Team members point to Users. Use these references when migrating records; a matching name or treatment label is not a replacement for the linked source record.

Migration order

  1. People and spaces. Prepare Users, team members, Clients and Stations with stable identities.
  2. Rates. Load service rates and, when used, exchange rates with effective dates.
  3. Visits. Add Appointments with their client, station, time window and status.
  4. Work. Add treatment bookings and service tasks against their source appointments.
  5. Account. Add service charges, treatment charges and Payments with their appointment references and current states.

Set up Nail Studio Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started