Structured Membership Tiers — Every Perk Hits Stripe as Real Dollars

Every membership tier perk now flows through a server-authoritative pricing pipeline that actually reduces the Stripe charge. Nine surfaces, five discount types, five cadences, age + time-of-day eligibility gates, one-time initiation fees, audit-logged grandfathering. This update is designed for clubs and players who want a better the platform experience — less manual work, more control, and a smoother workflow.

What's Included

Nine billable surfaces covered: court reservations, open play, leagues, tournaments, clinics, coaching lessons, ball machine, guest passes, initiation fees

Five discount types: percentage off, fixed off, free, allowance (first N per cadence), free with cap

Five cadences: daily, weekly, monthly, quarterly, annually — anchored to the club's clock

Eligibility gates enforced server-side: age (COPPA-floored at 13), hours, days of week, locations

One-time initiation fees via Stripe Connect — waivable, with configurable reapplication window

JSONB schema validator rejects tampered blobs: negative percents, out-of-range values, allowance on non-allowance surfaces, unknown keys

Immutable audit log on every tier edit — actor, IP, user agent, full before/after JSON

Grandfathering: existing active members keep their original terms until explicit 'Apply to existing members' action

Per-club shadow-compare flag runs both legacy and new paths in parallel and logs divergence before flipping

Backfill rake task translates legacy fields (court_rate_discount_percent, event_pricing JSONB, free_*_per_month) into structured data — Snovalley skipped by default

New league and tournament resolvers route through ClubPricing for the first time — their discounts now actually apply

Deterministic perks formatter: structured inputs generate the human-readable perk bullet list

Why This Matters

Structured Membership Tiers — Every Perk Hits Stripe as Real Dollars addresses a real need for clubs and players. Every membership tier perk now flows through a server-authoritative pricing pipeline that actually reduces the Stripe charge. Nine surfaces, five discount types, five cadences, age + time-of-day eligibility gates, one-time initiation fees, audit-logged grandfathering. By building this directly into the platform, clubs and players save time and get a more reliable experience — no workarounds, no third-party tools, no spreadsheets.