Open topic with navigation

NewsStories (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
NewsChannelID	int	false	NewsChannels.ID
PostId	int	true	ClientUsers.ID
ApprovedID	int	true	ClientUsers.ID

Fields
Field	Field Type	Null	Notes	Description
PublicationDate	datetime	false	getutcdate()
Guid	uniqueidentifier	false	(newid())
LinkURL	nvarchar(1024)	true
Description	ntext	true
Title	nvarchar(510)	true
Approved	bit	true	0
ApprovedDate	datetime	true
UpdateDate	datetime	true	getutcdate()
CreateDate	datetime	true	getutcdate()
Categories	nvarchar(1024)	true
LinkedPageId	int	true
LinkedPageTabID	int	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_NewsStories_1	NewsChannelID PublicationDate	False	False	False
IX_NewsStories_NewsChannelID	NewsChannelID	False	False	False
PK_NewsStories	ID	True	True	True

Referenced by
Referenced by	Field
ACTIONCENTER	STORYID