Post reply

What is the best way of logging history.

  • March 1, 2005 at 6:17 am

    #65453

    what is the best way of logging activities.i have 4 tables as below. i want to put the records in userwork table to a history_userwork table when the work is over. The history table should keep records more than 10 lakhs.

    users or sections or works  can be deleted at any time. should i loggin the actual names in log instaed of ids in that case? or keep another history tables for that.

    Users [id ,name,Data]

    Sections[id,name,Data]

    Works[id,name,Data]

    UserWork[userid,workid,sectionid,time,Data]

     

     

  • March 1, 2005 at 7:46 am

    #544608

    As a pure history record, it seems reasonable to record it as clearly and independent as possible. ie if you log the actual names of users, users can be removed from users table. If you don't record the actual names, then logically the history should prevent users that have history to be removed from users table.

    /Kenneth

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply