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: 不允許

更新時的參照完整性: 無動作

刪除時的參照完整性: 層疊




相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。