AnnotationProperty¶
Keeps per instance storage of annotation.
Fields¶
| Field | Type | Description |
|---|---|---|
| AnnotatedObjectID | bigint | ID of the original item the annotation extends |
| AnnotationID | bigint | Internal ID that references the Annotation entity (Foreign Key) |
| BooleanValue | bit | Boolean representation of the value for boolean data |
| Created | datetime2 | Date/Time this property was created |
| CreatedGUID | uniqueidentifier | GUID of the scan file that created this property |
| CurrencyID | bigint | Internal ID that references the Currency entity (Foreign Key) |
| DateTimeValue | datetime2 | |
| DecimalValue | decimal | Decimal representation of the value for numeric data |
| ID | bigint | Internal ID for the AnnotationProperty entity (Primary Key) |
| LastModification | datetime2 | Date/Time this property was last modified (typically this is the import time) |
| LastModifiedBy | nvarchar | User that last modified this property for properties that are maintained through UI interaction (Extended Attributes) |
| LastScan | datetime2 | Date/Time this property was last scanned |
| LastScanGUID | uniqueidentifier | GUID of the last scan file |
| Value | nvarchar | Value in string representation. Must be given for all value types |