Dictionary entries

nevisIDM currently supports four languages and to bring this language support event to property names, unit display, hierarchical and abbreviation names, etc., dictionary entries exist. Dictionary entries are always connected to other entities by foreign keys on those entities to TIDMA_DICT_ENTRY.

Database table TIDMA_DICT_ENTRY

DB attribute	Java data type (max. size), defaults	Description
dict_entry_id	Long, not NULL	Primary key (uniquely identifies each individual DB entry)
name	String(100), nullable	Optional name, which can be used to give a hint about the purpose of the Dictionary Entry, e.g., "displayname for unit xy".

Database table TIDMA_DICT_ENTRY_VALUE

DB attribute	Java data type (max. size), defaults	Description
dict_entry_id	Long, not NULL	The dictionary entry the value belongs to. Foreign key that links to information in the table TIDMA_DICT_ENTRY.
dict_entry_value_id	Long, not NULL	Primary key (uniquely identifies each individual DB entry)
language_id	Long, not NULL	The language_id of the translation.
value	String(4000), not NULL	The translation of the dictionary entry in the above language.