Documentation Index
Fetch the complete documentation index at: https://docs.encoreos.io/llms.txt
Use this file to discover all available pages before exploring further.
Version: 0.1.0
Module: Governance & Risk
Prefix:gr_
Tables: 49
Last Updated: 2026-01-11
Changelog
- 2026-01-11 — v0.1.0 — Initial ERD with 49 tables
Overview
The Governance & Risk module manages organizational policies, compliance audits, risk assessments, incident tracking, and regulatory requirements.Policies ERD
Audits ERD
Risk Management ERD
Incidents ERD
Compliance ERD
RLS Policy Coverage
| Table | SELECT | INSERT | UPDATE | DELETE | WITH CHECK | Status |
|---|---|---|---|---|---|---|
| gr_policies | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| gr_policy_versions | ✅ | ✅ | - | - | - | Version table |
| gr_policy_acknowledgments | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| gr_audits | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| gr_audit_findings | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| gr_risks | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| gr_risk_assessments | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| gr_incidents | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| gr_compliance_requirements | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
Key Tables
gr_policies
Organizational policies with version control and acknowledgment tracking.gr_audits
Internal and external audit records with findings and evidence.gr_risks
Risk register with scoring, ownership, and mitigation tracking.gr_incidents
Incident reports with investigation and corrective action workflow.gr_compliance_requirements
Regulatory compliance requirements mapped to frameworks.Helper Functions
| Function | Purpose |
|---|---|
gr_has_org_access(org_id, user_id) | Check GR module access |
gr_get_policies_due_review(org_id) | Get policies needing review |
gr_calculate_risk_score(likelihood, impact) | Calculate risk score |
gr_get_open_findings(org_id) | Get unresolved audit findings |
Cross-Module Dependencies
- PF: Organizations, profiles, documents
- FW: Policy approval workflows, incident workflows
- HR: Training compliance, employee acknowledgments