CREATE TABLE [dbo].[SurveyResult]
(
[surveyResultID] [int] NOT NULL IDENTITY(1, 1),
[surveyID] [int] NOT NULL,
[selfServeSessionID] [int] NOT NULL,
[scriptID] [int] NOT NULL,
[response] [int] NULL,
[completion] [int] NOT NULL CONSTRAINT [DF__SurveyRes__compl__1881A0DE] DEFAULT ((0)),
[SurveyComment] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[surveyEpoch] [decimal] (18, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SurveyResult] ADD CONSTRAINT [pk_surveyresult] PRIMARY KEY CLUSTERED ([surveyResultID]) ON [PRIMARY]
GO
[dbo].[SurveyResult]
