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