Skip to content

AnnotationCode

Lookup codes for annotations, can be used to provide a list of options for an annotation.

erDiagram
    Annotation ||--o{ AnnotationCode : "AnnotationID"
    AnnotationCode ||--o{ AnnotationCodeLocalizedDisplayName : "AnnotationCodeID"
    AnnotationCode ||--o{ AnnotationPropertyAnnotationCode : "AnnotationCodeID"

Fields

Field Type Description
AnnotationID numeric Internal ID that references the Annotation entity (Foreign Key)
DisplayName string English display name for the value
ID numeric Internal ID for the AnnotationCode entity (Primary Key)
Value string Annotation code value

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.

Referenced by

Table Column Name Description
AnnotationCodeLocalizedDisplayName AnnotationCodeID Localized names of annotation codes for different languages
AnnotationPropertyAnnotationCode AnnotationCodeID N:m relation for annotation properties that can have multiple values (multi-select)