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://hdombrovskaya.files.wordpress.com/2016/09/bi_tempora...

- https://github.com/scalegenius/pg_bitemporal