Gym Management

Overview

Gym management platform schema for fitness centers and health clubs. Covers member lifecycle, class scheduling, trainer management, equipment maintenance, and payment processing.

Key Design Decisions

• Membership Plans: Tiered plans (basic, premium, VIP) with freeze/cancel support
• Class Scheduling: Recurring class templates with capacity limits and waitlists
• Equipment Tracking: Maintenance scheduling with service history and downtime logging
• Trainer Specialties: Multi-specialty trainers with client assignment tracking

Tables

10-14 tables covering members, membership plans, memberships, classes, class schedules, enrollments, trainers, trainer specialties, equipment, equipment maintenance, facilities, and payments.