1. Tanning Salon Management
  2. Data model and import order
Reference

The tables behind Tanning Salon Management

Tanning Salon 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

Sessions and services:

Services, Sessions. The services you sell, and scheduled sessions with instructor, times and capacity.

Bookings and attendance:

Bookings, Attendance. Members' places on sessions and the check-in for each confirmed booking.

UV exposure:

Exposure plans, exposure sessions. Authorized limits per member and every logged exposure against them.

Members and plans:

Members, membership plans, member plans. Member records, the plans you sell and each member's enrolment.

Payments:

Payments. Pending, confirmed and refunded payments against bookings.

People and access:

People, Users. Staff and instructors linked to user accounts.

Every table, by feature

Sessions and services

3 tablesAbout this feature
  • Services

    Tanning and wellness services offered by the salon

  • Sessions

    Scheduled service sessions with instructor and capacity

    Linked to Services, People
  • People

    Staff and instructors referenced by sessions, attendance and exposure authorizations

    Linked to Users

Bookings and attendance

4 tablesAbout this feature
  • Bookings

    Member bookings against scheduled sessions

    Linked to Members, Sessions
  • Attendance

    Check-in records for confirmed bookings

    Linked to Bookings, People
  • Members

    Salon members with membership status and join date

  • Sessions

    Scheduled service sessions with instructor and capacity

    Linked to Services, People

UV exposure control

4 tablesAbout this feature
  • Exposure plans

    Authorized UV exposure limits per member

    Linked to Members, People
  • Exposure sessions

    Logged UV exposure sessions against an exposure plan

    Linked to Members, Exposure plans
  • Members

    Salon members with membership status and join date

  • People

    Staff and instructors referenced by sessions, attendance and exposure authorizations

    Linked to Users

Members

3 tablesAbout this feature
  • Members

    Salon members with membership status and join date

  • Member plans

    Membership plan enrollments held by members

    Linked to Members, Membership plans
  • Bookings

    Member bookings against scheduled sessions

    Linked to Members, Sessions

Membership plans

3 tablesAbout this feature
  • Membership plans

    Sellable membership plan definitions with allowance and validity

  • Member plans

    Membership plan enrollments held by members

    Linked to Members, Membership plans
  • Members

    Salon members with membership status and join date

Payments

3 tablesAbout this feature
  • Payments

    Payments received against member bookings

    Linked to Members, Bookings
  • Bookings

    Member bookings against scheduled sessions

    Linked to Members, Sessions
  • Members

    Salon members with membership status and join date

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

A booking references its member and session; attendance references the booking and the person who recorded it; a payment references the member and booking. Exposure plans reference the member and the authorizing instructor; exposure sessions reference the member and plan. Sessions reference their service and instructor. Keep member numbers, booking references and plan references stable from your current system and import by them.

Migration order

  1. Load Users and People, then Services and membership plans.
  2. Load Members with their status and join date.
  3. Load current member plans enrolments.
  4. Load each active member’s exposure plans, authorized by an instructor.
  5. Load the coming weeks’ Sessions and their Bookings.
  6. Reconcile members, plans and open bookings with the current system and test permissions before go-live.

Set up Tanning Salon Management your way.

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

How to get started