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