Tables [dbo].[SOS_SurveyResults]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:52 AM Thursday, March 21, 2019
Last Modified1:00:52 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentity
SurveyResultIDint4
False
1 - 1
CallIDint4
True
SOIDint4
True
CustomerIDint4
True
TechnicianIDint4
True
SalesRepIDint4
True
DateReceiveddatetime8
True
C_SurveyMasterQuestionIDint4
False
Q1varchar(250)250
True
Q2varchar(250)250
True
Q3varchar(250)250
True
Q4varchar(250)250
True
Q5varchar(250)250
True
Q6varchar(250)250
True
Q7varchar(250)250
True
Q8varchar(250)250
True
Q9varchar(250)250
True
Q10varchar(250)250
True
Q11varchar(250)250
True
Q12varchar(250)250
True
Q13varchar(250)250
True
Q14nvarchar(max)max
True
Q15varchar(250)250
True
Q16varchar(250)250
True
Q17varchar(250)250
True
Q18varchar(250)250
True
Q19varchar(250)250
True
Q20varchar(250)250
True
DateSubmitteddatetime8
True
emailaddressvarchar(250)250
True
Select_Survey_IDint4
True
Select_Email_address_IDint4
True
CREATE TABLE [dbo].[SOS_SurveyResults]
(
[SurveyResultID] [int] NOT NULL IDENTITY(1, 1),
[CallID] [int] NULL,
[SOID] [int] NULL,
[CustomerID] [int] NULL,
[TechnicianID] [int] NULL,
[SalesRepID] [int] NULL,
[DateReceived] [datetime] NULL,
[C_SurveyMasterQuestionID] [int] NOT NULL,
[Q1] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q2] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q3] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q4] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q5] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q6] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q7] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q8] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q9] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q10] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q11] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q12] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q13] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q14] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q15] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q16] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q17] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q18] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q19] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Q20] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateSubmitted] [datetime] NULL,
[emailaddress] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Select_Survey_ID] [int] NULL,
[Select_Email_address_ID] [int] NULL
) ON [PRIMARY]
GO