CREATE TABLE [dbo].[WebSurvey]
(
[PriKey] [int] NOT NULL IDENTITY(1, 1),
[OrdPriKey] [int] NOT NULL,
[Response1] [int] NULL,
[Response2] [int] NULL,
[Response3] [int] NULL,
[Response4] [int] NULL,
[Response5] [int] NULL,
[Rating] [int] NULL,
[Response6] [int] NULL,
[Response7] [int] NULL,
[Response8] [int] NULL,
[Response9] [int] NULL,
[Response10] [int] NULL,
[Response11] [int] NULL,
[Response12] [int] NULL,
[Response13] [int] NULL,
[Response14] [int] NULL,
[Response15] [int] NULL,
[Response16] [int] NULL,
[Response17] [int] NULL,
[Response18] [int] NULL,
[Response19] [int] NULL,
[Response20] [int] NULL,
[Comments] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebSurvey] ADD CONSTRAINT [PK_WebSurvey] PRIMARY KEY CLUSTERED  ([PriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebSurvey] ADD CONSTRAINT [FK_WebSurvey_ORDERS] FOREIGN KEY ([OrdPriKey]) REFERENCES [dbo].[Orders] ([PriKey])
GO
GRANT SELECT ON  [dbo].[WebSurvey] TO [MssExec]
GRANT INSERT ON  [dbo].[WebSurvey] TO [MssExec]
GRANT DELETE ON  [dbo].[WebSurvey] TO [MssExec]
GRANT UPDATE ON  [dbo].[WebSurvey] TO [MssExec]
GO