There’s also temporal modeling or bitemporal modeling. It’s verbose and can make table length pretty large, but eh.. - https://martinfowler.com/articles/bitem

There’s also temporal modeling or bitemporal modeling. It’s verbose and can make table length pretty large, but eh.. - https://martinfowler.com/articles/bitemporal-history.html https://martinfowler.com/articles/bitemporal-history.html - https://hdombrovskaya.files.wordpress.com/2016/09/bi_temporal_pg_open_2016.pdf https://hdombrovskaya.files.wordpress.com/2016/09/bi_tempora... - https://github.com/scalegenius/pg_bitemporal https://github.com/scalegenius/pg_bitemporal