Footprints Data Model

Table
Name local_col_val
Comment (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.

Column
Name Datatype Comment Is PK Is FK
app_ele_id bigint A Foreign Key to the Application Element table. Yes Yes
local_col_id bigint A Foreign Key to the Application Element table. No Yes
initl_col_string_val varchar(255) The initial data string value in a column of a localized table. Ideally, this would be in sync with the English value. No No
prmry_key_id bigint The integer primary key value of the row in the named Table that is being localized. No No