Summary of the "referrals_" fields in ListManager

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)