RequirementPreview contractOwning surfacePrimary gateAcceptance evidence
DB-001DBManaged PostgreSQL is the authoritative cloud source of truthDIAGNOSTICreportsGate 5G03-COV-DB-001DB-002DBShared database/schema with mandatory trusted tenant ownership on every tenant recordDIAGNOSTICreportsGate 5G03-COV-DB-002DB-003DBApplication scope checks plus PostgreSQL row-level-security/equivalent database policyDIAGNOSTICreportsGate 5G03-COV-DB-003DB-004DBTyped SQL-first repository policy for core financial and inventory domainsDIAGNOSTICreportsGate 5G03-COV-DB-004DB-005DBExpand/backfill/verify/switch/contract migration disciplineDIAGNOSTICreportsGate 5G03-COV-DB-005DB-006DBAppend-only stock, accounting, loyalty, wallet, allocation, audit, and offline-event ledgersDIAGNOSTICreportsGate 5G03-COV-DB-006DB-007DBCached projections remain verifiable from ledgers and approved snapshotsDIAGNOSTICreportsGate 5G03-COV-DB-007DB-008DBPostgreSQL transactional outbox committed with the source business transactionDIAGNOSTICreportsGate 5G03-COV-DB-008DB-009DBIdempotent workers with retry, dead-letter/manual review, dependency, and queue-age controlsDIAGNOSTICreportsGate 5G03-COV-DB-009DB-010DBRedis limited to non-authoritative cache, rate-limit, presence, and coordination useDIAGNOSTICreportsGate 5G03-COV-DB-010DB-011DBPrivate encrypted tenant-scoped object storage with versioning, scanning, hashes, and immutable archive capabilityDIAGNOSTICreportsGate 5G03-COV-DB-011DB-012DBPostgreSQL exact/trigram/full-text search before a dedicated search serviceDIAGNOSTICreportsGate 5G03-COV-DB-012DB-013DBReporting via indexed reads, replicas, projections, and materialised views while ledgers remain authorityDIAGNOSTICreportsGate 5G03-COV-DB-013DB-014DBFuture dedicated enterprise database/deployment without changing domain behaviourDIAGNOSTICreportsGate 5G03-COV-DB-014DB-015DBProduction data prohibited in development except minimised approved anonymised diagnosticsDIAGNOSTICreportsGate 5G03-COV-DB-015