Subject Area : Legend
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. Legend Details.. Details..
ER Diagram(s) of Subject Area "Legend"
# Name Physical Display Level
Total 1
. Legend Column
Entity/Table(s) of Subject Area "Legend"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 20
. added_col Added Column false Details..
. added_table Added Table false Details..
. 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_owner_type Configuration Setting Owner Type false A lookup table for Owner Types of Configuration Setting Values. Values include: APPLICATION_USER, DEFINITION, IMPORTS, ROLE, SIMPLE_CONFIGURABLE_OBJECT, USER_PROFILE. Details..
. delete_entry Delete Entry false Details..
. deleted_col Deleted Column false Details..
. deleted_table Deleted Table false Details..
. item_defn Item Definition true true The definition of an Item, which includes the Item Name and localizations and the collection of Item Fields. It also includes customizations and localizations of string resources for Item Names, and Item Field names. Details..
. subtype Subtype false Details..
. subtype Subtype false Details..
. subtype Subtype false Details..
. supertype Supertype false Details..
. to To false Details..
. to To false Details..
. to To false Details..
. to To false Details..
. to_one_entity To One Entity false Details..
. to_one_or_more_entities To One or More Entities false Details..
. to_zero_or_more_entities To Zero or More Entities false Details..
. to_zero_or_one_entity To Zero or One Entity false Details..
Attribute/Column(s) of Entity/Table "Added Column"
# Physical Name Name Definition Physical Data Type
Total 3
. added_col_name Added Column Name The name of the Added Column. varchar(255)
. added_col_descr Added Column Description A descriptive name of the Added Column. This descriptive name may be localized. varchar(512)
. added_col_id Added Column Id The automatically generated primary key of the added_col table. bigint
Attribute/Column(s) of Entity/Table "Added Table"
# Physical Name Name Definition Physical Data Type
Total 3
. added_col_name Added Column Name The name of the Added Table. varchar(255)
. added_col_descr Added Column Description A descriptive name of the Added Table. This descriptive name may be localized. varchar(512)
. added_table_id Added Table Id The automatically generated primary key of the added_table table. bigint
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 Owner Type"
# Physical Name Name Definition Physical Data Type
Total 2
. cfg_setting_owner_type_descr Configuration Setting Owner Type Description A descriptive name of the Configuration Setting Owner Type. This descriptive name may be localized. varchar(512)
. 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 "Delete Entry"
# Physical Name Name Definition Physical Data Type
Total 3
. delete_entry_number_inherited Delete Entry Number Inherited The automatically generated primary key of the delete_entry table. int
. delete_entry_name Delete Entry Name The name of the Delete Entry. varchar(255)
. delete_entry_comment Delete Entry Comment A free-form text comment describing the Delete Entry. varchar(255)
Attribute/Column(s) of Entity/Table "Deleted Column"
# Physical Name Name Definition Physical Data Type
Total 3
. deleted_col_id Deleted Column Id The automatically generated primary key of the deleted_col table. bigint
. deleted_col_name Deleted Column Name The name of the Deleted Column. varchar(255)
. deleted_col_descr Deleted Column Description A descriptive name of the Deleted Column. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Deleted Table"
# Physical Name Name Definition Physical Data Type
Total 3
. deleted_table_id Deleted Table Id The automatically generated primary key of the deleted_table table. bigint
. deleted_table_name Deleted Table Name The name of the Deleted Table. varchar(255)
. deleted_table_descr Deleted Table Description A descriptive name of the Deleted Table. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Item Definition"
# Physical Name Name Definition Physical Data Type
Total 2
. item_table_name Item Table Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
Attribute/Column(s) of Entity/Table "To"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id The automatically generated primary key of the to table. bigint
Attribute/Column(s) of Entity/Table "To"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id The automatically generated primary key of the to table. bigint
Attribute/Column(s) of Entity/Table "To"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id The automatically generated primary key of the to table. bigint
Attribute/Column(s) of Entity/Table "To"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id The automatically generated primary key of the to table. bigint
Attribute/Column(s) of Entity/Table "To One Entity"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id A Foreign Key to the To table. bigint
Attribute/Column(s) of Entity/Table "To One or More Entities"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id A Foreign Key to the To table. bigint
Attribute/Column(s) of Entity/Table "To Zero or More Entities"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id A Foreign Key to the To table. bigint
Attribute/Column(s) of Entity/Table "To Zero or One Entity"
# Physical Name Name Definition Physical Data Type
Total 1
. to_id To Id A Foreign Key to the To table. bigint