ClientSites
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(255) | |||
| Deleted | bit | Default = 0 | ||
| ClientsID | int | |||
| Guid | uniqueidentifier | Default = (newid()) | ||
| SiteTrackingScript | nvarchar(max) | yes | ||
| CopySourceID | int | yes | ||
| CopyBatchGUID | uniqueidentifier | yes | ||
| FavIconImageID | int | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| OwnerID | int | yes | ClientUsers.ID | |
| ParentSiteID | int | yes | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ClientSites_OwnerID | OwnerID | |||
| PK_Portals | ID | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| ATHLETICS_LOCATIONS | ClientSitesID |
| ATHLETICS_SETTINGS | ClientSitesID |
| ATHLETICS_TEAMS | ClientSitesID |
| ClientMerchantAccounts | ClientSitesID |
| ClientSSO | ClientSiteID |
| ClientUsers | DefaultSiteID |
| CMSSECURITYGROUPCLIENTROLECLIENTSITE | CLIENTSITESID |
| CMSSITESETTING | CLIENTSITESID |
| CMSSITEURLS | CLIENTSITESID |
| CRMBBPAYTEMPLATE | CLIENTSITESID |
| CustomFormSettings | ClientSitesID |
| ECard | ClientSitesID |
| ECardTemplate | ClientSitesID |
| ClientSitesID | |
| EmailList | ClientSitesID |
| EmailProject | ClientSitesID |
| EMAILSCHEDULE | CLIENTSITESID |
| EmailTemplate | ClientSitesID |
| EVENTEXTENSION | CLIENTSITESID |
| PAGEMODEL | CLIENTSITESID |
| PAGEMODELDESIGN | CLIENTSITESID |
| SEARCHPART_CLIENTSITES | CLIENTSITESID |
| SiteContent | ClientSitesID |
| SiteCopy | SourceClientSitesID |
| SiteCopy | TargetClientSitesID |
| SiteImages | ClientSitesID |
| SiteLayouts | ClientSitesID |
| SitePages | ClientSitesID |
| THEME | CLIENTSITESID |
| UserImport | SiteClientsID |
| VanityURL | ClientSitesID |