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 |