Neil Tompkins Audit Table storage for Primary Key(s)
May 30, 2013; 08:27
Neil Tompkins
Audit Table storage for Primary Key(s)
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
May 31
Neil Tompkins Fwd: Audit Table storage for Primary Key(s)
May 31, 2013; 09:43
Neil Tompkins
Fwd: Audit Table storage for Primary Key(s)
May 31
Carsten Pedersen Re: Audit Table storage for Primary Key(s)
May 31, 2013; 10:58
Carsten Pedersen
Re: Audit Table storage for Primary Key(s)
May 31
Neil Tompkins Re: Audit Table storage for Primary Key(s)
May 31, 2013; 10:14
Neil Tompkins
Re: Audit Table storage for Primary Key(s)
May 31
Carsten Pedersen Re: Audit Table storage for Primary Key(s)
May 31, 2013; 12:03
Carsten Pedersen
Re: Audit Table storage for Primary Key(s)
May 31
Neil Tompkins Re: Audit Table storage for Primary Key(s)
May 31, 2013; 11:58
Neil Tompkins
Re: Audit Table storage for Primary Key(s)
May 31
Carsten Pedersen Re: Audit Table storage for Primary Key(s)
May 31, 2013; 13:05
Carsten Pedersen
Re: Audit Table storage for Primary Key(s)
May 31
Andrew Moore Re: Audit Table storage for Primary Key(s)
May 31, 2013; 13:02
Andrew Moore
Re: Audit Table storage for Primary Key(s)
May 31
Rick James RE: Audit Table storage for Primary Key(s)
May 31, 2013; 18:54
Rick James
RE: Audit Table storage for Primary Key(s)
May 31
Jason Trebilcock RE: Audit Table storage for Primary Key(s)
May 31, 2013; 17:28
Jason Trebilcock
RE: Audit Table storage for Primary Key(s)
May 31
Andrew Moore Re: Audit Table storage for Primary Key(s)
May 31, 2013; 23:33
Andrew Moore
Re: Audit Table storage for Primary Key(s)
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!