Subject Area : 901 - Tables Added
Subject Area Name Definition
901 - Tables Added Tables added since the last release.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
cntnr_snapshot Container Snapshot false
Physical Name Attribute/Column Name Definition Physical Data Type
cntnr_snapshot_id Container Snapshot Id The automatically generated primary key of the cntnr_snapshot table. bigint
cntnr_defn_id Container Definition Id A Foreign Key to the Definition table. bigint
create_date Create Date The date that the Container Snapshot was created. datetime
snapshot_status_name Snapshot Status Name The unique string identifier for an instance of Snapshot Status. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
last_good_publ_date Last Good Publish Date datetime
snapshot_cfg_setting_val Snapshot Configuration Setting Value false Configuration Setting Value is an association between the Configuration Setting entity and a container entity (i.e. User Profile, Role, and Definition). This association contains a distinct value for each of the intersection points between the two entities.
Physical Name Attribute/Column Name Definition Physical Data Type
cfg_setting_val_id Configuration Setting Value Id The automatically generated primary key of the snapshot_cfg_setting_val table. bigint
cfg_setting_id Configuration Setting Id A Foreign Key to the Snapshot Configuration Setting Value table. bigint
val_type_cd Value Type Code The data type for a Snapshot Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. char(1)
string_val String Value The value of a Snapshot Configuration Setting Value, stored as a string. varchar(255)
text_val Text Value The value of a Snapshot Configuration Setting Value, stored as a long text object. varchar(max)
real_val Real Value The value of a Configuration Setting Value stored as a real. numeric(38,20)
long_val Long Value The value of a Configuration Setting Value stored as Long. bigint
date_val Date Value The value of a Snapshot Configuration Setting Value, stored as a date. datetime
boolean_val Boolean Value The value of a Configuration Setting Value stored as Boolean. bit
int_val Int Value The value of a Configuration Setting Value stored as Int. int
owner_id Owner Id A Foreign Key to the Owning instance in either the Definition, Definition Version , Role, or User Profile tables. bigint
val_map_key Value Map Key The value of a Snapshot Configuration Setting Value, stored as a string. varchar(255)
cfg_setting_owner_type_name Configuration Setting Owner Type Name The unique string identifier for an instance of Snapshot Configuration Setting Value. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
cntnr_snapshot_id Container Snapshot Id A Foreign Key to the Container Snapshot table. bigint
snapshot_defn Snapshot Definition false
Physical Name Attribute/Column Name Definition Physical Data Type
cntnr_snapshot_id Container Snapshot Id A Foreign Key to the Container Snapshot table. bigint
defn_id Definition Id A Foreign Key to the Definition table. bigint
defn_name Definition Name The name of the Snapshot Definition. nvarchar(4000)
dsble_date Disabled Date The date that this instance of Snapshot Definition is logically deleted and disabled. datetime
defn_guid Definition GUID A Global Unique IDentifier search key for the Snapshot Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
defn_type_name Definition Type Name The unique string identifier for an instance of Snapshot Definition. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
defn_subtype_id Definition Subtype Id A Foreign Key to the Snapshot Definition table. int
tmpl_export_guid Template Export GUID The value of a Snapshot Definition, stored as a string. VARCHAR(50)
snapshot_defn_reln Snapshot Definition Relationship false All relationships between definitions are stored in this table in order to make the model able to handle new relationships without changes to tables.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_reln_id Definition Relationship Id The automatically generated primary key of the snapshot_definition_relationsh table. bigint
from_defn_ver_id From Definition Version Id A Foreign Key to the Snapshot Definition Relationship table. bigint
to_defn_ver_id To Definition Version Id A Foreign Key to the Snapshot Definition Relationship table. bigint
defn_reln_type_id Definition Relationship Type Id A Foreign Key to the Snapshot Definition Relationship table. int
cntnr_snapshot_id Container Snapshot Id A Foreign Key to the Container Snapshot table. bigint
snapshot_defn_ver Snapshot Definition Version false 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.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id A Foreign Key to the Snapshot Definition Version table. bigint
defn_ver_id Definition Version Id The automatically generated primary key of the snapshot_definition_version table. bigint
defn_ver_name Definition Version Name The name of the Snapshot Definition Version. varchar(255)
defn_ver_status_id Definition Version Status Id A Foreign Key to the Snapshot Definition Version table. int
defn_ver_guid Definition Version GUID A Global Unique IDentifier search key for the Snapshot Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
cntnr_snapshot_id Container Snapshot Id A Foreign Key to the Container Snapshot table. bigint
snapshot_defn_ver_assoc Snapshot Definition Version Assoc false
Physical Name Attribute/Column Name Definition Physical Data Type
defn_ver_association_id Definition Version Association Id The automatically generated primary key of the snapshot_definition_version_as table. bigint
from_defn_ver_id From Definition Version ID A Foreign Key to the Snapshot Definition Version Assoc table. bigint
to_defn_ver_id To Definition Version ID A Foreign Key to the Snapshot Definition Version Assoc table. bigint
association_type_id Association Type Id A Foreign Key to the Snapshot Definition Version Assoc table. bigint
cntnr_snapshot_id Container Snapshot Id A Foreign Key to the Container Snapshot table. bigint
snapshot_status Snapshot Status false
Physical Name Attribute/Column Name Definition Physical Data Type
snapshot_status_id Snapshot Status Id The unique identifier for an instance of Snapshot Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
snapshot_status_name Snapshot Status Name The unique string identifier for an instance of Snapshot Status. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
snapshot_type Snapshot Type false
Physical Name Attribute/Column Name Definition Physical Data Type
snapshot_type_id Snapshot Type Id The unique identifier for an instance of Snapshot Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
snapshot_type_name Snapshot Type Name The unique string identifier for an instance of Snapshot Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)