How can I add in my audit table a column with actions that was done (modify, create,delete) using Hi-CodePudding

I know the type of operations are represented like numbers but can I make them appear as string type ("UPDATE / DELETE / INSERT")

I think rev or revtype show what type of operation is ( I tried edit, delete and insert in this order and that s the result )

This is my product_aud

CodePudding user response：

The change history is stored in the SOME_ENTITY_AUD tables corresponding to the SomeEntity instances. The SOME_ENTITY_AUD table has a field - REVTYPE - Represented by numbers from 0 to 2:

0-ADD
1-MOD
2-DEL

See more details in the same question.