DiscussionTopics

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Guid	uniqueidentifier		Default = (newid())
PostedByID	int	yes
Replies	int		Default = 0
LastPostDate	datetime		Default = getutcdate()
Approved	bit		Default = 0
Topic	nvarchar(510)	yes
ApprovedDate	datetime	yes
UpdateDate	datetime	yes	Default = getutcdate()
CreateDate	datetime	yes	Default = getutcdate()

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
GroupID	int		DiscussionGroups.ID
ApprovedID	int	yes	ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DiscussionTopics_1	Topic
IX_DiscussionTopics_GroupID_Approved_PostedById	GroupID, Approved, PostedByID
PK_DiscussionTopics	ID	yes	yes	yes

Referenced by

Referenced by	Field
DiscussionPosts	TopicID