Tables [dbo].[Annotate_Problem]
Problem annotations
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Indexes TWstat_Annotate_Problem_IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to Annotate_Problem Table
Cluster Key CIX_ProbHdrID_ItemType: ProblemHeaderID\ItemTypeForeign Keys FK_Annotate_Problem_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderIDProblemHeaderID[dbo].[uniqueid]9NOT NULLProblem. Link to Problem_Header.ID
ProblemTextvarchar(max)maxNOT NULLAnnotated Text
Indexes TWstat_Annotate_Problem_AnnotateForIDAnnotateForID[dbo].[uniqueid]9NOT NULLID of the Persom for whom the Annotation entered. Link to Person.ID
Indexes TWstat_Annotate_Problem_AnnotateByIDForeign Keys FK_Annotate_Problem_AnnotateByID_IDX_User_ID: [dbo].[IDX_User].AnnotateByIDAnnotateByID[dbo].[uniqueid]9NOT NULLUser who entered the annotation. Link to IDX_User.ID
Indexes TWstat_Annotate_Problem_PerformedDTTMPerformedDTTMdatetime8NOT NULLDate and time when the Annotation performed
Indexes TWstat_Annotate_Problem_RecordedDTTMRecordedDTTMdatetime8NOT NULLDate and time when the Annotation Recorded
Cluster Key CIX_ProbHdrID_ItemType: ProblemHeaderID\ItemTypeIndexes TWstat_Annotate_Problem_ItemTypeItemTypechar(2)2NOT NULL('PR')This column contains the type of Item annotated. PR - Problem