KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to design a history table to keep track of multiple values that were changed on a specific record when edited. Example: The user is presented with a page to edit the record. Title: Mr. Name: Joe Tele: 555-1234 DOB: 1900-10-10 If a user changes any of these values I need to keep track of the old values and record the new ones. I thought of using a table like this: History --------------- id modifiedUser modifiedDate tableName recordId oldValue newValue One problem with this is that it will have multiple entries for each edit. I was thinking about having another table to group them but you still have the same problem. I was also thinking about keeping a copy of the row in the history table but that doesn't seem efficient either. Any ideas? Thanks!
Tags (comma-separated)
Save Edits
Cancel