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