People, organisations and alliances
One table for every customer, supplier and employee, with roles and alliances stored as dated relationships instead of extra tables — and the realm on any past date as a single query. Westeros supplies the test data.
-
Westeros, the Iron Throne, and a Model for Complex Relationships
One table for every customer, supplier and employee, with roles and alliances as dated relationships instead of extra tables. Tested on Westeros, where everyone knows who betrayed whom and when.
-
The Realm at Any Date
Answer who reported to whom on any past date from the data you already store, with no history tables and no migrations. One dated relationship table and a single filter do it; Westeros supplies three centuries of test data.