SiteSurveyResponses

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
ClientUsersID	int		Default = 0
MachineIP	nvarchar(50)	yes
DateAdded	datetime		Default = getutcdate()
ProcessedDate	datetime	yes
REProcessed	bit		Default = 0
EEProcessed	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
SiteSurveysId	int		SiteSurveys.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_SiteSurveyResponses	ID	yes	yes	yes

Referenced by

Referenced by	Field
SiteSurveyResults	SiteSurveyResponsesId