1. Pet Grooming Management
  2. Data model
Reference

The tables behind Pet Grooming Management

Pet Grooming Management ships with 13 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
13
Features
6, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Owners and pets

Members hold owner identity and standing; Pets hold each animal's details and owner link.

Service calendar

Services define the offer; Sessions assign service, instructor, window and capacity.

Reservations and delivery

Bookings reserve member places; Attendance and grooming services record what happened for a booking and pet.

Membership and money

Membership plans define terms; member plans enroll members; Payments connect charges and receipts to bookings.

Staff and reference data

People connects instructors to Users. Exchange rates holds effective currency rates.

Every table, by feature

Pet and member records

4 tablesAbout this feature
  • Members

    Pet owners enrolled in the grooming studio with their membership standing.

  • Pets

    Pet profiles owned by a member, with breed and handling notes.

    Linked to Members
  • People

    Staff and instructors who deliver grooming sessions and record operational evidence.

    Linked to Users
  • Grooming services

    Grooming work delivered for a booking and pet, with coat condition evidence.

    Linked to Bookings, Pets

Services and sessions

4 tablesAbout this feature
  • Services

    Grooming service catalog with duration, capacity and price.

  • Sessions

    Scheduled grooming sessions delivered by an instructor for a service.

    Linked to Services, People
  • People

    Staff and instructors who deliver grooming sessions and record operational evidence.

    Linked to Users
  • Bookings

    Member reservations against a session, with reserved places and lifecycle state.

    Linked to Members, Sessions

Bookings and capacity

4 tablesAbout this feature
  • Bookings

    Member reservations against a session, with reserved places and lifecycle state.

    Linked to Members, Sessions
  • Sessions

    Scheduled grooming sessions delivered by an instructor for a service.

    Linked to Services, People
  • Members

    Pet owners enrolled in the grooming studio with their membership standing.

  • Payments

    Charges and receipts raised against a member booking.

    Linked to Members, Bookings

Membership plans

5 tablesAbout this feature
  • Membership plans

    Sellable membership plans defining price, session allowance and validity.

  • Member plans

    A member's enrolled plan with its own validity window and state.

    Linked to Members, Membership plans
  • Members

    Pet owners enrolled in the grooming studio with their membership standing.

  • Bookings

    Member reservations against a session, with reserved places and lifecycle state.

    Linked to Members, Sessions
  • Attendance

    Check-in evidence recorded when a confirmed booking is delivered.

    Linked to Bookings, People

Visit delivery

6 tablesAbout this feature
  • Attendance

    Check-in evidence recorded when a confirmed booking is delivered.

    Linked to Bookings, People
  • Grooming services

    Grooming work delivered for a booking and pet, with coat condition evidence.

    Linked to Bookings, Pets
  • Bookings

    Member reservations against a session, with reserved places and lifecycle state.

    Linked to Members, Sessions
  • Pets

    Pet profiles owned by a member, with breed and handling notes.

    Linked to Members
  • People

    Staff and instructors who deliver grooming sessions and record operational evidence.

    Linked to Users
  • Sessions

    Scheduled grooming sessions delivered by an instructor for a service.

    Linked to Services, People

Charges and oversight

6 tablesAbout this feature
  • Payments

    Charges and receipts raised against a member booking.

    Linked to Members, Bookings
  • Bookings

    Member reservations against a session, with reserved places and lifecycle state.

    Linked to Members, Sessions
  • Members

    Pet owners enrolled in the grooming studio with their membership standing.

  • Sessions

    Scheduled grooming sessions delivered by an instructor for a service.

    Linked to Services, People
  • Services

    Grooming service catalog with duration, capacity and price.

  • Grooming services

    Grooming work delivered for a booking and pet, with coat condition evidence.

    Linked to Bookings, Pets

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

Use the member link on Pets, Bookings, member plans and Payments to keep one owner’s records together. A Session references its Service and Instructor. A grooming services entry must reference both the Booking and Pet; Attendance references its Booking and recording person. Match a charge by its Booking reference before interpreting its amount. Booking number and session code help staff identify a visit in conversation.

Migration order

  1. Import Users and People so instructors can be identified.
  2. Import Services and membership plans with approved terms.
  3. Import Members, then Pets and member plans with their owner references.
  4. Import Sessions with service and instructor references.
  5. Import Bookings, then Payments, Attendance and grooming services with their visit links.
  6. Reconcile counts, statuses and links against representative completed and open visits.

Set up Pet Grooming Management your way.

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

How to get started