Open topic with navigation

NewsChannels (4.0SP25)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Referenced by

Primary Key
Primary Key	Field Type
ID	int

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
SiteContentID	int	true	SiteContent.ID
PersonalPageDataID	int	true	PersonalPageData.ID

Fields
Field	Field Type	Null	Notes	Description
PublicationDate	datetime	false	getutcdate()
SiteImageID	int	true
Guid	uniqueidentifier	false	(newid())
AllowMembers	bit	true
Title	nvarchar(510)	true
LinkURL	nvarchar(2048)	true
Description	nvarchar(1024)	true
Copyright	nvarchar(510)	true
EditorEMail	nvarchar(510)	true
ImageTitle	nvarchar(510)	true
ImageLink	nvarchar(2048)	true
Moderated	bit	true	0

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_NewsChannels_GUID	Guid	False	False	False
IX_NewsChannels_SiteContentID	SiteContentID	False	False	False
PK_NewsChannels	ID	True	True	True

Referenced by
Referenced by	Field
NewsStories	NewsChannelID