ProfileUpdateTransactions
Primary Key
| Primary Key | Field Type |
|---|---|
| ProfileUpdateTransactionsID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientsID | int | |||
| DateLastChanged | datetime | Default = getutcdate() | ||
| XMLObjectData | ntext | |||
| processed_date | datetime | yes | ||
| BackOfficeID | int | yes | ||
| IsDeleted | bit | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| AddedByUserID | int | yes | ClientUsers.ID | |
| EmailJobRecipientID | int | yes | EmailJob_Recipient.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ProfileTransactions_EmailJobRecipientID | EmailJobRecipientID | |||
| IX_ProfileUpdateTransactions_AddedByUserID | AddedByUserID | |||
| IX_ProfileUpdateTransactions_BackOfficeID | BackOfficeID | |||
| IX_ProfileUpdateTransactions_Processed_date_ClientsID_Backofficeid | processed_date, ClientsID, BackOfficeID | |||
| PK_ProfileUpdateTransactions | ProfileUpdateTransactionsID | yes | yes | yes |