数据|数据库|数据库结构
(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: 不允许
更新时的参照完整性: 无动作
删除时的参照完整性: 层叠