Databases

Gym Membership & Class Scheduling Schema

ER Diagrams · made in Skemio

ER diagram of gym schema connecting members, member_passes, classes, sessions, and bookings with waitlist positions.
ER diagram of gym schema connecting members, member_passes, classes, sessions, and bookings with waitlist positions.
Open it in SkemioMake your own

What it shows

  • Separate class definitions from specific scheduled class instances
  • Waitlists use indexed queue positions for deterministic promotion
  • Pass validity checks combine date ranges with remaining credit counters

The takeaway

Decouple templates from recurring schedule instances and manage waitlists with strict sequence numbers.

More er diagrams