Subject Area : 066 - Container Snapshot
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 066 - Container Snapshot Details.. Details..
ER Diagram(s) of Subject Area "066 - Container Snapshot"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "066 - Container Snapshot"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 22
. cfg_setting Configuration Setting false A configuration variable that can be identified in programming code and which has an atomic value that affects the behavior of the application. Configuration values are either scalars, or are supported by value lists that also can be programmatically identified. They have localized labels and value choices, and are categorized to support organization and separation in programming namespaces and configuration screens. They support the concept of Built-In Values, Default Values, and Customized Values. Configuration should be supported by an Audit Trail, and should be able to determine if configuration has changed by level, category, and for the individual value in order to support cacheing. A configuration value has a definition to identify its usage, and a enum that identifies if a change will require a restart and what level of restart is required if the value changes. If a restart is required, both the currently running value and the value after restart should be accessible. This means that historical values of the Configuration Settings should be accessible. Details..
. cfg_setting_val 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..
. cntnr Container true true The highest abstract level of Runtime Object. The Runtime object has a cooresponding definition that acts as a catalog of the Runtime Entity. There is a hierarchy or composition concept in the Runtime Entity, but it may not be necessary to actually have navigable properties. Details..
. cntnr_defn Container Definition true true The definition of a Container and the associated Configuration_Settings at the container level. This would include the collection of Item Definitions. The Container_Definition will have a Container Class identifier (Workspace, CMDB, Address Book) and may have specializations such as Workspace_Container_Definition. As much as possible, the Container Definition will suffice to describe any Container Type. There will be an association to a default Container Template, as well as more application specific Container Templates that can be chosen to initially populate the Container Template. There will also be Container Group Definition, and Container Group Templates. See the database views v_cntnr_defn, v_cntnr_defn_active. Details..
. cntnr_snapshot Container Snapshot false Details..
. defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. Details..
. defn_lock Definition Lock true true A pessimitic lock of a definition. The lock helps implement single session editing. It is intended to be used for container definitions, but may be used by other definitions as well. This is not a table it is implemented with configuration settings. Details..
. defn_reln 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..
. defn_reln_type Definition Relationship Type false The Definition Relationship Type entity depicts a set of relationships that a Definition instance in the system can have with another Definition instance(i.e. parent_child indicatesto a hierarchical relationship) . This specific relationship is further clarified when combined with the Definition Relationship Member Type entity. Details..
. defn_ver 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..
. defn_ver_association Definition Version Association false Details..
. defn_ver_status Definition Version Status false The attribute of the definition version entity that tells what state the definition instance is in. The word "Published" in this context means a change being commited or made ready for runtime. Currently the available status options are:
 
Draft Dirty - the entity instance is being created or changed, but has not yet been published, so is not yet valid for runtime.
 
Published Active - the entity instance has been published, and is available for runtime.
 
Published Outdated - the entity instance has been previously published, but has been replaced with a newer version of itself in runtime.
Details..
. dyn_table_script_history Dynamic Table Script History false Records the successful execution of the Dynamic Table Script for a Container and/or Dynamic Item. This is used to control re-execution of scripts when the script version changes, or when a new script is added. Details..
. field_defn Field Definition true true The definition of a Field, including persistence information and default UI information. Some fields will be defined as database fields, and other fields will be defined as calculated fields. The field will have data types and associations to business rule definitions. Some fields are built-in, some are defaults from templates, and some are custom fields. See the database view v_cntnr_item_field. 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..
. wksp_cntnr Workspace Container true true A workspace is the principle architectural structure in Numara FootPrints for storing and tracking information. A Workspace is a separate sub-database or work area within the system with its own fields, forms, options, workflow, settings and users. Most of the behaviour of the Workspace comes from the Container Abstract class, and only things that are specific to the Workspace are implemented here. For Example, Current FootPrints allows a single CMDB to be referenced from a Workspace, and a single Address book, yet these are listed as features for improvement. So convenience methods that get and set Container Group Relationship might be appropriate.

