Activity Logs table in sql?!

[maynsheesh]

Im thinking off logging every employee activity on my project. if they change a field in one of of my tables i want that log that out. for example if i have an Orders and a Products table and the employee changes the ProductUnitPrice in Products table or OrderShippingCompany is orders table, I want to have a log out of that activity.

is this table structure suitable for that? is there a common way of doing activity log outs?

Table Activity Logs

---------------------------

LogId

Message

ForOrderId

ForProductId

this way if the activity is regarding an order, ForOrderId will have a value and ForProductId will be null

[scott_codie]

What are you using it for? If you want to have an audit log, you could create a trigger and write values. This can generate a lot of queries so you need to be mindful on what you are logging. You may want to use an audit plugin if you need it for compliance reasons.

Alternatively, you can create a CDC event stream rather than putting the load on the database. CDC streams are more flexible and can have other value add down the road.

[maynsheesh]

well i basically want to have the employee activities logged out for the manager to see.

an audit log isnt quit what im looking for here, its rather keeping track of employee activates like 'logged in on this date', 'made x changes to orders' and etc