EventTransactions
Primary Key
| Primary Key | Field Type |
|---|---|
| EventTransactionsID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientEventsID | int | |||
| DateAdded | datetime | Default = getutcdate() | ||
| XMLObjectData | ntext | |||
| processed_date | datetime | yes | ||
| IsDeleted | bit | Default = 0 | ||
| EmailID | int | yes | ||
| GiftAmount | numeric(30, 6) | yes | ||
| GiftPaymentMethod | int | yes | ||
| GiftCurrencyType | int | yes | ||
| TransactionGUID | uniqueidentifier | yes | ||
| Status | tinyint | Default = 1 | ||
| FailureData | nvarchar(max) | yes |
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_EventTransactions_AddedByUserID | AddedByUserID | |||
| IX_EventTransactions_ClientEventsID | ClientEventsID | |||
| IX_EventTransactions_EmailID_IsDeleted | EmailID, IsDeleted | |||
| IX_EventTransactions_EmailJobRecipientID | EmailJobRecipientID | |||
| IX_EventTransactions_Processed_Date | processed_date | |||
| IX_EventTransactions_processed_date_ClientEventsID_IsDeleted | processed_date, ClientEventsID, IsDeleted | |||
| PK_EventTransactions | EventTransactionsID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| EventItemCapacity | EventTransactionsID |
| FundRaiserEventRegistrations | EventTransactionsID |