Touchworks 25.3
[dbo].[Annotate_Problem]
Problem annotations
| 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](../../../../Images/fk.png "Foreign Keys FK_Annotate_Problem_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderID") | 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 | |||
| 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 |