Tables [dbo].[Intervention_Feedback]
Decision Support Intervention (DSI) Feedback
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Intervention_Feedback: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Intervention_Feedback table
Indexes NIX_Intervention_Feedback_InterventionTypeDEForeign Keys FK_Intervention_Feedback_InterventionTypeDE: [dbo].[Intervention_Type_DE].InterventionTypeDEInterventionTypeDE[dbo].[dict_id]5NOT NULLType. Link to Intervention_Type_DE.ID
Interventionvarchar(1000)1000NOT NULLIntervention text
Feedbackvarchar(1000)1000NOT NULLFeedback text
Indexes NIX_Intervention_Feedback_UserIDForeign Keys FK_Intervention_Feedback_UserID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
Indexes NIX_Intervention_Feedback_SiteDEForeign Keys FK_Intervention_Feedback_SiteDE: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULLSite. Link to Site_DE.ID
Indexes NIX_Intervention_Feedback_CreatedDTTMCreatedDTTMdatetime8NOT NULL(getdate())Date/Time Record was Created
Indexes NIX_Intervention_Feedback_LastUpdatedDTTMLastUpdatedDTTMdatetime8NOT NULL(getdate())Date/Time Record was Last Updated