StatisticsMonthPage

Primary Key

Primary Key	Field Type
Guid	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
YYYYMM	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_StatisticsMonthPage_YYYYMM_PageID	YYYYMM, PageID
PK_StatisticsMonthPage	Guid	yes	yes