We have a database table with insurance policies. This is managed by a service that exposes an API that our customers can use to create and modify policies. When a change is made to a policy, like for example the coverage limit being increased, we need to store both the old and the new revisions of the policy. The API needs to be able for any given time to return the state of the policy as it was on a given date. As an example, we have a 1 year renter's insurance policy starting January 1. On July 1, i.e. 6 months later, the policy (customer) decides to increase the coverage limit from $50K to $75K. We need to store the policy as it was before and after the change. How would you implement this? The backend is a relational database, but if you have other methods or data store types to solve this that you find to be better, feel free to use them. Columns: id, type, deductible, cov_limit, cov_start_date, cov_end_date, customer_id
