Question: Audit on the individual columns

[Ankitwasnik]

Description:

Is there a way to store which columns got updated in the current revision? E.g. Consider a user table

User { id, name, email, ... }

I want to audit all the columns of the user table.

E.g. After auditing, the table should have below columns: UserAud { _seq, _action, _modified_at, id, name, name_mod, // This is of type boolean. Indicates whether the name field was updated in the current revision or not email, email_mod // This is of type boolean. Indicates whether the email field was updated in the current revision or not }

Reason to do this: I want to fetch all the records where the email was updated.