Last Updated: 2026-01-11
Total Tables: 433
Modules: 9
Overview
This directory contains Entity Relationship Diagrams (ERDs) for all Encore OS Platform database modules. Each diagram shows table relationships, foreign keys, and RLS policy coverage.High-Level Architecture
Module ERDs
Cross-Module Dependencies
All modules depend on Platform Foundation (PF) for:- Organization context (
pf_organizations) - User identity (
pf_profiles,pf_user_roles) - Site/location (
pf_sites) - Audit tracking (
pf_audit_logs)
RLS Policy Coverage Summary
Legend:
- Full Coverage: 4 policies (SELECT, INSERT, UPDATE, DELETE)
- Partial: Intentional < 4 policies (audit/version tables)
- Special: Custom access patterns (deny-all, public read, etc.)