Can column names be specified for auto-generated audit tables?

[zmelvin]

It looks like the column names used in the generated audit tables (_aud) match the column names used in the audited entity.  Just wondering if there is a way to change this?

For example:

@Audited

@Column(name="USER_NAME")

String userName;

will create a table classname_aud with the column USER_NAME.  Is there a way to specify that I would like this column to be userName?

I know I can just go in and update tables in the database to use column names I prefer, but it would be nice if there was something already availabe like @Audited(name="userName") that I could use.

Thanks,

Zak

[adamw]

No, you cannot change the column names. Why would you want to do this anyway?

Adam

[zmelvin]

Hi Adam.  Thanks for the response.  I'm using a custom revision entity to store information about the user making changes to the audited entity.  I was trying to access the data stored in the audit tables by querying them directly using <fully qualified package>.Entityname_AUD you mentioned here: https://community.jboss.org/message/4727#4727. 

As it turns out, the data in the audit tables can be retrieved using the AuditQuery.  Once I figured out how to use AuditQuery my question became more of a curiosity than anything else.

Thanks again for the help.

Zak