1. Hair Extension / Wig Studio
  2. Data model
Reference

The tables behind Hair Extension / Wig Studio

Hair Extension / Wig Studio 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

Client and visit

Clients identify who booked; Bookings hold the visit interval, resource, rate and state.

Space and price

Resources describe bookable capacity and readiness; rate plans hold dated daily rates by type.

Specialty work

Add on bookings and add on charges attach extension or wig activity to the booking.

Delivery

Service tasks connect the booking and resource to an assigned team members record.

Finance

Service charges and Payments both link to Bookings, retaining their own states.

Access and reference data

Team members link to Users. Exchange rates hold dated currency rates.

Every table, by feature

Clients and bookings

2 tablesAbout this feature
  • Bookings

    Resource bookings with start, end, client count and daily rate.

    Linked to Clients, Resources
  • Clients

    Clients, groups and companies that book studio services.

Resources and rates

3 tablesAbout this feature
  • Resources

    Bookable studio inventory: styling stations, fitting rooms, suites and other resources.

  • Rate plans

    Dated daily rate plans by resource type with minimum duration rules.

  • Bookings

    Resource bookings with start, end, client count and daily rate.

    Linked to Clients, Resources

Extension and wig add-ons

3 tablesAbout this feature
  • Add on bookings

    Extension and wig add-on bookings attached to a booking.

    Linked to Bookings
  • Add on charges

    Extension and wig add-on charges posted against a booking.

    Linked to Bookings
  • Bookings

    Resource bookings with start, end, client count and daily rate.

    Linked to Clients, Resources

Service delivery

4 tablesAbout this feature
  • Service tasks

    Cleaning, maintenance and client service work assigned to team members for a resource and booking.

    Linked to Resources, Team members, Bookings
  • Team members

    Team members who own and are assigned studio service work.

    Linked to Users
  • Resources

    Bookable studio inventory: styling stations, fitting rooms, suites and other resources.

  • Bookings

    Resource bookings with start, end, client count and daily rate.

    Linked to Clients, Resources

Charges and payments

4 tablesAbout this feature
  • Add on charges

    Extension and wig add-on charges posted against a booking.

    Linked to Bookings
  • Service charges

    Service charges for a booking, draft through posted or voided.

    Linked to Bookings
  • Payments

    Payments received against a booking, pending through confirmed or refunded.

    Linked to Bookings
  • Bookings

    Resource bookings with start, end, client count and daily rate.

    Linked to Clients, Resources

Reports and oversight

8 tablesAbout this feature
  • Bookings

    Resource bookings with start, end, client count and daily rate.

    Linked to Clients, Resources
  • Resources

    Bookable studio inventory: styling stations, fitting rooms, suites and other resources.

  • Rate plans

    Dated daily rate plans by resource type with minimum duration rules.

  • Add on bookings

    Extension and wig add-on bookings attached to a booking.

    Linked to Bookings
  • Add on charges

    Extension and wig add-on charges posted against a booking.

    Linked to Bookings
  • Service charges

    Service charges for a booking, draft through posted or voided.

    Linked to Bookings
  • Payments

    Payments received against a booking, pending through confirmed or refunded.

    Linked to Bookings
  • Service tasks

    Cleaning, maintenance and client service work assigned to team members for a resource and booking.

    Linked to Resources, Team members, Bookings

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

A booking is the central visit reference for add-on bookings, add-on charges, service charges, payments and service tasks. A booking also points to one client and one resource. A service task points to its assigned team member and resource. Keep those links intact during import so a charge or task appears under the correct visit.

Migration order

  1. People and spaces. Import Users, team members, Clients and Resources.
  2. Rates. Add dated rate plans and review resource types.
  3. Visits. Import Bookings with their client and resource links.
  4. Specialty and work. Add add on bookings and service tasks to their bookings.
  5. Financial history. Add add on charges, service charges and Payments with their source booking links.
  6. Reference rates. Review exchange rates where they are used.

Set up Hair Extension / Wig Studio your way.

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

How to get started