>
> I am more interested in database design help. What I am thinking
> right now is right after the deadline, before the reviewer making
> changes, I dup the db schema and back that up, and the current
> schema will have the current data, including changes made by the
> reviewer. If there is dispute and I need to compare original
> version and edited version, I can toggle my variable that has the
> schema name?
I think there is a better way: never update records :-) Instead of
updating, insert a new record and timestamp it. If you just show the
latest version as the working version in the frontend nobody knows the
difference, but you can track all revisions in the background if you
want to.
(This is the same solution as Barney proposed, but with a slightly
different angle on the explanation.)
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
