I am not sure I am missing something here.

You state:

"This example tracks the progress of auditing in just one table. All the tables in the database, without exception, operate on this same principle"

mmm.

Surely if you delete a record from the AdmUser Table (hopefully the constraint won't let you), it would mess up.

Cheers