Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Audit Property Change Id |
The automatically generated primary key of the audit_prop_chg table. |
LONG |
Yes |
Audit Log Id |
A Foreign Key to the Audit Log table. |
LONG |
Yes |
Audit Property Dimension Id |
A Foreign Key to the Audit Property Dimension table. |
LONG |
Yes |
Value Type Code |
The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer.
|
CHAR(1) |
Yes |
New String Value |
The new value of an inserted or updated property, for a property of type string. |
VARCHAR(255) |
No |
New Text Value |
The new value of an inserted or updated property, for a property of type text. |
TEXT |
No |
New Date Value |
The new value of an inserted or updated property, for a property of type date. |
DATE |
No |
New Real Value |
The new value of an inserted or updated property, for a property of type real. |
DECIMAL(,) |
No |
New Long Value |
The new value of an inserted or updated property, for a property of type long integer. This may be a key, in which case the Convenience Value might also be stored.
|
LONG |
No |
Old String Value |
The old value of an inserted or updated property, for a property of type string. |
VARCHAR(255) |
No |
Old Text Value |
The old value of an inserted or updated property, for a property of type text. |
TEXT |
No |
Old Date Value |
The old value of an inserted or updated property, for a property of type date. |
DATE |
No |
Old Real Value |
The old value of an inserted or updated property, for a property of type real. |
DECIMAL(,) |
No |
Old Long Value |
The old value of an inserted or updated property, for a property of type long integer. This may be a key, in which case the Convenience Value might also be stored.
|
LONG |
No |