The whole Terminology Server uses several code lists for internal use. These codes could be saved as a Terminology, but we decided to swap them to a simple structure. They are saved in the tables domain and domain_value.

Table domain contains a list of available code lists. domain_value saves the values for each domain.

The Terminology Server uses these domains, for example:

• ISO 639-1 language codes
• Import formats
• Export formats
• Codesystem taxonomy (displayed in Term Browser)

Inhaltsverzeichnis 1 Tables 1.1 domain 1.1.1 name 1.1.2 displayText 1.1.3 domainOid 1.1.4 description 1.1.5 domainType 1.1.6 defaultValue (FK) 1.1.7 displayOrder (FK) 1.2 domain_value 1.2.1 domainId 1.2.2 domainCode 1.2.3 domainDisplay 1.2.4 attribut1Value 1.2.5 attribut1Classname 1.2.6 orderNo 1.2.7 image_file 1.3 domainvalue2domainvalue

Tables

domain

Saves information about a domain and its metadata.

name

Name of the domain.

displayText

Display text, how the domain should be displayed on the UI.

domainOid

OID (global unique ID) for the domain, if exists.

description

Description of the domain.

domainType

Not used yet

defaultValue (FK)

(virtual foreign key) The default value for this domain. A value from domain_value.domainCode

displayOrder (FK)

(foreign key) Value, how to order the domain values. The possible values comes from a domain, too. Possible values are:

• ID
• Name
• Order-Number

domain_value

Saves all values for a domain.

domainId

Foreign key to table domain.

domainCode

Code for this value (unique in a domain).

domainDisplay

Display text.

attribut1Value

Not used yet.

attribut1Classname

Not used yet.

orderNo

Priority to sort values. Only used if displayOrder from domain is set to "order number".

image_file

Possible icon for a value. Not used yet.

domainvalue2domainvalue

A relationship between 2 domain values. This represents a hierarchical relation where domainValueId1 is parent of domainValueId2.