Temporal database design, with a twist (live vs draft rows)
Anchor modeling is a nice way to implement a temporal dB — see the Wikipedia article too. Takes some time to get used to, but work nice. There is an online modeling tool and if you load the supplied XML file [File -> Load Model from Local File] you should see something like this — … Read more