Community learning - database structure 2

xiaoxiao2021-03-06  135

(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

转载请注明原文地址:https://www.9cbs.com/read-127466.html

New Post(0)