1. Fitness Trainer Platform
  2. Data model
Reference

The tables behind Fitness Trainer Platform

Fitness Trainer Platform 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

Organization

Organizations, team members, Users and Resources establish working scope and eligible places.

Operations

Bookings and booking resources carry appointment times and reserved units. Training sessions records attended work.

Review and evidence

Review decisions, record attachments and operation receipts preserve decisions, files and action outcomes.

Payment context

Payment evidence keeps provider events attached to a booking. Exchange rates holds effective rates for the app.

Every table, by feature

Booking schedule

5 tablesAbout this feature
  • Bookings

    Scheduled training bookings with guarded lifecycle and execution evidence.

    Linked to Organizations, Team members, Resources
  • Team members

    Authenticated trainers and operations staff attached to an organization.

    Linked to Users, Organizations
  • Organizations

    Active fitness training organizations and their scope settings.

  • Resources

    Eligible training resources and locations available for booking.

    Linked to Organizations
  • Booking resources

    Reserved resource lines for each booking interval.

    Linked to Bookings, Resources

Training sessions

4 tablesAbout this feature
  • Training sessions

    Attended training-session evidence submitted for independent review.

    Linked to Bookings, Organizations
  • Bookings

    Scheduled training bookings with guarded lifecycle and execution evidence.

    Linked to Organizations, Team members, Resources
  • Review decisions

    Independent approval, rejection, and return decisions on submitted work.

    Linked to Bookings, Team members
  • Record attachments

    Evidence files linked to booking operations and review context.

    Linked to Bookings, Team members

Resources and capacity

4 tablesAbout this feature
  • Resources

    Eligible training resources and locations available for booking.

    Linked to Organizations
  • Booking resources

    Reserved resource lines for each booking interval.

    Linked to Bookings, Resources
  • Bookings

    Scheduled training bookings with guarded lifecycle and execution evidence.

    Linked to Organizations, Team members, Resources
  • Organizations

    Active fitness training organizations and their scope settings.

Review and decisions

5 tablesAbout this feature
  • Review decisions

    Independent approval, rejection, and return decisions on submitted work.

    Linked to Bookings, Team members
  • Record attachments

    Evidence files linked to booking operations and review context.

    Linked to Bookings, Team members
  • Training sessions

    Attended training-session evidence submitted for independent review.

    Linked to Bookings, Organizations
  • Bookings

    Scheduled training bookings with guarded lifecycle and execution evidence.

    Linked to Organizations, Team members, Resources
  • Team members

    Authenticated trainers and operations staff attached to an organization.

    Linked to Users, Organizations

Payment evidence

3 tablesAbout this feature
  • Payment evidence

    Provider-confirmed payment events associated with bookings.

    Linked to Bookings
  • Bookings

    Scheduled training bookings with guarded lifecycle and execution evidence.

    Linked to Organizations, Team members, Resources
  • Operation receipts

    Idempotent receipts for guarded actions and their persisted effects.

    Linked to Bookings

Operations oversight

6 tablesAbout this feature
  • Operation receipts

    Idempotent receipts for guarded actions and their persisted effects.

    Linked to Bookings
  • Bookings

    Scheduled training bookings with guarded lifecycle and execution evidence.

    Linked to Organizations, Team members, Resources
  • Training sessions

    Attended training-session evidence submitted for independent review.

    Linked to Bookings, Organizations
  • Review decisions

    Independent approval, rejection, and return decisions on submitted work.

    Linked to Bookings, Team members
  • Payment evidence

    Provider-confirmed payment events associated with bookings.

    Linked to Bookings
  • Resources

    Eligible training resources and locations available for booking.

    Linked to Organizations

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

Bookings is the parent record for reserved resource lines, training sessions, payment events, attachments, decisions and receipts. The owner points to team members; the selected resource points to Resources. A reviewer and attachment uploader also point to team members. Keep each referenced organization consistent when importing appointments and attendance. Stable provider event IDs and operation keys help identify repeated events and actions.

Migration order

  1. Scope. Import Organizations and Users, then team members and Resources.
  2. Appointments. Import Bookings with their organization, owner and selected resource.
  3. Allocations. Add booking resources beneath the correct parent booking.
  4. Evidence. Add training sessions, record attachments, payment evidence, review decisions and operation receipts with their parent links.
  5. Check. Compare calendar intervals, session decisions and provider references on representative bookings.

Set up Fitness Trainer Platform your way.

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

How to get started