On 31 Mar 2010, at 7:51, Justin Giboney wrote: > Is there a design pattern for handling updates to information? > > I am designing a application that needs to know when things changed > and who changed them. Is the best way to do this to create a > transaction table for each table in the database that records the new > update every time something changes
Do you need a history or simply the last time it changed? I put created, modified, and modifiedby columns of nearly every table. It's nice to know who did what when. If you need more than the last change however then you would need a separate table as you suggested. I'm not aware of a standard for something such as that though.
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
