DiscussionPosts

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
PostedByID	int	yes
IndentLevel	int		Default = 0
PostDate	datetime		Default = getutcdate()
Sequence	int		Default = 0
Approved	bit		Default = 0
Message	ntext	yes
Blocked	bit	yes	Default = 0
ApprovedDate	datetime	yes
UpdateDate	datetime	yes	Default = getutcdate()
CreateDate	datetime	yes	Default = getutcdate()

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
TopicID	int		DiscussionTopics.ID
ReplyToID	int	yes	DiscussionPosts.ID
ApprovedID	int	yes	ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DiscussionPosts_TopicID_ReplyToID_IndentLevel_Sequence	TopicID, ReplyToID, IndentLevel, Sequence
PK_DiscussionPosts	ID	yes	yes	yes

Triggers

Trigger Name	Description
TR_DiscussionPosts_Insert