AnnotationPropertyAnnotationCode
N:m relation for annotation properties that can have multiple values (multi-select).
erDiagram
AnnotationCode ||--o{ AnnotationPropertyAnnotationCode : "AnnotationCodeID"
AnnotationProperty ||--o{ AnnotationPropertyAnnotationCode : "AnnotationPropertyID"
Fields
| Field |
Type |
Description |
| AnnotationCodeID |
numeric |
Internal ID that references the AnnotationCode entity (Foreign Key) |
| AnnotationPropertyID |
numeric |
Internal ID that references the AnnotationProperty entity (Foreign Key) |
| ID |
numeric |
Internal ID for the AnnotationPropertyAnnotationCode entity (Primary Key) |
References
| Column Name |
Referenced Table |
Description |
| AnnotationCodeID |
AnnotationCode |
Lookup codes for annotations, can be used to provide a list of options for an annotation |
| AnnotationPropertyID |
AnnotationProperty |
Keeps per instance storage of annotation |