Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to Annotate_Problem Table |
 ![Foreign Keys FK_Annotate_Problem_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderID Foreign Keys FK_Annotate_Problem_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderID](../../../../Images/fk.png) | ProblemHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Problem. Link to Problem_Header.ID |
| ProblemText | varchar(max) | max | NOT NULL | | | Annotated Text |
 | AnnotateForID | [dbo].[uniqueid] | 9 | NOT NULL | | | ID of the Persom for whom the Annotation entered. Link to Person.ID |
 ![Foreign Keys FK_Annotate_Problem_AnnotateByID_IDX_User_ID: [dbo].[IDX_User].AnnotateByID Foreign Keys FK_Annotate_Problem_AnnotateByID_IDX_User_ID: [dbo].[IDX_User].AnnotateByID](../../../../Images/fk.png) | AnnotateByID | [dbo].[uniqueid] | 9 | NOT NULL | | | User who entered the annotation. Link to IDX_User.ID |
 | PerformedDTTM | datetime | 8 | NOT NULL | | | Date and time when the Annotation performed |
 | RecordedDTTM | datetime | 8 | NOT NULL | | | Date and time when the Annotation Recorded |
  | ItemType | char(2) | 2 | NOT NULL | | ('PR') | This column contains the type of Item annotated. PR - Problem |