| Primary Key | Field Type |
|---|---|
 CapWizTransactionsID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ClientsID |
int | |||
| DateLastChanged |
datetime | Default = getutcdate() | ||
| XMLObjectData |
ntext | |||
| ProcessedDate |
datetime |  |
||
| IsDeleted |
bit | Default = 0 | ||
| EmailJobRecipientID |
int | |
||
| EmailID |
int | |
||
| AlertTitle |
nvarchar(510) | |
||
| CapWizActionID |
int | |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 AddedByUserID |
int | |
ClientUsers.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_CapwizTransactions_CapWizActionID |
CapWizActionID | |||
| IX_CapWizTransactions_EmailID_IsDeleted |
EmailID, IsDeleted | |||
| IX_CapWizTransactions_ProcessedDate_ClientsID |
ProcessedDate, ClientsID | |||
| PK_CapWizTransactions |
CapWizTransactionsID | |
|
|