This table keeps information about referrals, aka, Send a Friend or Referrals.
Primary key: none
Field Name | Description | Version Added |
SenderMemberID_ | The member ID of the originator of the referral. (int, NOT NULL) |
|
SenderEmailAddr_ | The email address the sender provided when initiating the referral, which could be different than the email address in the member record. (varchar(100), NULL) |
|
SenderIPAddress_ | The IP address recorded from the sender at the time of referral. (int, NOT NULL) |
|
ReceiverMemberID_ | The member ID of the 'friend' who should receive this referral. (int, NOT NULL) |
|
ContentID_ | The ID of the content to send as the referral. (int, NOT NULL) |
|
RollupID_ | (int, NOT NULL) |
|
TimeSent_ | The date and time the referral was sent. (smalldatetime, NULL) |
|