Summary of the "referrals_" fields in ListManager
This table keeps information about referrals, aka, Send a Friend or Referrals.
Primary key: none
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) |