Org Structure Repository
Component Detail
Data Layer
high complexity
backend
0
Dependencies
0
Dependents
4
Entities
0
Integrations
Description
Data access layer managing the four linked database tables that form the organizational hierarchy: organizations, national_associations, regions, and local_associations. Handles Supabase queries, foreign key joins for tree construction, and transactional writes for cascade operations.
org-structure-repository
Responsibilities
- CRUD for all four org hierarchy tables
- Build nested tree structures from joined table queries
- Transactional cascade deletes to maintain referential integrity
- Efficient subtree queries for large hierarchies like NHF
Interfaces
fetchFullHierarchy(organizationId)
fetchNationalAssociations(organizationId)
fetchRegionsByNational(nationalAssociationId)
fetchLocalsByRegion(regionId)
insertNationalAssociation(data)
insertRegion(data)
insertLocalAssociation(data)
updateNode(table, id, data)
deleteNodeCascade(table, id)
bulkInsertLocalAssociations(rows)
searchAcrossLevels(query)
Related Data Entities (4)
Data entities managed by this component