Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
(3) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to Item_Annotation table |
  | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | | Parent Item ID - link depends on ItemType |
| ItemText | varchar(max) | max | NOT NULL | | | Annotation Text |
 | AnnotatedForID | [dbo].[uniqueid] | 9 | NOT NULL | | | User Annotation is for - Links to IDX_User.ID |
 ![Foreign Keys FK_Item_Annotation_AnnotatedByID_IDX_User_ID: [dbo].[IDX_User].AnnotatedByID Foreign Keys FK_Item_Annotation_AnnotatedByID_IDX_User_ID: [dbo].[IDX_User].AnnotatedByID](../../../../Images/fk.png) | AnnotatedByID | [dbo].[uniqueid] | 9 | NOT NULL | | | User that created the Annotation - Links to IDX_User.ID |
| PerformedDTTM | datetime | 8 | NOT NULL | | | Datetime Annotation is for |
 | RecordedDTTM | datetime | 8 | NOT NULL | | | Datetime Annotation was entered |
  | ItemType | char(2) | 2 | NOT NULL | | ('NA') | ItemType (EX. ME, IM, PL) |