VolunteerTransactions

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
VolunteerOpID	int
DateAdded	datetime		Default = getutcdate()
XMLObjectData	ntext
ProcessedDate	datetime	yes
IsDeleted	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
AddedBy	int	yes	ClientUsers.ID
EmailJobRecipientID	int	yes	EmailJob_Recipient.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_VolunteerTransactions_EmailJobRecipientID	EmailJobRecipientID
PK_VolunteerTransactions	ID	yes	yes	yes