As a robust database, I should be able to go in as an admin and see who made changes to what information when.
I've built this into my core library of code which works very nice however, I frequently run into 32k text field limitations. I think audit tracking should be a function of the db system not my code.
I should be able to specify
Field level tracking individual fields or all fields with an exception list to prevent tracking commonly updated fields
It should not track notes key word fields
It should provide a simple reporting mechanism so I can find who changed what field when
It should provide rotating logs so once it's full ( I specify the log size ) then it starts to overwrite the log