Stats

Primary Key

Primary Key	Field Type
StatsID	int

Fields

Field	Field Type	Null	Notes	Description
ClientsID	int
ClientSitesID	int
UserID	int	yes
RequestDate	datetime
PageID	int
SourceID	int	yes
SourceTypeID	int
SourceREID	int	yes
EmailJobRecipientID	int	yes
FRSolicitorID	int	yes
FRTeamID	int	yes
ReferringPageURL	ntext	yes
TCPIPAddress	nvarchar(30)	yes
URL	nvarchar(1784)	yes
SessionID	nvarchar(32)	yes
UserAgent	nvarchar(256)	yes
GUID	nchar	yes
UserPersonalPageID	int	yes
CCPRelID	int		Default = -1
DocumentID	int	yes

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_Stats_EmailJobRecipientID	EmailJobRecipientID
IX_Stats_FRSolicitorID_PageID	FRSolicitorID, PageID
IX_Stats_FRTeamID_PageID	FRTeamID, PageID
IX_Stats_PageID_SourceID_SourceTypeID_EmailJobRecipientID_ID	PageID, SourceID, SourceTypeID, EmailJobRecipientID, StatsID
IX_Stats_RequestDate_TCPIPAddress_GUID	RequestDate, TCPIPAddress, GUID
IX_Stats_SourceID_SourceTypeID_UserID	SourceID, SourceTypeID, UserID
IX_Stats_URL_SourceID_SourceTypeID_EmailJobRecipientID_ID	URL, SourceID, SourceTypeID, EmailJobRecipientID, StatsID
IX_Stats_UserID_RequestDate	UserID, RequestDate
PK_Stats	StatsID	yes	yes