sql – Database design to accomodate daisy chained records

sql – Database design to accomodate daisy chained records

You could create a new table that basically keeps track of the chain of policies. Each time a policy is renewed, create an entry in this table so that the renewed, or current, policy points to the old policy. This will make displaying policy histories easier whether youre displaying history for the current policy or an older policy. Also, if you need to keep track of different categories of objects (policies, contracts, or what-have-you), you can add a object type column as a solution – that way you dont have a bunch of these types of tables cluttering your database!

sql – Database design to accomodate daisy chained records

Leave a Reply

Your email address will not be published. Required fields are marked *