[jezenie.urbano]

What should be the database schema for multi-level marketing which a member can create up to 7 accounts only.

The member can also get a commission on every referral and pairing he/she gets.

Maximum pairing per day is 16 only or until 4th level.

[Momerath]

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.

[jezenie.urbano]

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