1. Martial Arts Studio
  2. Data model
Reference

The tables behind Martial Arts Studio

Martial Arts 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
7
Change it
Add fields and tables in Proto

How the model is organised

Member and plan context

Members holds identity and contact details; membership plans holds plan dates, price and validity.

Session operations

Sessions carries type, capacity and state; Bookings connects a member to a session and dated places.

Evidence

Attendance connects booking, session and recorder; belt assessments stores discipline and result; tournament registrations stores event details.

Finance

Payments and Services each refer to a booking. Exchange rates is a read-only effective-rate reference.

People and access

People links named staff to Users; Users contains account and role information.

Every table, by feature

Members and plans

3 tablesAbout this feature
  • Members

    Members records for Martial Arts Studio.

  • Membership plans

    Membership Plans records for Martial Arts Studio.

  • Bookings

    Bookings records for Martial Arts Studio.

    Linked to Members, Sessions

Sessions and capacity

3 tablesAbout this feature
  • Sessions

    Sessions records for Martial Arts Studio.

  • Bookings

    Bookings records for Martial Arts Studio.

    Linked to Members, Sessions
  • Attendance

    Attendance records for Martial Arts Studio.

    Linked to Sessions, People, Bookings

Bookings

5 tablesAbout this feature
  • Bookings

    Bookings records for Martial Arts Studio.

    Linked to Members, Sessions
  • Members

    Members records for Martial Arts Studio.

  • Sessions

    Sessions records for Martial Arts Studio.

  • Payments

    Payments records for Martial Arts Studio.

    Linked to Bookings
  • Attendance

    Attendance records for Martial Arts Studio.

    Linked to Sessions, People, Bookings

Attendance

5 tablesAbout this feature
  • Attendance

    Attendance records for Martial Arts Studio.

    Linked to Sessions, People, Bookings
  • Bookings

    Bookings records for Martial Arts Studio.

    Linked to Members, Sessions
  • Sessions

    Sessions records for Martial Arts Studio.

  • People

    People records for Martial Arts Studio.

    Linked to Users
  • Users

    Users

    Linked to Users

Belt assessments

5 tablesAbout this feature
  • Belt assessments

    Belt Assessments records for Martial Arts Studio.

    Linked to Bookings
  • Bookings

    Bookings records for Martial Arts Studio.

    Linked to Members, Sessions
  • Members

    Members records for Martial Arts Studio.

  • Sessions

    Sessions records for Martial Arts Studio.

  • Attendance

    Attendance records for Martial Arts Studio.

    Linked to Sessions, People, Bookings

Tournament registrations

4 tablesAbout this feature
  • Tournament registrations

    Tournament Registrations records for Martial Arts Studio.

    Linked to Bookings
  • Bookings

    Bookings records for Martial Arts Studio.

    Linked to Members, Sessions
  • Members

    Members records for Martial Arts Studio.

  • Payments

    Payments records for Martial Arts Studio.

    Linked to Bookings

Payments and services

4 tablesAbout this feature
  • Payments

    Payments records for Martial Arts Studio.

    Linked to Bookings
  • Services

    Services records for Martial Arts Studio.

    Linked to Bookings
  • Bookings

    Bookings records for Martial Arts Studio.

    Linked to Members, Sessions
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

Use booking references to keep each payment, service item, assessment and tournament entry attached to the right reservation. Attendance also references its session and recording person. Review these links during migration; matching names alone can select the wrong member or staff account.

Migration order

  1. Import Users and People, then verify the staff link.
  2. Import Members, membership plans and Sessions.
  3. Import Bookings with their member and session references.
  4. Import Attendance, belt assessments, tournament registrations, Payments and Services against verified bookings.
  5. Review exchange rates as a read-only reference where applicable.

Set up Martial Arts Studio your way.

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

How to get started