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