Subject Area : 900 To Be Deleted
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 900 To Be Deleted A list of tables that can be deleted because they are not used. Others are referenced in Java code that must be removed before table deletion. Details.. Details..
ER Diagram(s) of Subject Area "900 To Be Deleted"
# Name Physical Display Level
Total 1
. Physical Column
Entity/Table(s) of Subject Area "900 To Be Deleted"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 7
. cal_ticket_privilege Calendar Ticket Privilege false (Not used, but referenced in Java code that must be removed before table deletion.) A permission granted via a calendar ticket. May not be used in the FootPrints integration of calendaring code. Details..
. local_col Localized Column false (Not used, but referenced in Java code that must be removed before table deletion.) (Not currently used. Data localization is implemented in Configuration Setting Value. May be retired in the future). A Database Column name used in the Transparent Database Localization pattern. The data in the column is the original data for which a translated value can exist. In the case of English, this is a little strange because the English translation can be different than the original data. Details..
. local_col_val Localized Column Value false (Not used, but referenced in Java code that must be removed before table deletion.) (Not currently used. Data localization is implemented in Configuration Setting Value. May be retired in the future). A data value from a column and row in a Localized table. The initial english value is obtained from the table, but may be modified for visual display purposes. The Primary Key identifier of the source table is used along with the table name to establish the row identity. Details..
. role_grp Role Group false (Not used, but referenced in Java code that must be removed before table deletion.) The role group will contain the roles that the user has for each of the workspaces that the user has access. The user will always have a role group even if the administrator chooses the Perl Footprints functionality. Details..
. role_grp_role Role Group Role false (Not used, but referenced in Java code that must be removed before table deletion.) an association table that resolves the many to many relationship between the Role Group and the Role entities. Details..
. vt$item_fld_defn_networkadapte vt$item_fld_defn_NetworkAdapter false Details..
. vt$item_fld_networkadapter$chg vt$item_fld_NetworkAdapter$changes false Details..
Attribute/Column(s) of Entity/Table "Calendar Ticket Privilege"
# Physical Name Name Definition Physical Data Type
Total 2
. cal_ticket_id Calendar Ticket Id A Foreign Key to the Calendar Ticket table. bigint
. privilege Privilege The value of a Calendar Ticket Privilege, stored as a string. varchar(255)
Attribute/Column(s) of Entity/Table "Localized Column"
# Physical Name Name Definition Physical Data Type
Total 4
. app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
. schema_name Schema Name The name of the Schema containing the Localized table. In Internal systems and in Definition level systems, this will be the logical name "FP", " FP Workspace", but in the Runtime system, this will be "FP 01" , "FP 01 Workspace 001" for example. varchar(30)
. table_name Table Name The name of the Localized Table. varchar(30)
. col_name Column Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
Attribute/Column(s) of Entity/Table "Localized Column Value"
# Physical Name Name Definition Physical Data Type
Total 4
. app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
. local_col_id Localized Column Id A Foreign Key to the Application Element table. bigint
. initl_col_string_val Initial Column String Value Initial Column String Value. varchar(255)
. prmry_key_id Primary Key Id The integer primary key value of the row in the named Table that is being localized. bigint
Attribute/Column(s) of Entity/Table "Role Group"
# Physical Name Name Definition Physical Data Type
Total 3
. role_grp_id Role Group Id The automatically generated primary key of the role_grp table. bigint
. role_grp_name Role Group Name The name of the Role Group. varchar(255)
. role_grp_descr Role Group Description A descriptive name of the Role Group. This descriptive name may be localized. varchar(512)
Attribute/Column(s) of Entity/Table "Role Group Role"
# Physical Name Name Definition Physical Data Type
Total 3
. app_role_id Application Role Id A Foreign Key to the Application Role table. bigint
. role_grp_role_id Role Group Role Id The automatically generated primary key of the role_grp_role table. bigint
. role_grp_id Role Group Id A Foreign Key to the Role Group table. bigint
Attribute/Column(s) of Entity/Table "vt$item_fld_defn_NetworkAdapter"
# Physical Name Name Definition Physical Data Type
Total 5
. field_extlname_en_us field_externalName_en_US field_externalName_en_US. varchar(255)
. fieldrole fieldRole fieldRole. varchar(255)
. fieldlogicaldtype fieldLogicalDataType fieldLogicalDataType. varchar(255)
. fld_defn_id fld_defn_id bigint
. fld_defn_ver_id fld_defn_ver_id bigint
Attribute/Column(s) of Entity/Table "vt$item_fld_NetworkAdapter$changes"
# Physical Name Name Definition Physical Data Type
Total 17
. field_extlname_en_us field_externalName_en_US field_externalName_en_US. varchar(255)
. fieldrole fieldRole fieldRole. varchar(255)
. fieldlogicaldtype fieldLogicalDataType fieldLogicalDataType. varchar(255)
. fld_defn_id fld_defn_id bigint
. fld_defn_ver_id fld_defn_ver_id bigint
. draft_fld_defn_ver_id draft_fld_defn_ver_id bigint
. active_cfg_setting_val_id active_cfg_setting_val_id bigint
. active_string_val active_string_val active_string_val. varchar(255)
. draft_cfg_setting_val_id draft_cfg_setting_val_id bigint
. draft_string_val draft_string_val draft_string_val. varchar(255)
. dyn_col_spec_id dyn_col_spec_id bigint
. logical_data_type_id logical_data_type_id int
. logical_data_type_name logical_data_type_name logical_data_type_name. varchar(255)
. text_logical_data_type_id TEXT_logical_data_type_id int
. schema_name schema_name schema_name. varchar(30)
. table_name table_name table_name. varchar(30)
. col_name col_name col_name. varchar(255)