列数: 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
索引数: 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: 不允许
更新时的参照完整性: 无动作
删除时的参照完整性: 层叠
列数: 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: 不允许
更新时的参照完整性: 无动作
删除时的参照完整性: 层叠
列数: 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: 不允许
更新时的参照完整性: 无动作
删除时的参照完整性: 层叠
列数: 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: 不允许
更新时的参照完整性: 无动作
删除时的参照完整性: 层叠
本文地址：http://com.8s8s.com/it/it44507.htm