Footprints Data Model |
Table |
Name | audit_prop_dim |
Comment |
A dimension table that holds every combination of Object Name, Property Name, Insert Update Delete Code, etc. that has been used in the Audit Trail. The purpose of this data design is to compress the repeated information in the Audit Trail, reducing data and speeding up indexed queries. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
audit_prop_dim_id | bigint | The automatically generated primary key of the audit_prop_dim table. | Yes | No |
audit_class_name | varchar(255) | The Java Class name of the object. | No | No |
prop_class_name | varchar(255) | The Java Class name of the object. | No | No |
coll_class_name | varchar(255) | The Java Class name of the object. | No | No |
prop_mbr_name | varchar(255) | The name of the Object Property Name. | No | No |
item_defn_id | bigint | A Foreign Key to the Definition 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 |
is_audited | bit | Indicates if Is Audited. | No | No |