A lighter solution may be to provide a mechanism to delete only the column contents except from the structural columns (IDs and FKs), in order to allow the removing of sensitive data and maintain the structural integrity of the audit tables: a support column may be added to each audit table with some info about the deletion (e.g. the c.s.list of the indexes of the erase columns).