ECardTemplate
Primary Key
| Primary Key |
Field Type |
| ID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| Name |
nvarchar(256) |
|
|
|
| Caption |
nvarchar(255) |
|
|
|
| SubjectLine |
nvarchar(255) |
|
Default = '' |
|
| Type |
int |
|
Default = 0 |
|
| PreviewImage |
image |
|
|
|
| PreviewImageType |
nvarchar(50) |
|
|
|
| PreviewImageModified |
datetime |
|
Default = getutcdate() |
|
| Deleted |
bit |
|
Default = 0 |
|
| HtmlContent |
ntext |
|
|
|
| IsSample |
bit |
|
Default = 0 |
|
| OwnerID |
int |
|
|
|
| COPYSOURCEID |
int |
yes |
|
|
| COPYBATCHGUID |
uniqueidentifier |
yes |
|
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| ClientSitesID |
int |
|
ClientSites.ID
|
|
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| PK_ECardTemplate |
ID |
yes |
yes |
|
| UIX_ECardTemplate_Name |
ClientSitesID, Name |
yes |
|
|
Referenced by