Community Learning--Database structure 2

Data | database | database structure (6) community_communities
Number of columns: 12

Number of indexes: 0

Number of foreign keys: 0

Primary key: community_id

Code: 0

Column
Data type
Allow NULL
Value/Range

community_id
int identity
Not allowed

Community_Name
nvarchar (50)
Not allowed

Community_uniqueid
uniqueidentifier ROWGUIDCOL
Not allowed

Community_primarydomain
nvarchar (50)
Not allowed

Community_domain
nvarchar (50)
Not allowed

Community_subdomain
nvarchar (50)
Not allowed

Community_smtpserver
nvarchar (50)
Not allowed

Community_databasequota
Int
Not allowed

Community_databasequotaused
Int
Not allowed

Community_sortorder
Int
Not allowed

Community_isdisplayed
Bit
Not allowed

Community_enabletopicmenu
Bit
Not allowed

FOREIGN key
Child
Father

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

Number of foreign keys: 1

Primary key: image_id

Code: 0

Column
Data type
Allow NULL
Value/Range

image_id
int identity
Not allowed

Image_communityid
Int
Not allowed

Image_filename
nvarchar (250)
Not allowed

Image_contenttype
nvarchar (50)
Not allowed

image_datecreated
Datetime
Not allowed

Image_imagetype
Int
Not allowed

Image_imagedata
Image
Not allowed


Foreign key details (child)

Fk_community_communityimages_community_communities

Definition: Child Parent
Image_communityid community_communities.community_id

Allow NULL: not allowed

Referential integrity when updated: no action

Referential integrity when deleted: Cascade

(8) Community_contentpages
Number of columns: 27

Number of indexes: 2

Number of foreign keys: 1

Primary key: contentpage_id

Code: 0

Column
Data type
Allow NULL
Value/Range

contentpage_id
int identity
Not allowed

Contentpage_communityid
Int
Not allowed

Contentpage_userid
Int
Allow

Contentpage_edituserid
Int
Allow

Contentpage_parentid
Int
Not allowed

Contentpage_pagetype
Int
Not allowed

Contentpage_sectionid
Int
Not allowed

Contentpage_title
nvarchar (100)
Not allowed

Contentpage_description
nvarchar (500)
Not allowed

Contentpage_metadesc
nvarchar (250)
Not allowed

Contentpage_metakeys
nvarchar (250)
Not allowed

contentpage_datecreated
Datetime
Not allowed

contentpage_dateupdated
Datetime
Allow

contentpage_datecommented
Datetime
Allow

Contentpage_topicid
Int
Allow

Contentpage_replyid
Int
Not allowed

Contentpage_moderationstatus
Int
Not allowed

Contentpage_moderationuserid
Int
Not allowed

Contentpage_rating
Int
Not allowed

Contentpage_sortorder
Datetime
Not allowed

Contentpage_datevisible
Datetime
Not allowed

Contentpage_viewcount
Int
Not allowed

Contentpage_timestamp
Timestamp
Not allowed

Contentpage_remotecommunityuniqueid
uniqueidentifier
Allow

Contentpage_remotecontentpageid
Int
Allow

Contentpage_remoteusername
nvarchar (50)
Allow

Contentpage_remotetimestamp
varbinary (50)
Allow

Index
Column
How to sort

Contentpage_sectionid
Contentpage_sectionid
Ascending

Ix_community_contentpages
Contentpage_viewcount
Ascending

FOREIGN key
Child
Father

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


Index details

Contentpage_sectionid

Columns: Contentpage_sectionid (ASC)

Unique: No

Extended Properties:

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 Properties:

Onfilegroup PRIMARY

CLUSTERED No

Ignore_dup_key No

FILLFACTOR 0

Pad_index No

Drop_existing No

Statistics_norecompute No

Foreign key details (child)

Fk_community_contentpages_community_sections

Definition: Child Parent
Contentpage_sectionid community_sections.section_id

Allow NULL: not allowed

Referential integrity when updated: no action

Referential integrity when deleted: Cascade

(9) Community_discuss
Number of columns: 6

Number of indexes: 0

Number of foreign keys: 1

Primary key: Discuss_contentpageid

Code: 0

Column
Data type
Allow NULL
Value/Range

Discuss_contentpageid
Int
Not allowed

Discuss_lastcommentuserid
Int
Allow

Discuss_isannouncement
Bit
Not allowed

discuss_ispinned
Bit
Not allowed

Discuss_islocked
Bit
Not allowed

Discuss_bodytext
ntext
Allow


Foreign key details (child)

Fk_community_discuss_community_contentpages

Definition: Child Parent
Discuss_contentpageid community_contentpages.contentpage_id

Allow NULL: not allowed

Referential integrity when updated: no action

Referential integrity when deleted: Cascade

(a) Community_downloads
Number of columns: 6

Number of indexes: 0

Number of foreign keys: 1

Primary key: Download_contentpageid

Code: 0

Column
Data type
Allow NULL
Value/Range

Download_contentpageid
Int
Not allowed

Download_filename
nvarchar (250)
Not allowed

Download_filesize
Int
Not allowed

Download_fulldescription
ntext
Allow

Download_downloadcount
Int
Not allowed

Download_filedata
Image
Not allowed


Foreign key details (child)

Fk_community_downloads_community_contentpages

Definition: Child Parent
Download_contentpageid community_contentpages.contentpage_id

Allow NULL: not allowed

Referential integrity when updated: no action

Referential integrity when deleted: Cascade