You are here: ListManager Programmer's Guide > ListManager Tables > Referrals > referrals_
 

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)

 

   

Lyris, Inc.

6401 Hollis Street., # 125

Emeryville, CA 94608



Customer Support:

1-888-LYRIS-CS (1-888-597-4727)

or

1-571-730-5259



Hours:

Monday through Friday

6:00 a.m.--6:00 p.m. PST

Self-Serve Portal:

http://www.lyris.com/customer-service/contact-support/