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
|