NewsChannels
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PublicationDate | datetime | Default = getutcdate() | ||
| SiteImageID | int | yes | ||
| Guid | uniqueidentifier | Default = (newid()) | ||
| AllowMembers | bit | yes | ||
| Title | nvarchar(510) | yes | ||
| LinkURL | nvarchar(2048) | yes | ||
| Description | nvarchar(1024) | yes | ||
| Copyright | nvarchar(510) | yes | ||
| EditorEMail | nvarchar(510) | yes | ||
| ImageTitle | nvarchar(510) | yes | ||
| ImageLink | nvarchar(2048) | yes | ||
| Moderated | bit | yes | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SiteContentID | int | yes | SiteContent.ID | |
| PersonalPageDataID | int | yes | PersonalPageData.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_NewsChannels_GUID | Guid | |||
| IX_NewsChannels_SiteContentID | SiteContentID | |||
| PK_NewsChannels | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| NewsStories | NewsChannelID |