Infrastructure medium complexity backend
0
Dependencies
0
Dependents
3
Entities
0
Integrations

Description

Database migration scripts that create the closure table schema for organization hierarchy, set up materialized views for aggregate reporting, and seed the initial hierarchy from existing organization data. Includes rollback support for safe deployment.

Feature: Multi-Organization Hierarchy

hierarchy-migration-seeder

Responsibilities

  • Create closure table schema and indexes for organization hierarchy
  • Set up materialized views for nightly aggregate statistics refresh
  • Seed initial hierarchy relationships from existing organization records
  • Provide rollback scripts for safe migration reversal

Interfaces

runMigration(): void
rollbackMigration(): void
seedInitialHierarchy(existingOrgs): void
validateMigrationState(): boolean

Related Data Entities (3)

Data entities managed by this component