Data Health Dashboard
Track and fix missing operational records. Safe backfill actions only.
0
Missing Medical Profiles
Players need structured medical records
0
Missing Emergency Contacts
Players missing emergency contact
0
Missing Authorised Collectors
Players need pickup authorization
0
Missing Consent Records
Players missing consent approvals
0
Paid Bookings - No Payment Record
Bookings marked paid without Payment record
0
Invoice Bookings - No Record
Invoice payments without Invoice record
0
Camp Programmes - No Operations Record
Camp programmes missing Camp operations
0
Coach Compliance Issues
Missing DBS or First Aid documents
Booking.create RLS is currently open
The Booking.create rule has no parent_email restriction, meaning any authenticated user can technically create a booking for any player. This was intentionally left open during V2 dashboard testing to prevent blocking parent booking flows. Recommend tightening after live parent dashboard tests pass.
Suggested constraint: data.parent_email = user.email OR user.role = admin/coach
Marks past cash/card/bank_transfer centre bookings as paid so parents no longer see them as outstanding debt. Does not affect invoice bookings, cancelled bookings, or future sessions.
Finds parents whose linked_player_ids are missing or incomplete, then adds their children by matching parent_email. Never removes existing links. Preview before applying.
Enter a parent email to diagnose why they may not see their children. Checks all discovery paths (parent_email, shared_with_emails, created_by, created_by_id, linked_player_ids, gmail alias, bookings).