| name | agent-module-django-postgres-db-standard |
| description | Module: Relational Database Creation Standard (Django + PostgreSQL) |
Module: Relational Database Creation Standard (Django + PostgreSQL)
1. Module Metadata
- Module ID:
agent.module.db-design-django-postgres
- Version:
1.0.0
- Maturity:
production
- Scope: Schema design, validation, indexing, ORM patterns, and quality controls for operational systems.
- Primary outcomes:
- Transaction-safe relational core.
- Query-aligned indexing and predictable performance.
- Layered validation and ingestion reliability.
2. Mission and Applicability
Use this module to design and implement production-grade PostgreSQL schemas in Django-based systems.
Apply when:
- Domain requires strong consistency for transactional workflows.
- APIs demand filtered list views, auditability, and repeatable ingestion.
- Team uses Django ORM with DRF or equivalent service layer.
Do not apply directly when:
- Workload is append-only analytics without transactional constraints.
- Primary storage is fully document/columnar/graph-native.
3. Canonical Architecture Pattern
- Pattern:
Relational source of truth + operational telemetry tables
- Data domains:
- Identity and access
- Core operational entities
- Ingestion/sync state and error logs
- Audit trail and compliance events
- Persistence principles:
- FK relationships for ownership and accountability
- JSON fields only for bounded semi-structured payloads
- Business key upsert logic for external data feeds