Footprints Data Model

Table
Table Name Audit Property Dimension
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Audit Property Dimension Id The automatically generated primary key of the audit_prop_dim table. LONG Yes
Audit Class Name The Java Class name of the object. VARCHAR(255) Yes
Property Class Name The Java Class name of the object. VARCHAR(255) No
Collection Class Name The Java Class name of the object. VARCHAR(255) No
Property Member Name The name of the Object Property Name. VARCHAR(255) No
Item Field Definition Id A Foreign Key to the Definition table for an instance of type Definition. LONG No
Value Type Code The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. CHAR(1) No
Is Audited Indicates if Is Audited. BOOLEAN Yes