Community 学习——数据库结构2

(6) Community_Communities

列数:         12

索引数:     0

外键数:     0

主键:         community_id

代码:         0

列	数据类型	允许 NULL	值/范围
community_id	int identity	不允许
community_name	nvarchar(50)	不允许
community_uniqueID	uniqueidentifier ROWGUIDCOL	不允许
community_PrimaryDomain	nvarchar(50)	不允许
community_domain	nvarchar(50)	不允许
community_subdomain	nvarchar(50)	不允许
community_smtpServer	nvarchar(50)	不允许
community_databaseQuota	int	不允许
community_databaseQuotaUsed	int	不允许
community_sortOrder	int	不允许
community_isDisplayed	bit	不允许
community_enableTopicMenu	bit	不允许

外键	子	父
FK_Community_Errors_Community_Communities	Community_ActivityLog.activity_communityID	community_id
FK_Community_CommunityImages_Community_Communities	Community_CommunityImages.Image_CommunityID	community_id
FK_Community_Messages_Community_Communities	Community_Messages.Message_CommunityID	community_id
FK_Community_Newsletters_Community_Communities	Community_Newsletters.newsletter_communityID	community_id
FK_Community_NewsletterTemplates_Community_Communities	Community_NewsletterTemplates.Template_CommunityID	community_id
FK_Community_Sections_Community_Communities	Community_Sections.section_communityID	community_id
FK_Community_Services_Community_Communities	Community_Services.service_communityID	community_id
FK_Community_ServiceSubscriptions_Community_Communities	Community_ServiceSubscriptions.ss_communityID	community_id
FK_Community_Topics_Community_Communities	Community_Topics.topic_communityID	community_id
FK_Community_UserRoles_Community_Communities	Community_UserRoles.Role_CommunityID	community_id
FK_Community_Users_Community_Communities	Community_Users.User_CommunityID	community_id
FK_Community_VotingPolls_Community_Communities	Community_VotingPolls.Community_ID	community_id

(7) Community_CommunityImages

列数:         7

索引数:     0

外键数:     1

主键:         Image_ID

代码:         0

列	数据类型	允许 NULL	值/范围
Image_ID	int identity	不允许
Image_CommunityID	int	不允许
Image_FileName	nvarchar(250)	不允许
Image_ContentType	nvarchar(50)	不允许
Image_DateCreated	datetime	不允许
Image_ImageType	int	不允许
Image_ImageData	image	不允许

外键详细信息（子）

FK_Community_CommunityImages_Community_Communities

定义:         子                                          父
Image_CommunityID         Community_Communities.community_id

允许 NULL:      不允许

更新时的参照完整性:       无动作

删除时的参照完整性:       层叠

(8) Community_ContentPages

列数:         27

索引数:     2

外键数:     1

主键:         contentPage_id

代码:         0

列	数据类型	允许 NULL	值/范围
contentPage_id	int identity	不允许
contentPage_communityID	int	不允许
contentPage_userID	int	允许
contentPage_editUserID	int	允许
contentPage_parentID	int	不允许
contentPage_pageType	int	不允许
contentPage_sectionID	int	不允许
contentPage_title	nvarchar(100)	不允许
contentPage_description	nvarchar(500)	不允许
contentPage_metaDesc	nvarchar(250)	不允许
contentPage_metaKeys	nvarchar(250)	不允许
contentPage_dateCreated	datetime	不允许
contentPage_dateUpdated	datetime	允许
contentPage_dateCommented	datetime	允许
contentPage_topicID	int	允许
contentPage_replyID	int	不允许
contentPage_ModerationStatus	int	不允许
contentPage_ModerationUserID	int	不允许
contentPage_Rating	int	不允许
contentPage_SortOrder	datetime	不允许
contentPage_dateVisible	datetime	不允许
contentPage_viewCount	int	不允许
contentPage_timestamp	timestamp	不允许
contentPage_remoteCommunityUniqueID	uniqueidentifier	允许
contentPage_remoteContentPageID	int	允许
contentPage_remoteUsername	nvarchar(50)	允许
contentPage_remoteTimestamp	varbinary(50)	允许

