Tables [dbo].[Intervention_ActionTaken_Mapper]
Related Items for the Intervention on which the actions were taken
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key CIX_Intervention_ActionTaken_Mapper_InterventionID_InterventionTypeDE: InterventionID\InterventionTypeDEIndexes UQ_Intervention_ActionTaken_MapperForeign Keys FK_Intervention_ActionTaken_ID: [dbo].[Intervention_ActionTaken].InterventionIDInterventionID[dbo].[uniqueid]9NOT NULLIntervention. Link to Intervention_ActuionTaken.ID
Cluster Key CIX_Intervention_ActionTaken_Mapper_InterventionID_InterventionTypeDE: InterventionID\InterventionTypeDEIndexes UQ_Intervention_ActionTaken_Mapper, NIX_Intervention_ActionTaken_Mapper_InterventionTypeDE(2)Foreign Keys FK_Intervention_ActionTaken_Mapper_InterventionTypeDE: [dbo].[Intervention_Type_DE].InterventionTypeDEInterventionTypeDE[dbo].[dict_id]5NOT NULLType. Link to Intervention_Type_DE.ID
Indexes UQ_Intervention_ActionTaken_MapperMappedObjectID[dbo].[uniqueid]9NULL allowedID of associated item if it is numeric
Indexes UQ_Intervention_ActionTaken_MapperMappedObjectStringIDvarchar(200)200NULL allowedID of associated item if it is a string. Used for Recommendations
Indexes UQ_Intervention_ActionTaken_MapperItemTypevarchar(5)5NULL allowedClinical item type which is linked to Intervention action taken