(6)
Community_Communities
Columns: 12
Number of indexes: 0
Foreign key: 0
Progran key: Community_ID
Code: 0
Column data type allows NULL values / ranges community_id int identity allowed community_name nvarchar (50) is not allowed not allowed community_uniqueID uniqueidentifier ROWGUIDCOL community_PrimaryDomain nvarchar (50) is not allowed community_domain nvarchar (50) is not allowed community_subdomain nvarchar (50) is not allowed community_smtpServer nvarchar (50 ) Do not allow Community_DatabaseQuota Int Not Allow Community_DatabaseQuOTaused Int Not Allow Community_Sortorder Int Not Allow Community_IndisPlayed Bit Not Allow Community_enabletopicMenu Bit Not allowed
Foreign key child-parent 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
Number of columns: 7
Number of indexes: 0
Foreign key: 1
Progran key: image_id
Code: 0
Column data type allows NULL values / ranges Image_ID int identity allowed Image_CommunityID int allowed Image_FileName nvarchar (250) is not allowed Image_ContentType nvarchar (50) is not allowed Image_DateCreated datetime Image_ImageData image is not allowed not allowed not allowed Image_ImageType int
Foreign key details (sub)
FK_COMMUNITY_COMMUNITYIMAGES_COMMUNITY_COMMUNISIES
Definition: Subfather Image_CommunityId Community_Communities.community_ID
Allow NULL: Reference Integrity when updating: No action
Reference integrity when deleting: laminated
(8) Community_ContentPages
Number of columns: 27
Number of indexes: 2
Foreign key: 1
Programs: contentpage_id
Code: 0
Column data type allows NULL values / ranges contentPage_id int identity allowed contentPage_communityID int allowed contentPage_userID int Allow contentPage_editUserID int Allow contentPage_parentID int allowed contentPage_pageType int allowed contentPage_sectionID int allowed contentPage_title nvarchar (100) is not allowed contentPage_description nvarchar (500) allowed contentPage_metaDesc nvarchar (250) is not allowed contentPage_metaKeys nvarchar (250) is not allowed not allowed contentPage_dateCreated datetime contentPage_dateUpdated datetime allow contentPage_dateCommented datetime allow contentPage_topicID int allow contentPage_replyID int contentPage_ModerationStatus int allowed not allowed not allowed contentPage_Rating int contentPage_ModerationUserID int contentPage_SortOrder datetime not allowed not allowed not allowed contentPage_dateVisible datetime contentPage_viewCount int allowed contentPage_timestamp timestamp allowed contentPage_remoteCommunityUniqueID uniqueidentifier allow contentPage_remoteContentPageID int allow contentPage_remoteUsername nvarchar (50) allowing contentPage_remoteTim Estamp Varbinary (50) Allow
Index Column Sort by ContentPage_sectionId ContentPage_sectionID Ascending IX_COMMUNITY_CONTENTPAGES ContentPage_ViewCount Ascending
Foreign key child-parent 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_communit y_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 Index Details
ContentPage_SectionID
Columns: contentpage_sectionID (ASC)
Unique: no
Extended attribute:
Onfilegroup Primary
Clustered NO
Ignore_dup_Key NO
FillFactor 0
PAD_INDEX NO
DROP_EXISTING NO
Statistics_noreCompute No
IX_COMMUNITY_CONTENTPAGES
Columns: ContentPage_ViewCount (ASC)
Unique: no
Extended attribute:
Onfilegroup Primary
Clustered NO
Ignore_dup_Key No
FillFactor 0
PAD_INDEX NO
DROP_EXISTING NO
Statistics_noreCompute No
Foreign key details (sub)
FK_COMMUNITY_CONTENTPAGES_COMMUNITY_SECTIONS
Definition: Subfather ContentPage_SECTIONID Community_Sections.SECTION_ID
Allow NULL: Not allowed
Reference integrity when updating: no action
Reference integrity when deleting: laminated
(9) Community_Discuss
Columns: 6
Number of indexes: 0
Foreign key: 1
Programs: Discuss_ContentPageId
Code: 0
Column data type allows NULL values / ranges Discuss_ContentPageID int allowed Discuss_LastCommentUserID int Allow Discuss_IsAnnouncement bit Discuss_IsPinned bit not allowed not allowed not allowed Discuss_IsLocked bit allows Discuss_BodyText ntext
Foreign key details (sub)
FK_COMMUNITY_DISCUSS_COMMUNITY_CONTENTPAGES
Definition: Subfather Discuss_ContentPageId Community_ContentPages.ContentPage_ID
Allow NULL: Not allowed
Reference integrity when updating: no action
Reference integrity when deleting: laminated
(10) Community_Downloads
Columns: 6
Number of indexes: 0
Foreign key: 1
Programs: Download_ContentPageId
Code: 0
Column data type allows NULL values / ranges Download_ContentPageID int allowed Download_FileName nvarchar (250) is not allowed not allowed Download_FullDescription ntext Download_FileSize int Allow Download_DownloadCount int allowed allowed Download_FileData image
Foreign key details (sub)
FK_COMMUNITY_DOWNLOADS_COMMUNITY_CONTENTPAGES
Definition: Subfident Download_ContentPageId Community_ContentPages.ContentPage_ID
Allow NULL: Not allowed
Reference integrity when updating: no action
Reference integrity when deleting: laminated