Advanced Patterns
CommunityArchitect advanced data patterns for auditing.
Software Engineering#auditing#hierarchy#history-tracking#scd-type-2#closure-table#data-model-patterns
Authorikeniborn
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Advanced data modeling patterns enable comprehensive historical auditing, scalable hierarchies, and shared visibility across multiple users in budget-focused applications.
Core Features & Use Cases
- SCD Type 2 history tracking across dimension tables with full versioning
- Closure Table to support fast, non-recursive hierarchical queries
- Shared Budget pattern to allow multiple members to view and interact with transactions while maintaining admin controls and audit trails
Quick Start
Apply SCD Type 2, Closure Table, and Shared Budget patterns to your models using the provided templates and references.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: Advanced Patterns Download link: https://github.com/ikeniborn/familyBudget/archive/main.zip#advanced-patterns Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.