Subject Area Name
|
Definition
|
Legend
|
|
|
ER Diagram Name
|
Physical Display Level
|
|
Legend
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
added_col
|
Added Column
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|
|
added_table
|
Added Table
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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)
|
|
delete_entry
|
Delete Entry
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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)
|
|
deleted_col
|
Deleted Column
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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)
|
|
deleted_table
|
Deleted Table
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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)
|
|
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.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
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
|
|
subtype
|
Subtype
|
|
false
|
|
|
subtype
|
Subtype
|
|
false
|
|
|
subtype
|
Subtype
|
|
false
|
|
|
supertype
|
Supertype
|
|
false
|
|
|
to
|
To
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
The automatically generated primary key of the to table.
|
bigint
|
|
to
|
To
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
The automatically generated primary key of the to table.
|
bigint
|
|
to
|
To
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
The automatically generated primary key of the to table.
|
bigint
|
|
to
|
To
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
The automatically generated primary key of the to table.
|
bigint
|
|
to_one_entity
|
To One Entity
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
A Foreign Key to the To table.
|
bigint
|
|
to_one_or_more_entities
|
To One or More Entities
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
A Foreign Key to the To table.
|
bigint
|
|
to_zero_or_more_entities
|
To Zero or More Entities
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
A Foreign Key to the To table.
|
bigint
|
|
to_zero_or_one_entity
|
To Zero or One Entity
|
|
false
|
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
to_id
|
To Id
|
A Foreign Key to the To table.
|
bigint
|