SiteContent
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Title | nvarchar(256) | yes | ||
| XMLData | ntext | yes | ||
| ExpireDate | datetime | yes | ||
| PublishDate | datetime | yes | ||
| AuthorizedEditRoles | nvarchar(256) | yes | ||
| CacheTime | int | yes | Default = 0 | |
| ShowMobile | bit | yes | Default = 0 | |
| Guid | uniqueidentifier | Default = (newid()) | ||
| OwnerID | int | yes | ||
| Deleted | bit | Default = 0 | ||
| Approved | bit | Default = 1 | ||
| ContentTypesID | int | yes | ||
| Description | nvarchar(256) | yes | ||
| IsTimePublished | bit | Default = 0 | ||
| CreateDate | datetime | Default = getutcdate() | ||
| UpdateDate | datetime | Default = getutcdate() | ||
| LanguageTarget | nvarchar(256) | yes | ||
| TestMode | bit | Default = 'false' | ||
| CopySourceID | int | yes | ||
| CopyBatchGUID | uniqueidentifier | yes | ||
| Discoverable | bit | |||
| DiscoverableTitle | nvarchar(255) | yes | ||
| DiscoverableSummary | nvarchar(4000) | yes | ||
| FolderID | int | Default = 0 | ||
| ShareInSiteCopy | bit | Default = 0 | ||
| CanCreateLocalCopy | bit | Default = 0 | ||
| ChangedByCMSUserID | int | yes | ||
| InTrashBin | bit | Default = 0 | ||
| BBSPEnabled | bit | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientSitesID | int | ClientSites.ID | ||
| WorkflowID | int | yes | Workflow.ID | |
| FromModelId | int | yes | SiteContent.ID |
Indexes
| Index Name | Fields | 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 | yes | ||
| PK_Content | ID | yes | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_SiteContent_INSERT_UPDATE | |
| trgDeleteContentFromCompletedComparisonTests |