SiteContent (4.0SP4)

Primary Key
Primary Key	Field Type
ID	int

Foreign Key Fields
Foreign Key	Field Type	Null	Notes
ClientSitesID	int	false	ClientSites.ID
WorkflowID	int	true	Workflow.ID
FromModelId	int	true	SiteContent.ID

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

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

Triggers
Trigger Name	Description
TR_SiteContent_INSERT_UPDATE
trgDeleteContentFromCompletedComparisonTests

Referenced by
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