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