2 Replies - 3954 Views - Last Post: 21 November 2012 - 12:53 AM Rate Topic: -----

#1 jezenie.urbano  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 18-November 12

Database Schema of Multi-level Marketing

Posted 18 November 2012 - 11:16 PM

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.
Is This A Good Question/Topic? 0
  • +

Replies To: Database Schema of Multi-level Marketing

#2 Momerath  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 1012
  • View blog
  • Posts: 2,444
  • Joined: 04-October 09

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.
Was This Post Helpful? 1
  • +
  • -

#3 jezenie.urbano  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 18-November 12

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
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1