(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)
不允许

cont