Tables [dbo].[Intervention_Feedback_Mapper]
Items linked to Decision Support Intervention (DSI) Feedback
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Indexes UQ_Intervention_Feedback_MapperForeign Keys FK_Intervention_Feedback_ID: [dbo].[Intervention_Feedback].InterventionIDInterventionID[dbo].[uniqueid]9NOT NULLIntervention. Link to Intervention_Feedback.ID
Indexes UQ_Intervention_Feedback_Mapper, NIX_Intervention_Feedback_Mapper_InterventionTypeDE(2)Foreign Keys FK_Intervention_Feedback_Mapper_InterventionTypeDE: [dbo].[Intervention_Type_DE].InterventionTypeDEInterventionTypeDE[dbo].[dict_id]5NOT NULLType. Link to Intervention_Type_DE.ID
Cluster Key CIX_Intervention_Feedback_Mapper: MappedObjectID\MappedObjectStringIDIndexes UQ_Intervention_Feedback_MapperMappedObjectID[dbo].[uniqueid]9NULL allowedID of associated item if it is numeric
Cluster Key CIX_Intervention_Feedback_Mapper: MappedObjectID\MappedObjectStringIDIndexes UQ_Intervention_Feedback_MapperMappedObjectStringIDvarchar(40)40NULL allowedID of associated item if it is a string. Used for Recommendations