Tables [dbo].[Order_Result_Review]
This table holds the reviewed status of the Order / Result. When an edit happens the Status is set to U
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key CIX_Order_Result_Review: PlanItemID\UserIDForeign Keys FK_Order_Result_Review_PlanItemID_Plan_Item_ID: [dbo].[Plan_Item].PlanItemIDPlanItemID[dbo].[uniqueid]9NOT NULLOrder. Link to Plan_Item.ID
Cluster Key CIX_Order_Result_Review: PlanItemID\UserIDIndexes TWstat_Order_Result_Review_UserIDUserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
Indexes TWstat_Order_Result_Review_StatusStatuschar(1)1NOT NULLStatus Code R - Reviewed, U - Unreviewed
ReviewedDTTMdatetime8NULL allowedDate Reviewed / Edited
Check Constraints CK_Order_Result_Review_RoutingListFLAG_Yes_Or_No : ([RoutingListFLAG]='N' OR [RoutingListFLAG]='Y')RoutingListFLAG[dbo].[BOOL]1NOT NULL('N')Flag for a Routing List (Y/N) associated to the Order
Check Constraints CK_Order_Result_Review_CCListFLAG_Yes_Or_No : ([CCListFLAG]='N' OR [CCListFLAG]='Y')CCListFLAG[dbo].[BOOL]1NOT NULL('N')Flag for a CC List (Y/N) associated to the Order