SignupTransactions

Primary Key

Primary Key	Field Type
SignupTransactionsID	int

Fields

Field	Field Type	Null	Notes	Description
ClientsID	int
DateAdded	datetime		Default = getutcdate()
XMLObjectData	ntext
processed_date	datetime	yes
IsDeleted	bit		Default = 0
DateLastChanged	datetime		Default = getutcdate()
SimpleEmailSignup	int	yes

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_SignupTransactions_EmailJobRecipientID	EmailJobRecipientID
IX_SignupTransactions_Processed_Date_ClientID	processed_date, ClientsID
IX_SignupTransactions_UserID	UserID
PK_SignupTransactions	SignupTransactionsID	yes	yes	yes