AnnotationLabel
Language specific labels and other text resources per annotation.
erDiagram
Annotation ||--o{ AnnotationLabel : "AnnotationID"
Language ||--o{ AnnotationLabel : "LanguageID"
Fields
| Field |
Type |
Description |
| AnnotationID |
numeric |
Internal ID that references the Annotation entity (Foreign Key) |
| ID |
numeric |
Internal ID for the AnnotationLabel entity (Primary Key) |
| LanguageID |
numeric |
Internal ID that references the Language entity (Foreign Key) |
| Text |
string |
Text of the label. Depending on the usage, the text can contain HTML formatting. |
| Type |
string |
Type of Label. 'L' for labels, 'T' for tooltips. |
References
| Column Name |
Referenced Table |
Description |
| AnnotationID |
Annotation |
Annotations can be used to store user-defined attributes of a source system with any OctoSAM entity. Not to be used to store system defined attributes of source systems (extend the schema to hold such attributes). Annotations are not used for internal data logic within OctoSAM, but can be referenced in custom queries and reports. |
| LanguageID |
Language |
Lookup table for languages |