What problem does it solve?
Designing scalable, well-structured data models and robust migration lifecycles for multi-tenant applications to prevent schema drift and upgrade risks.
The approach follows Open Mercato conventions to plan entities, define fields, choose relationship patterns, add cross-module references, and manage database migrations across releases.
Core Features & Use Cases
- Design Workflow: guided steps from clarifying entities and relationships to generating migrations and validating outputs.
- Entity Design & Field Typing: templates and recommended field types to ensure consistency and type safety across modules.
- Migration Lifecycle: safe patterns for evolving schemas, including adding, renaming, or deprecating columns with audit trails.
- Cross-Module References: model relationships within a module and reference external modules via IDs, supplemented by enrichers for data retrieval.
- Best Practices: soft deletes, data integrity, and non-cross-module ORM relationships aligned with modular boundaries.
- Real-World Use Case: plan a new multi-tenant data model for a suite of interrelated modules.
Quick Start
Define your tenant-scoped entities and relationships, specify fields and keys, then follow the migration workflow to generate and apply migrations.
