Domain/DomainValue - Concept
(Die Seite wurde neu angelegt: „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 struct…“) |
|||
| Zeile 8: | Zeile 8: | ||
*Export formats | *Export formats | ||
*Codesystem taxonomy (displayed in Term Browser) | *Codesystem taxonomy (displayed in Term Browser) | ||
| + | =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== | ||
Version vom 26. Mai 2014, 06:45 Uhr
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 |
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
