Using Postgres 18's temporal constraints(depesz.com)

https://www.depesz.com/2024/10/03/waiting-for-postgresql-18-add-temporal-foreign-key-contraints/