Hi,

I'm developing a web application now. I want to create activity log, session log and audit log .

Activity log is used to keep track user's activity. For example, which button they are clicking on, which page they are trying to access and so on. While, session log is to keep track login and logout session of users. Audit log is to keep track the changes of the value of every fields (old and new value), added/edited/deleted by who and when.

Can give any suggestion on how to implement it ? what is the best approach of the database design ?

Thanks :)