This repository demonstrates an advanced PostgreSQL schema for managing hierarchical data with bitemporal tracking (both business time and system time) using a closure table pattern and PostgreSQL's ltree extension.
Bitemporality: Tracks two independent time dimensions:
- Effective Time (
effective_range): When something was true in the real world (business time)