I need to make a simple referral system and I have a database table set out as follows:
mem_id | date | refer_email | accepted
And the meaning of such columns is the following:
mem_id: The member unique identifier who is making the referral.
date: The timestamp value of the request.
refer_email: The contact email address owned by the person being referred.
accepted: A CHAR value of
Nthat indicates if the referred
I am not sure if this is best structure for this kind of scenario. I will be required to tally the
number_of_users referred by each
person mainly, and I expect a few more simple queries on the horizon.