SitePollResults

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()
processed_date	datetime	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
SitePollAnswersID	int		SitePollAnswers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_SitePollResults_processed_date_SitePollAnswersID_ClientUsersID	processed_date, SitePollAnswersID, ClientUsersID
IX_SitePollResults_SitePollAnswersID	SitePollAnswersID
PK_SitePollResults	ID	yes	yes	yes