April 22, 2003 at 9:02 pm
I would like to hear if it is a common table design practice to track the names of the users who modify data along with the dates of the modifications. Several years ago I worked at a company that, for most tables, tracked the following information.
Create User - User Id of person who created the record
Create Date - Date and time of record creation
Modify User - User Id of person who modified the record
Modify Date - Date and time of record modification
Is this a common practice?
Thanks, Dave
April 23, 2003 at 1:37 am
It is if you know what you are doing with database tables and how to design them properly when the values inside them can be created or modified by a user.
Didn't used to work at Guardian Insurance did ya?
Edited by - swjs on 04/23/2003 01:38:06 AM
April 23, 2003 at 9:03 am
April 23, 2003 at 10:07 am
Thanks for the suggestions.
Dave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply