Database table structure Guidance

Question

I am trying to build a web application that enables users to refer people to the site. A user can refer up to 10 people to the site and can have up to 7 generations, meaning that each person referred to the system by a referred user will be related to the immediate referrer and the other user that referred the newly registered user’s referrer, up to the seventh level.

The diagram below will help give a view of what I mean.

enter image description here

I'm using SQL Server 2008 for my database.

That picture looks like the beads I have hanging across my kitchen doorway! — tom redfern, Nov 09 '11 at 20:20

score 0 · Accepted Answer · edited May 23 '17 at 12:01

0

This is impossible to answer in general because the answer depends on what kind of queries you plan to run against your data.

But there are many alternatives for how to store hierarchical data in a database. You can start with Implementing a hierarchical data structure in a database.

If that's not enough, Google is your friend

edited May 23 '17 at 12:01

Community

1
1

answered Nov 09 '11 at 20:31

ykaganovich

14,736
8
59
96

Thanks, this is of great help to me. – Syma Nov 10 '11 at 00:08

Database table structure Guidance

1 Answers1