OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Audit Table storage for Primary Key(s)

From: Neil Tompkins (neil.tompkinsgooglemail.com)
Date: Thu May 30 2013 - 02:27:34 CDT

Hi,

I've created a Audit table which tracks any changed fields for multiple
tables. In my Audit table I'm using a UUID for the primary key. However I
need to have a reference back to the primary key(s) of the table audited.

At the moment I've a VARCHAR field which stores primary keys like

1
1|2013-05-29
2|2013-05-29
2
3
1|2|2
etc

Is this the best approach, or should I have a individual field in the audit
table for all primary keys. At the moment I think the max number of
primary keys on any given table is 3

Thanks
Neil