Database Architecture

SureStage uses PostgreSQL (AWS Aurora) with a schema-per-service pattern for data isolation.

Database Topology

Schema Ownership

Each microservice owns its schema exclusively. Cross-service data access happens through REST API calls, never through direct database queries.

Schema	Owner Service	Key Tables
identity	Identity Service	users, roles, permissions
organization	Organization Service	companies, api_keys, audit_logs
mock_engine	Mock Engine Service	instances, routes, responses
proxy	Proxy Service	proxy_configs, recording_sessions
platform	Platform Service	systems, templates, tasks
collections	Collections Service	collections, collection_versions

Conventions

• All tables use UUID v4 primary keys
• Timestamps are TIMESTAMPTZ in UTC
• Soft delete via deleted_at column where applicable
• Multi-tenancy enforced via company_id foreign key
• Indexes on all foreign keys and common query patterns