NewsStories

Primary Key

Primary Key	Field Type
ID	int

Fields

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

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
NewsChannelID	int		NewsChannels.ID
PostId	int	yes	ClientUsers.ID
ApprovedID	int	yes	ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_NewsStories_1	NewsChannelID, PublicationDate (DESC)
IX_NewsStories_NewsChannelID	NewsChannelID
PK_NewsStories	ID	yes	yes	yes

Referenced by

Referenced by	Field
ACTIONCENTER	STORYID