Details..
Attribute/Column(s) of Entity/Table "Configuration Setting"
# Physical Name Name Definition Physical Data Type
Total 12
. cfg_ctgy_id Configuration Category Id A Foreign Key to the Configuration Category table. bigint
. cfg_setting_const Configuration Setting Constant The constant name of the Configuration Setting Constant, which can be aligned with an enumeration or other compile time constant value for access in Java. varchar(255)
. dflt_setting_label Default Setting Label The name of the Configuration Setting. varchar(255)
. dflt_setting_descr Default Setting Description The description of the purpose and usage of the configuration setting. This description serves for documentation, and will be used to help develop UI strings for the Label, ToolTip, Helptext etc. of the UI for the configuration setting. varchar(255)
. cfg_setting_id Configuration Setting Id The automatically generated primary key of the cfg_setting table. bigint
. agent_only Agent Only Indicates if Agent Only. bit
. unique_user_only Unique User Only Indicates if Unique User Only. bit
. cfg_val_list_id Configuration Value List Id A Foreign Key to the Configuration Value List table. bigint
. val_type_cd Value Type Code The data type for a Configuration Setting. The choices are 'S' string, 'D' date, 'T' text, 'L' Long, 'R' real, and 'A' for any type. char(1)
. cfg_list_type_name Configuration List Type Name The unique string identifier for an instance of Configuration List 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)
. spec_class_name Specification Class Name The value of a Configuration Setting, stored as a string. varchar(255)
. cfg_is_val_mapped Configuration Is Value Mapped Indicates if Configuration Is Value Mapped. bit
Attribute/Column(s) of Entity/Table "Configuration Setting Value"
# Physical Name Name Definition Physical Data Type
Total 13
. cfg_setting_val_id Configuration Setting Value Id The automatically generated primary key of the cfg_setting_val table. bigint
. cfg_setting_id Configuration Setting Id A Foreign Key to the Configuration Setting table. bigint
. val_type_cd Value Type Code The data type for a Configuration Setting Value. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. char(1)
. string_val String Value The value of a Configuration Setting Value, stored as a string. nvarchar(4000)
. text_val Text Value The value of a Configuration Setting Value, stored as a long text object. nvarchar(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 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 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 Configuration Setting Owner 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)
Attribute/Column(s) of Entity/Table "Container"
# Physical Name Name Definition Physical Data Type
Total 4
. cntnr_name Container Name The name of the Container. varchar(255)
. cntnr_id Container Id The automatically generated primary key of the cntnr table. bigint
. tenant_parttn_id Tenant Partition Id A Foreign Key to the Tenant Partition table. bigint
. defn_id Definition Id A Foreign Key to the Definition table. bigint
Attribute/Column(s) of Entity/Table "Container Definition"
# Physical Name Name Definition Physical Data Type
Total 2
. db_schema_name Database Schema Name The name of the database schema. It is a database object name, limited to 30 characters in length. varchar(30)
. defn_id Definition Id A Foreign Key to the Definition table. bigint
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 "Definition"
# Physical Name Name Definition Physical Data Type
Total 7
. defn_id Definition Id The automatically generated primary key of the defn table. bigint
. defn_name Definition Name The name of the Definition. nvarchar(4000)
. dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
. defn_guid Definition GUID A Global Unique IDentifier search key for the 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 Definition 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)
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
Attribute/Column(s) of Entity/Table "Definition Lock"
# Physical Name Name Definition Physical Data Type
Total 4
. locked_by Locked By a string description suitable for display of a session user or component that owns a lock. varchar(255)
. create_date Create Date The date that the Definition Lock was created. datetime
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. token Token A Global Unique IDentifier search key for the System Session, composed of letters and numbers. The session table is not persisted to the database for performance and integrity reasons. Locks will be cleared by the application in normal use, and may be cleared if they are orphaned. varchar(255)
Attribute/Column(s) of Entity/Table "Definition Relationship"
# Physical Name Name Definition Physical Data Type
Total 4
. defn_reln_id Definition Relationship Id The automatically generated primary key of the defn_reln table. bigint
. from_defn_ver_id From Definition Version Id A Foreign Key to the Definition Version table. bigint
. to_defn_ver_id To Definition Version Id A Foreign Key to the Definition Version table. bigint
. defn_reln_type_id Definition Relationship Type Id A Foreign Key to the Definition Relationship Type table. int
Attribute/Column(s) of Entity/Table "Definition Relationship Type"
# Physical Name Name Definition Physical Data Type
Total 3
. defn_reln_type_name Definition Relationship Type Name The name of the Definition Relationship Type. varchar(255)
. defn_reln_type_id Definition Relationship Type Id The automatically generated primary key of the defn_reln_type table. int
. defn_reln_type_descr Definition Relationship Type Description A descriptive name of the Definition Relationship Type. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Definition Version"
# Physical Name Name Definition Physical Data Type
Total 5
. defn_id Definition Id A Foreign Key to the Definition table. bigint
. defn_ver_id Definition Version Id The automatically generated primary key of the defn_ver table. bigint
. defn_ver_name Definition Version Name The name of the Definition Version. nvarchar(4000)
. defn_ver_status_id Definition Version Status Id A Foreign Key to the Definition Version Status table. int
. defn_ver_guid 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)
Attribute/Column(s) of Entity/Table "Definition Version Association"
# Physical Name Name Definition Physical Data Type
Total 4
. defn_ver_association_id Definition Version Association Id The automatically generated primary key of the defn_ver_association table. bigint
. from_defn_ver_id From Definition Version ID A Foreign Key to the Definition Version table. bigint
. to_defn_ver_id To Definition Version ID A Foreign Key to the Definition Version table. bigint
. association_type_id Association Type Id A Foreign Key to the Association Type table. bigint
Attribute/Column(s) of Entity/Table "Definition Version Status"
# Physical Name Name Definition Physical Data Type
Total 2
. defn_ver_status_name Definition Version Status Name The name of the Definition Version Status. varchar(255)
. defn_ver_status_id Definition Version Status Id The automatically generated primary key of the defn_ver_status table. int
Attribute/Column(s) of Entity/Table "Dynamic Table Script History"
# Physical Name Name Definition Physical Data Type
Total 5
. dyn_table_script_id Dynamic Table Script Id A Foreign Key to the Dynamic Table Script table. bigint
. dyn_table_script_history_id Dynamic Table Script History Id The automatically generated primary key of the dyn_table_script_history table. bigint
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
. create_date Create Date The date that the Dynamic Table Script History was created. datetime
. cntnr_defn_id Container Definition Id A Foreign Key to the Definition table. bigint
Attribute/Column(s) of Entity/Table "Field Definition"
# Physical Name Name Definition Physical Data Type
Total 4
. field_dtype_id Field Datatype Id A Foreign Key to the Field Datatype table. bigint
. field_col_name Field Column Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
. field_descr Field Description Field Description. varchar(255)
. field_defn_id Field Definition Id A Foreign Key to the Definition table. bigint
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)
Attribute/Column(s) of Entity/Table "Workspace Container"
# Physical Name Name Definition Physical Data Type
Total 3
. time_zone_region_name Time Zone Region Name The name of the Time Zone Region. This is 2. The 'primary key' of the java timezone is the string region identifier in English, example 'America/Phoenix'. There is no numeric identifier. As the JRE is updated, or specific classes are updated, the list could change to include new entries, and the detail data behind the regions could change. varchar(255)
. cntnr_type_id Container Type Id A Foreign Key to the Container Type table. int
. cntnr_id Container Id A Foreign Key to the Container table. bigint