database-architecture

To navigate a Supabase PostgreSQL database schema with multi-tenant architecture, you need detailed documentation of table structures, relationships, and custom data types. This Skill provides comprehensive schema details for the SIMMER mosquito control management system, simplifying complex data access.

Row Level Security (RLS) in a Supabase PostgreSQL database works by enforcing role-based access policies on tables. This Skill explains specific RLS policies and access control mechanisms, guiding agents on security considerations when querying data across multi-tenant operational environments.

Handling spatial data with PostGIS in a PostgreSQL database schema involves understanding specific table structures and custom data types for geographic information. This Skill details spatial data handling patterns used for mosquito control management, facilitating efficient geographic queries and data architecture.

Standard data patterns for audit trails and soft deletes in PostgreSQL involve using specific audit fields and dedicated tables like a deleted_data table. This Skill outlines these patterns, explaining how the database tracks changes and manages soft deletes for operational efficiency.

Querying collections by a specific technician across regions in a PostgreSQL database requires joining the collections, profiles, and regions tables. This Skill guides agents through these necessary joins while explaining relevant Row Level Security considerations for accurate data retrieval.

Yes, this database schema documentation covers custom data types in Supabase for operational efficiency. It details specific table structures, relationships, and spatial data handling with PostGIS, providing comprehensive insights into the custom types used within the multi-tenant architecture.