SiteLayouts
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(255) | |||
| Description | nvarchar(255) | |||
| Content | ntext | yes | ||
| Guid | uniqueidentifier | yes | Default = (newid()) | |
| OwnerID | int | yes | ||
| Deleted | bit | Default = 0 | ||
| Stylesheet | ntext | yes | ||
| StyleSheetID | int | yes | ||
| DocType | int | yes | Default = 0 | |
| CreateDate | datetime | yes | ||
| CopySourceID | int | yes | ||
| CopyBatchGUID | uniqueidentifier | yes | ||
| UpdateDate | datetime | Default = getutcdate() |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientSitesID | int | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_SiteLayouts_ClientSitesID | ClientSitesID | |||
| IX_SiteLayouts_GUID_OwnerID_Deleted | Guid, OwnerID, Deleted | |||
| IX_SiteLayouts | ClientSitesID, Name | yes | ||
| PK_Templates | ID | yes | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_SITELAYOUTS_UPDATE |
Referenced by
| Referenced by | Field |
|---|---|
| CMSTEMPLATELAYOUT | SITELAYOUTSID |