Subject Area : 010 - Translation
Subject Area Name Definition
010 - Translation This model provides for translation of all strings necessary in FootPrints Java. Much of FootPrints is customizable, and much of that customization can been used internally in the form of application strings, delivered Data Templates, and customer data entry. The process of defining the need for a string and obtaining the string and not losing association with the string is important. This model uses the idea of namespaces and identifiers to uniquely identify strings. Much of the UI code uses the actual English string as the unique identifier.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
app_ele Application Element false The identity and name of an element in the application implementation. An element can be one of many types, and can contain other elements. Example Application Elements include: a screen, a form, a dialog box, a text box, the Home Page, an Architecture Component, the Item Status field, the system values of the Item Status field. The Application Element is not the full implementation of the element, but is a key and nametag for the element. In many cases, a well-known algorithm can be used to locate the correct Application Element from the Application Element implementation. In other cases, an association to the Application Element Id must be recorded as part of the implementation.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_id Application Element Id The automatically generated primary key of the app_ele table. bigint
app_ele_name Application Element Name The name of the Application Element. VARCHAR(2000)
intrnl_id Internal Id An alternate automatically generated key of the app_ele table. int
is_intrnl_flag Is Internal Flag A boolean flag for indicating if the Application Element is defined internally by Engineering or by Partners or is defined by the customer. bit
app_ele_type_id Application Element Type Id A Foreign Key to the Application Element Type table. int
intrnl_id_type_id Internal Identifier Type Id A Foreign Key to the Internal Identifier Type table. int
app_ele_nmsp_id Application Element Namespace Id A Foreign Key to the Application Element Namespace table. bigint
app_ele_nmsp Application Element Namespace false A string that best describes the namespace of the Element Name. For example "FootPrints.UserInterface.Item.MaintenanceForm". These are maintained in a picklist so that consistency can be managed. There may be a hierarchy in the name, but the components of the hierarchy will not be enforced or maintained.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_nmsp_id Application Element Namespace Id The automatically generated primary key of the application_element_namespace table. bigint
app_ele_nmsp_name Application Element Namespace Name The name of the Application Element Namespace. varchar(255)
app_ele_string Application Element String false A string resource that is needed in English and other translations. The string is associated with an Application Element and a Usage, for example the Label , the Tooltip, etc.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_string_id Application Element String Id The automatically generated primary key of the app_ele_string table. bigint
app_ele_id Application Element Id A Foreign Key to the Application Element table. bigint
string_usage_type_id String Usage Type Id A Foreign Key to the String Usage Type table. int
part_of_speech_id Part Of Speech Id The unique identifier for an instance of Part Of Speech. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. int
needs_mlple_plural_forms_flag Needs Multiple Plural Forms Flag A boolean flag that indicates that one string per plural form must be specified. An example is "{N} Records Found. numeric(1)
app_ele_string_usage Application Element String Usage false The collection of String Usage types that are valid for use with an Application Element type. This is used for Internal systems to validate entry and control the edit interface.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_type_id Application Element Type Id A Foreign Key to the Application Element Type table. int
string_usage_type_id String Usage Type Id A Foreign Key to the String Usage Type table. int
app_ele_type Application Element Type false The class subtype indicator for Application Element, used in an inheritance pattern. Types include UI Element, Error Code, Localized Column, etc. There may need to be further subtypes, for example of UI Element. The subtypes will share common Finder methods and key construction methods and metadata for identification.
Physical Name Attribute/Column Name Definition Physical Data Type
app_ele_type_name Application Element Type Name The name of the Application Element Type. varchar(255)
app_ele_type_id Application Element Type Id The automatically generated primary key of the app_ele_type table. int
intrnl_id_type Internal Identifier Type false There are identifiers that are created by Numara Software that are used internally to uniquely identify elements. These are serial ids that will never change. There are also types of serial ids that may be used for configuration data, picklist data, etc. This Type provides a different domain of values for those keys. There may also be different domains of values provided by our partners or Professional Services. Primarily, Engineering will provide internal ids.
Physical Name Attribute/Column Name Definition Physical Data Type
intrnl_id_type_id Internal Identifier Type Id The automatically generated primary key of the intrnl_id_type table. int
intrnl_id_type_descr Internal Identifier Type Description A descriptive name of the Internal Identifier Type. This descriptive name may be localized. varchar(512)
locale Locale false A language and locale used to identify a specific dialect. It is used to determine variable forms of words, idioms, numeric format, date format, images, colors, etc. "en-US" for example is United States English, "es-LA" for Latin American Spanish.
Physical Name Attribute/Column Name Definition Physical Data Type
locale_cd Locale Code A well-known string identifier used as a code to identify the Locale. varchar(255)
locale_name Locale Name The name of the Locale. varchar(255)
locale_id Locale Id The automatically generated primary key of the locale table. bigint
is_sys_flag Is System Flag Indicates if Is System Flag. bit
string_rsrc_val String Resource Value false The translated value of the resource.
Physical Name Attribute/Column Name Definition Physical Data Type
string_rsrc_val_id String Resource Value Id The automatically generated primary key of the string_rsrc_val table. bigint
string_val String Value The default value for the string, which can be overriden by user customization. nchar(2000)
app_ele_string_id Application Element String Id A Foreign Key to the Application Element String table. bigint
cxt_phrase Context Phrase A free-form text field in the source language (usually english) which describes the context and has any additional guidance specific to the associated locale. varchar(255)
prod_rlse_id Product Release Id A Foreign Key to the Product Release table. bigint
locale_id Locale Id A Foreign Key to the Locale table. bigint
string_usage_type String Usage Type false The Usage Type of a String Resource by an an Application Element , for example Label, ToolTip, Accessibility, Help Text, Data Display Value, etc. The types may be appropriate by Application Element Type.
Physical Name Attribute/Column Name Definition Physical Data Type
string_usage_type_name String Usage Type Name The name of the String Usage Type. varchar(255)
string_usage_type_id String Usage Type Id The automatically generated primary key of the string_usage_type table. int