StatisticsDayPage

Primary Key

Primary Key	Field Type
Guid	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
YYYYMMDD	nchar
PageID	int
PageViews	bigint
Visits	bigint
Hosts	bigint
UserPageViews	bigint
UserVisits	bigint
Users	bigint
Partial	bit		Default = 0
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_StatisticsDayPage_YYYYMMDD_PageID	YYYYMMDD, PageID
PK_PageStatistics	Guid	yes	yes