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 |