AnnotationProperty
Keeps per instance storage of annotation.
erDiagram
Annotation ||--o{ AnnotationProperty : "AnnotationID"
Currency ||--o{ AnnotationProperty : "CurrencyID"
AnnotationProperty ||--o{ AnnotationPropertyAnnotationCode : "AnnotationPropertyID"
Fields
| Field |
Type |
Description |
| AnnotatedObjectID |
numeric |
ID of the original item the annotation extends |
| AnnotationID |
numeric |
Internal ID that references the Annotation entity (Foreign Key) |
| BooleanValue |
boolean |
Boolean representation of the value for boolean data |
| Created |
datetime |
Date/Time this property was created |
| CreatedGUID |
guid |
GUID of the scan file that created this property |
| CurrencyID |
numeric |
Internal ID that references the Currency entity (Foreign Key) |
| DateTimeValue |
datetime |
Date/Time representation of the value for date/time data. This is only set if there is a valid Date/Time value in the Value column. |
| DecimalValue |
decimal |
Decimal representation of the value for numeric data |
| ID |
numeric |
Internal ID for the AnnotationProperty entity (Primary Key) |
| LastModification |
datetime |
Date/Time this property was last modified (typically this is the import time) |
| LastModifiedBy |
string |
User that last modified this property for properties that are maintained through UI interaction (Extended Attributes) |
| LastScan |
datetime |
Date/Time this property was last scanned |
| LastScanGUID |
guid |
GUID of the last scan file |
| Value |
string |
Value in string representation. Must be given for all value types. |
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. |
| CurrencyID |
Currency |
Lookup table for currencies |
Referenced by
| Table |
Column Name |
Description |
| AnnotationPropertyAnnotationCode |
AnnotationPropertyID |
N:m relation for annotation properties that can have multiple values (multi-select) |