| Primary Key | Field Type |
|---|---|
 SignupTransactionsID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ClientsID |
int | |||
| DateAdded |
datetime | Default = getutcdate() | ||
| XMLObjectData |
ntext | |||
| processed_date |
datetime |  |
||
| IsDeleted |
bit | Default = 0 | ||
| DateLastChanged |
datetime | Default = getutcdate() |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 UserID |
int | |
ClientUsers.ID | |
| EmailJobRecipientID |
int | |
EmailJob_Recipient.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_SignupTransactions_EmailJobRecipientID |
EmailJobRecipientID | |||
| IX_SignupTransactions_Processed_Date_ClientID |
processed_date, ClientsID | |||
| IX_SignupTransactions_UserID |
UserID | |||
| PK_SignupTransactions |
SignupTransactionsID | |
|
|