DiscussionGroups
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| RequiresApproval | bit | Default = 0 | ||
| Guid | uniqueidentifier | Default = (newid()) | ||
| GroupName | nvarchar(510) | yes | ||
| PostNewTopicMessage | nvarchar(510) | yes | ||
| PostNewReplyMessage | nvarchar(510) | yes | ||
| SpellTopicWithErrors | nvarchar(510) | yes | ||
| SpellTopicNoErrors | nvarchar(510) | yes | ||
| SpellReplyWithErrors | nvarchar(510) | yes | ||
| SpellReplyNoErrors | nvarchar(510) | yes | ||
| AllowAnonymous | bit | Default = 1 | ||
| AnonymousName | nvarchar(30) | Default = 'Anonymous' |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SiteContentID | int | SiteContent.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_DiscussionGroups_1 | GroupName | |||
| IX_DiscussionGroups_GUID | Guid | |||
| IX_DiscussionGroups_SiteContentID | SiteContentID | |||
| PK_DiscussionGroups | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| DiscussionTopics | GroupID |