Footprints Data Model

Table
Name audit_prop_chg
Comment
A data change record indicating the Inserted or Updated value.  Deleted Values
are not recorded here.

Column
Name Datatype Comment Is PK Is FK
audit_prop_chg_id bigint The automatically generated primary key of the audit_prop_chg table. Yes No
audit_prop_dim_id bigint A Foreign Key to the Audit Property Dimension table. No Yes
val_type_cd char(1)
The data type for a Value Type Code.  The choices are 'S' string, 'D' date, 'T'
text, 'I' integer.
No Yes
new_string_val varchar(255) The value if type String. No No
new_text_val varchar(max) The new value of an inserted or updated property, for a property of type text. No No
new_date_val datetime The new value of an inserted or updated property, for a property of type date. No No
new_real_val numeric(38,20) The new value of an inserted or updated property, for a property of type real. No No
new_long_val bigint
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.
No No
audit_log_id bigint A Foreign Key to the Audit Log table. No Yes
old_string_val varchar(255) The value if type String. No No
old_text_val varchar(max) The old value of an inserted or updated property, for a property of type text. No No
old_date_val datetime The old value of an inserted or updated property, for a property of type date. No No
old_real_val numeric(38,20) The old value of an inserted or updated property, for a property of type real. No No
old_long_val bigint
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.
No No