Backend mirror

Dashboard

Admin structure matches the iOS app's five tabs. Each section maps to live Supabase tables — nothing here exists without a client connection.

App tabs

Home

4 live surfaces

Events

1 live surface

Coach

1 live surface

Studio

2 live surfaces

Passport

3 live surfaces

Live counts

Members

Events

RSVPs

Coach sessions

CVs

Applications

Connected tables (34)

Tables referenced by admin surfaces that mirror the app or website.

automated_emailsautomated_pushescertificatesconnectionsdaily_jeddah_photosdaily_quotesdiscount_offersdiscount_partnersdiscount_redemptionseventshome_greetingsmember_activity_eventsmember_cvsmember_tiersmessagesnewsletter_issuesnewsletter_sendsnewsletter_subscribersonboarding_preferencesopportunitiesopportunity_applicationsopportunity_categoriespage_seopractice_sessionsprofilespublic_profilespush_delivery_logpush_tokensrsvpssite_contentsite_seowaitlistwallet_passeswallpapers

Internal only (3)

Still in Postgres for triggers/RPCs — not in mirror nav.

blocked_keywords — DB trigger moderates messages; no admin editor yet
opportunity_invitations — Eligibility RPC only; no invite admin yet
get_daily_quote() — iOS queries daily_quotes table directly

Removed (058)

learning_moduleslessonslearning_progressdaily_promptsai_preferencescontent_translationsonboarding_flow_stepsonboarding_first_week_plansonboarding_eventsmessage_reportspublic_cv_profilesthumbnails

Website & communications

Website

3 surfaces

Communications

3 surfaces