Footprints Data Model

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

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Application Element Id A Foreign Key to the Application Element table. LONG Yes
Localized Column Id A Foreign Key to the Application Element table. LONG Yes
Primary Key Id The integer primary key value of the row in the named Table that is being localized. LONG No
Initial Column String Value Initial Column String Value. VARCHAR(255) No