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