Search

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
TimeStamp	timestamp
GUID	uniqueidentifier		Default = (newid())
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
SearchTypeId	int
SiteContentId	int
ContentUpdateDate	datetime
ExtendedKey	nvarchar(255)
Title	nvarchar(255)	yes
SearchText	ntext
SearchDate1	datetime	yes
SearchInt1	int	yes
SearchDate2	datetime	yes
TagText	ntext	yes

Indexes

Index Name	Fields	Unique	Primary	Clustered
Search_SearchInt1	SearchInt1
PK_Search	ID	yes	yes	yes