SitePages
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PageName | nvarchar(255) | |||
| AuthorizedRoles | nvarchar(256) | yes | ||
| IsAdmin | bit | Default = 0 | ||
| BaseURL | nvarchar(50) | Default = N'PortalDefault.aspx' | ||
| ExpireDate | datetime | yes | ||
| PublishDate | datetime | yes | ||
| TemplateID | int | Default = 1 | ||
| Guid | uniqueidentifier | yes | Default = (newid()) | |
| OwnerID | int | yes | ||
| Deleted | bit | Default = 0 | ||
| TemplatePageID | int | yes | This is a page that this page pulls shared content from | |
| IsTemplatePage | bit | Default = 0 | ||
| Category | nvarchar(256) | yes | ||
| DisplayName | nvarchar(255) | yes | ||
| FolderID | int | Default = 0 | ||
| StyleSheetID | int | yes | ||
| Description | nvarchar(255) | yes | ||
| Keywords | nvarchar(255) | yes | ||
| UpdateDate | datetime | Default = getutcdate() | ||
| UseTemplateKeywords | bit | Default = 1 | ||
| CreateDate | datetime | yes | ||
| CopySourceID | int | yes | ||
| CopyBatchGUID | uniqueidentifier | yes | ||
| IsPageModel | bit | yes | ||
| IsThemed | bit | yes | ||
| ThemeLayoutNumber | int | yes | Default = 1 | |
| InTrashBin | bit | Default = 0 | ||
| URL | nvarchar(255) | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientSitesID | int | ClientSites.ID | ||
| FromModelId | int | yes | SitePages.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_SitePages_ClientSitesID | ClientSitesID | |||
| IX_SitePages_GUID_OwnerID_Deleted | Guid, OwnerID, Deleted | |||
| IX_SitePages_Search | ID, IsTemplatePage, TemplatePageID, Guid, PageName | |||
| IX_SitePages | ClientSitesID, IsTemplatePage, PageName | yes | ||
| IX_SitePages_ID | ID | yes | yes | |
| PK_Tabs | ID | yes | yes | |
| UC_CLIENTSITE_URL_SITEPAGES | ClientSitesID, URL | yes |
Referenced by
| Referenced by | Field |
|---|---|
| ChapterPages | SitePageID |
| ClientDonations | ShoppingCartPageID |
| ClientEvents | ShoppingCartPageID |
| ClientMemberships | ShoppingCartPageID |
| CMSREDIRECT | TARGETPAGEID |
| CMSSITEPAGEBBPAYTEMPLATEVERSION | SITEPAGEID |
| CMSTEMPLATELAYOUT | TEMPLATEID |
| ContentComparisonPart | TargetPID |
| ContentComparisonStats | PageID |
| CRMBBPAYTEMPLATE | SITEPAGEID |
| CustomFormPaymentSetting | PaymentPartPageID |
| FAFFUNDRAISINGROLESCONTENT | REGISTRATIONPAGEID |
| FAFPARTICIPANTPAGECONTENT | PAGEID |
| FundRaiserPages | SitePageID |
| MICROSITEPAGE | SITEPAGESID |
| PageContent | SitePagesID |
| VanityURL | PageID |