Footprints Data Model

Table
Table Name Definition Version
Table Definition A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Definition Version Id The automatically generated primary key of the defn_ver table. LONG Yes
Definition Version Name The name of the Definition Version. VARCHAR(255) No
Definition Version Status Id A Foreign Key to the Definition Version Status table. INTEGER No
Definition Version GUID A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data. VARCHAR(50) No
Definition Id A Foreign Key to the Definition table. LONG Yes