Replies To: Database Schema of Multi-level Marketing

Re: Database Schema of Multi-level Marketing

Posted 19 November 2012 - 12:23 AM

Since there is no difference between a member and the people they recruit you only need one table. One column of the table should be the ID of the member who recruited that person. So the top of the pyramid has nothing in that column.

Re: Database Schema of Multi-level Marketing

Posted 21 November 2012 - 12:53 AM

Will you please elaborate? I have made database consisting of tables as follows:

MEMBER
REGISTRATION
COMMISSION
TBL_USER

The table MEMBER is related to REGISTRATION and TBL_USER while REGISTRATION is related to COMMISSION.
Every time there is new recruit, there personal information are saved to table MEMBER while there information about their registration is saved to table REGISTRATION. Every time there is a new recruit, the referror(recruiter) can get a commission that's why there is a COMMISSION table which related to REGISTRATION. TBL_USER is related to MEMBER because a member should have a username and password to open his/her account.

I'm using C#.net in developing this project...Thank you so much for the help