Tables [dbo].[Result_Text]
Long textual results along with result item performing location comments.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Result_Text_ResultID: ResultIDCluster Key CIX_Result_Text_ResultID_ArchiveState: ResultID\ArchiveStateForeign Keys FK_Result_Text_ResultID: [dbo].[Result].ResultIDResultID[dbo].[uniqueid]9NOT NULLResult. Link to Result.ID
ResultTextvarchar(max)maxNULL allowedResult Text
ItemPerformingCommentvarchar(max)maxNULL allowedPerforming Location Comments
Cluster Key CIX_Result_Text_ResultID_ArchiveState: ResultID\ArchiveStateArchiveStatetinyint1NOT NULL((0))0 =  Record is in Main Partition
1 = Record is in Archived Partition