Footprints Data Model

Table
Name defn_ver
Comment 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.

Column
Name Datatype Comment Is PK Is FK
defn_ver_id bigint The automatically generated primary key of the defn_ver table. Yes No
defn_ver_name varchar(255) The name of the Definition Version. See also the configuration settings. No No
defn_id bigint A Foreign Key to the Definition table. No Yes
defn_ver_status_id int A Foreign Key to the Definition Version Status table. No Yes
defn_ver_guid varchar(50) 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. No No