Subject Area : 066 - Container Snapshot |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 066 - Container Snapshot | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | 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.. |
# | 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 |
# | 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) |
# | 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 |
# | 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 |
# | 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 |
# | 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) |
# | 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) |
# | 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 |
# | 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) |
# | 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) |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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) |
# | 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 |
# | 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 |
# | 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 |
# | 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) |
# | 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) |
# | 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 |