Site & Cadastre Management Enhancement - Brownfield Epic
Epic Goal​
Enhance the existing site and cadastre management system to provide comprehensive property lifecycle management with automated document workflows, cadastral integration, and status progression that seamlessly extends the current NestJS/Prisma architecture.
Epic Description​
Existing System Context:
- Current functionality: Basic CRUD operations for sites with client association, cadastre linking, and status tracking through SiteStatus enum
- Technology stack: NestJS controllers/services, Prisma ORM, PostgreSQL database, Swagger documentation
- Integration points: Client (N:1), Cadastre (N:1 optional), Reclamation (1:N), ApporteurAffaire relationships
- Existing patterns: Controller/Service architecture, DTO validation, status enum handling, unique reference generation
Enhancement Details:
- What's being added/changed: Complete site management workflow including document requirement tracking, cadastral document automation, status progression validation, and enhanced property management capabilities
- How it integrates: Extends existing SiteService methods, adds workflow endpoints to SiteController, leverages existing Client/Cadastre/Reclamation relationships
- Success criteria: Automated site management workflow operational, document tracking functional, cadastral integration working, existing functionality preserved
Stories​
-
Story 1: Site Document Workflow Management
- Implement document requirement tracking for sites based on status
- Add automated document validation and status progression rules
- Create document missing alerts and completion tracking system
-
Story 2: Enhanced Cadastre Integration & Management
- Improve cadastre assignment and management workflows
- Add cadastre document synchronization and validation
- Create cadastre contact management and communication tracking
-
Story 3: Site Status Automation & Business Rules
- Implement automated status transitions based on document completion
- Add business rule validation for status changes (NOUVEAU → DEMANDE_DOCUMENTS_CADASTRAUX → etc.)
- Create site lifecycle reporting and audit trail functionality
Compatibility Requirements​
- Existing APIs remain unchanged (GET /sites, POST /sites, GET /cadastres)
- Database schema changes are backward compatible (additive fields only)
- UI changes follow existing Swagger documentation patterns
- Performance impact is minimal (optimized queries with existing includes)
Risk Mitigation​
- Primary Risk: Breaking existing Client/Cadastre relationships and site-based reclamation queries
- Mitigation: All new features are additive, existing service methods preserved, comprehensive relationship testing with Client and Reclamation entities
- Rollback Plan: Database migrations are reversible, new workflow endpoints can be disabled via feature flags, existing CRUD functionality isolated
Definition of Done​
- All stories completed with acceptance criteria met
- Existing site CRUD functionality verified through testing
- Integration points with Client, Cadastre, Reclamation working correctly
- Swagger documentation updated appropriately
- No regression in existing site status management and reference generation
Story Manager Handoff​
"Please develop detailed user stories for this brownfield epic. Key considerations:
- This is an enhancement to an existing system running NestJS/Prisma/PostgreSQL
- Integration points: Client (N:1), Cadastre (N:1 optional), Reclamation (1:N), ApporteurAffaire relationships through Client
- Existing patterns to follow: Controller/Service/DTO architecture, unique reference generation, SiteStatus enum progression, optional cadastre relationships
- Critical compatibility requirements: Preserve existing API endpoints, maintain database relationship integrity, follow existing SiteStatus enum patterns (NOUVEAU → DEMANDE_DOCUMENTS_CADASTRAUX → DOCUMENTS_CADASTREAUX_RECUS → etc.)
- Each story must include verification that existing site functionality (CRUD, client association, reclamation relationships, cadastre linking) remains intact
The epic should maintain system integrity while delivering comprehensive site and cadastral property management workflow automation."