Community 學習——數據庫結構2
2024-07-21 02:24:59
供稿：網友
中國最大的web開發資源網站及技術社區，
(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: 不允許
更新時的參照完整性: 無動作
刪除時的參照完整性: 層疊
