Subject Area : 900 To Be Deleted
Subject Area Name Definition
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.
ER Diagram Name Physical Display Level
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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
vt$item_fld_defn_networkadapte vt$item_fld_defn_NetworkAdapter false
Physical Name Attribute/Column Name Definition Physical Data Type
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
vt$item_fld_networkadapter$chg vt$item_fld_NetworkAdapter$changes false
Physical Name Attribute/Column Name Definition Physical Data Type
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)