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