Database Design to store revisions of creating an assessment
Database
2
Posts
2
Posters
0
Views
1
Watching
-
What would be the best way to handle storing revisions of an assessment where a user may edit and save and then final finish the creation of an assessment. Here we would like to keep all revisions.
Use Word and turn on revisions... SMACK ouch Add a RevisionID field to your table and manually increment it when the user checks out the version. In your UI allow the user to "check out" a copy of the data (make another record in your table), allow the user to save the copy of the next revision and they are not allowed to check it out again until they either commit the revision or discard it.
Never underestimate the power of human stupidity RAH