Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 Title nvarchar(256)
 XMLData ntext
 ExpireDate datetime
 PublishDate datetime
 AuthorizedEditRoles nvarchar(256)
 CacheTime int Default = 0
 ShowMobile bit Default = 0
 Guid uniqueidentifier   Default = (newid())
 OwnerID int
 Deleted bit   Default = 0
 Approved bit   Default = 1
 ContentTypesID int
 Description nvarchar(256)
 IsTimePublished bit   Default = 0
 CreateDate datetime   Default = getutcdate()
 UpdateDate datetime   Default = getutcdate()
 LanguageTarget nvarchar(256)
 TestMode bit   Default = 'false'
 CopySourceID int
 CopyBatchGUID uniqueidentifier
 Discoverable bit  
 DiscoverableTitle nvarchar(255)
 DiscoverableSummary nvarchar(4000)
 FolderID int   Default = 0
 ShareInSiteCopy bit   Default = 0
 CanCreateLocalCopy bit   Default = 0
 ChangedByCMSUserID int
 InTrashBin bit   Default = 0
 BBSPEnabled bit   Default = 0

Foreign Key Field Type Null Notes Description
 ClientSitesID int   ClientSites.ID
 WorkflowID int Workflow.ID
 FromModelId int SiteContent.ID

Index Name Field(s) Unique Primary Clustered
 IX_SiteContent_ClientSitesID ClientSitesID      
 IX_SiteContent_ContentTypeID_UpdateDate ContentTypesID, UpdateDate      
 IX_SiteContent_GUID_ID Guid, ID      
 IX_SiteContent_GUID_OwnerID_Deleted Guid, OwnerID, Deleted      
 IX_SiteContent ClientSitesID, ContentTypesID, Title    
 PK_Content ID

Trigger Name Description
 TR_SiteContent_INSERT_UPDATE
 trgDeleteContentFromCompletedComparisonTests

Referenced by Field
 ACTIONCENTER SITECONTENTID
 ADVOCACYACTIVITY SITECONTENTID
 ADVOCACYLOG SITECONTENTID
 ADVOCACYPETITION SITECONTENTID
 ChapterSite SiteContentID
 ClientDonations ContentID
 ClientEvents ContentID
 ClientMemberships SiteContentID
 ClientUserCalendarFilters SiteContentID
 ClientUserReport SiteContentID
 ContentComparisonPart SiteContentID
 CRMBBPAYTEMPLATE SITECONTENTID
 DiscussionGroups SiteContentID
 DocUploadPart SiteContentID
 DonorScrollers ContentID
 ECardPart SiteContentID
 EducationEdit SiteContentID
 ETICKETSPARTSETTINGS SITECONTENTID
 EventCalendar SiteContentID
 EventCalendarHighlight SiteContentID
 EventCalendarView SiteContentID
 EVENTREGISTRATIONEXPRESSPARTSETTINGS SITECONTENTID
 FundRaisers SiteContentID
 GivingHistory SiteContentID
 GivingHistory2 SiteContentID
 JobBoards SiteContentID
 Kpi SiteContentID
 MEMBERSHIPEXPRESSPARTSETTINGS SITECONTENTID
 MICROSITECONTENT CONTENTID
 MICROSITEPAGE PRIMARYCONTENTID
 NavBarItems ContentID
 NetworkRanking SiteContentID
 NewsChannels SiteContentID
 NewsReaders SiteContentID
 Notification_SiteContent SiteContentID
 PageContent SiteContentID
 PersonalizedContentData SiteContentID
 PERSONALNOTESSETTINGS SITECONTENTID
 PersonalPageElements SiteContentID
 ProfileEditorFields ContentID
 PROGRAMTICKETPARTCONTENT CONTENTID
 QuickSearchPart SiteContentID
 SearchPart SiteContentID
 SharingPart SiteContentID
 ShoppingCartPart SiteContentID
 ShoppingCartSummaryPart SiteContentID
 SignInProperties ContentID
 SignOnControls ContentID
 SITECONTENTFOLDERS CONTENTID
 SITECONTENTTAG SITECONTENTID
 SiteContentVersion SiteContentID
 SiteMenu ContentID
 SiteNotes ContentID
 SitePolls ID
 SiteProfilePhotoForm ContentID
 SiteSurveys ID
 SiteVolunteerOps ContentID
 STUDENTPAYMENTPARTEE7SETTINGS CONTENTID
 TargetedContentChecks ContentID
 TargetedContentPart SiteContentID
 UserPageManager SiteContentID
 WEBFORMSUSERREGISTRATIONPARTSETTING SITECONTENTID

Entity-Relationship diagram of this table (ChapterSite-GivingHistory2)
Entity-Relationship diagram of this table (JobBoards-SiteContentVersion)
Entity-Relationship diagram of this table (SiteMenu-Workflow)