Community 學習——資料庫結構2
來源：互聯網
上載者：User
資料|資料庫|資料庫結構 (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: 不允許
更新時的參照完整性: 無動作
刪除時的參照完整性: 層疊
