As far as the logging idea goes, I would suggest putting a trigger on that table that automatically fires any time a record is updated/inserted/deleted. It could put in info such as user id, datetime stamp, old value, new value, etc.

I have done this before on an entire database, storing the table name as well. It works really well, and has also saved my butt a couple times when I was able to actually recreate the database after issuing some not so well thought out commands (like zap).

Instead of actually physically deleting records through my app, I put a deleted field in each table and tracked them that way. It makes it easier to track.

HTH