Tables [dbo].[Item_Annotation]
Item level Annotation
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Indexes NIX_Item_Annotation_ID, TWstat_Item_Annotation_AnnotatedForID_ID, TWstat_Item_Annotation_RecordedDTTM_ID(3)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to Item_Annotation table
Cluster Key CIX_ItemID_ItemType: ItemID\ItemTypeIndexes NIX_ItemIDItemID[dbo].[uniqueid]9NOT NULLParent Item ID - link depends on ItemType
ItemTextvarchar(max)maxNOT NULLAnnotation Text
Indexes TWstat_Item_Annotation_AnnotatedForID_IDAnnotatedForID[dbo].[uniqueid]9NOT NULLUser Annotation is for - Links to IDX_User.ID
Indexes TWstat_Item_Annotation_AnnotatedByIDForeign Keys FK_Item_Annotation_AnnotatedByID_IDX_User_ID: [dbo].[IDX_User].AnnotatedByIDAnnotatedByID[dbo].[uniqueid]9NOT NULLUser that created the Annotation - Links to IDX_User.ID
PerformedDTTMdatetime8NOT NULLDatetime Annotation is for
Indexes TWstat_Item_Annotation_RecordedDTTM_IDRecordedDTTMdatetime8NOT NULLDatetime Annotation was entered
Cluster Key CIX_ItemID_ItemType: ItemID\ItemTypeIndexes NIX_Item_Annotation_IDItemTypechar(2)2NOT NULL('NA')ItemType (EX. ME, IM, PL)