Avoid infinite recursion in Row Level Security policies by using direct authentication checks instead of self-referential queries
Structure facility manager permissions to respect organizational hierarchy and include comprehensive event data for state validation
Include all relevant event types in check-in state queries to ensure complete state reconstruction and prevent security gaps
Validate critical environment variables and security configuration during build process to catch issues before production