索引	列	排序方式
ContentPage_SectionID	contentPage_sectionID	升序
IX_Community_ContentPages	contentPage_viewCount	升序

外键	子	父
FK_Community_ContentPages_Community_Sections	contentPage_sectionID	Community_Sections.section_id
FK_Community_Articles_Community_ContentPages	Community_Articles.Article_ContentPageID	contentPage_id
FK_Community_Books_Community_ContentPages	Community_Books.Book_ContentPageID	contentPage_id
FK_Community_Comments_Community_ContentPages	Community_Comments.Comment_ContentPageID	contentPage_id
FK_Community_Discuss_Community_ContentPages	Community_Discuss.Discuss_ContentPageID	contentPage_id
FK_Community_Downloads_Community_ContentPages	Community_Downloads.Download_ContentPageID	contentPage_id
FK_Community_Events_Community_ContentPages	Community_Events.Event_ContentPageID	contentPage_id
FK_Community_HasRead_Community_ContentPages	Community_HasRead.hr_contentPageID	contentPage_id
FK_Community_Links_Community_ContentPages	Community_Links.Link_ContentPageID	contentPage_id
FK_Community_PhotoGallery_Community_ContentPages	Community_PhotoGallery.photo_contentPageID	contentPage_id
FK_Community_Ratings_Community_ContentPages	Community_Ratings.Rating_ContentPageID	contentPage_id
FK_Community_SearchKeys_Community_ContentPages	Community_SearchKeys.search_contentPageID	contentPage_id
FK_Community_SectionImages_Community_ContentPages	Community_SectionImages.Image_ContentPageID	contentPage_id

索引详细信息

ContentPage_SectionID

列:    contentPage_sectionID  (Asc)

唯一:         No

扩展属性:

OnFileGroup      PRIMARY

CLUSTERED     No

IGNORE_DUP_KEY  No

FILLFACTOR   0

PAD_INDEX     No

DROP_EXISTING      No

STATISTICS_NORECOMPUTE         No

IX_Community_ContentPages

列:    contentPage_viewCount  (Asc)

唯一:         No

扩展属性:

OnFileGroup      PRIMARY

CLUSTERED     No

IGNORE_DUP_KEY  No

FILLFACTOR   0

PAD_INDEX     No

DROP_EXISTING      No

STATISTICS_NORECOMPUTE         No

外键详细信息（子）

FK_Community_ContentPages_Community_Sections

定义:         子                                          父
contentPage_sectionID     Community_Sections.section_id

允许 NULL:      不允许

更新时的参照完整性:       无动作

删除时的参照完整性:       层叠

(9) Community_Discuss

列数:         6

索引数:     0

外键数:     1

主键:         Discuss_ContentPageID

代码:         0

列	数据类型	允许 NULL	值/范围
Discuss_ContentPageID	int	不允许
Discuss_LastCommentUserID	int	允许
Discuss_IsAnnouncement	bit	不允许
Discuss_IsPinned	bit	不允许
Discuss_IsLocked	bit	不允许
Discuss_BodyText	ntext	允许

外键详细信息（子）

FK_Community_Discuss_Community_ContentPages

定义:         子     父
Discuss_ContentPageID   Community_ContentPages.contentPage_id

允许 NULL:      不允许

更新时的参照完整性:       无动作

删除时的参照完整性:       层叠

(10) Community_Downloads

列数:         6

索引数:     0

外键数:     1

主键:         Download_ContentPageID

代码:         0

列	数据类型	允许 NULL	值/范围
Download_ContentPageID	int	不允许
Download_FileName	nvarchar(250)	不允许
Download_FileSize	int	不允许
Download_FullDescription	ntext	允许
Download_DownloadCount	int	不允许
Download_FileData	image	不允许

外键详细信息（子）

FK_Community_Downloads_Community_ContentPages

定义:         子     父
Download_ContentPageID        Community_ContentPages.contentPage_id

允许 NULL:      不允许

更新时的参照完整性:       无动作

删除时的参照完整性:       层叠