Footprints Data Model

Table
Table Name Localized Column
Table Definition (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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Application Element Id A Foreign Key to the Application Element table. LONG Yes
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) Yes
Table Name The name of the Localized Table. VARCHAR(30) Yes
Column Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. VARCHAR(30) Yes