Discussion Locked

DB Design - date sensitive changes

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Anyone have any good ideas about how to capture changes over time? I have a table that has attributes that I need to be able to retrieve what the values were at specified dates in the past.
Is the only way to do this by use of an additional table with an 'Effective From' date or does someone know of a better way to do it?

3 replies

by nmourfield

I would add two fields to the table, an effective date and an enabled. This way, it is quick to find which is enabled. Index off of enabled first.

by kdowson

It seems this is the best and probably only way to do it. Just wanted clarification that I was heading down the right path.
Thank you.

This discussion is closed to new replies.