Database Schemas

Complete database schema documentation for the Opensure platform.

Available Schemas

Opensure Schema v2.2.1 - Current production schema with MarketFinder support

Opensure Schema v2.2.0 - Previous version (35 tables)

What's New in v2.2.1

• +7 new tables for MarketFinder Chrome Extension prospecting
• +68 fields from Codex-recommended enhancements
• client_locations - Multi-location property tracking
• marketfinder_clients - Prospects before conversion

Schema Features

• Multi-tenant isolation - All tables enforce tenant_id at the database level
• Audit trail - Immutable audit logs for all operations
• Insurance domains - Policies, claims, billing, underwriting, reinsurance
• PHI protection - Health data segregated in private schema
• Type safety - PostgreSQL enums and constraints

Quick Start

1. Review the schema overview
2. Understand multi-tenancy patterns
3. Check table relationships
4. Review audit log structure

---

Documentation last updated: 2025-11-25