数据|数据库|数据库结构(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: 不允许

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

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