Footprints Data Model

Table
Table Name Audit Property Change
Table Definition A data change record indicating the Inserted or Updated value. Deleted Values are not recorded here.

Attribute
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