Subject Area : 901 - Tables Added
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 901 - Tables Added Tables added since the last release. Details.. Details..
ER Diagram(s) of Subject Area "901 - Tables Added"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "901 - Tables Added"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 8
. cntnr_snapshot Container Snapshot false Details..
. 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. Details..
. snapshot_defn Snapshot Definition false Details..
. 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. Details..
. 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. Details..
. snapshot_defn_ver_assoc Snapshot Definition Version Assoc false Details..
. snapshot_status Snapshot Status false Details..
. snapshot_type Snapshot Type false Details..
Attribute/Column(s) of Entity/Table "Container Snapshot"
# Physical Name Name Definition Physical Data Type
Total 5
. 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
Attribute/Column(s) of Entity/Table "Snapshot Configuration Setting Value"
# Physical Name Name Definition Physical Data Type
Total 14
. 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
Attribute/Column(s) of Entity/Table "Snapshot Definition"
# Physical Name Name Definition Physical Data Type
Total 8
. 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)
Attribute/Column(s) of Entity/Table "Snapshot Definition Relationship"
# Physical Name Name Definition Physical Data Type
Total 5
. 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
Attribute/Column(s) of Entity/Table "Snapshot Definition Version"
# Physical Name Name Definition Physical Data Type
Total 6
. 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
Attribute/Column(s) of Entity/Table "Snapshot Definition Version Assoc"
# Physical Name Name Definition Physical Data Type
Total 5
. 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
Attribute/Column(s) of Entity/Table "Snapshot Status"
# Physical Name Name Definition Physical Data Type
Total 2
. 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)
Attribute/Column(s) of Entity/Table "Snapshot Type"
# Physical Name Name Definition Physical Data Type
Total 2
. 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)