ok Posted September 1, 2008 Share Posted September 1, 2008 Ok here is the scenario. This is tell a friend contest. People can sign in and just tell their friend as many as they about a particular promo. So for example if Joe tell his friend, anna and josephine. He will have this record below. joe --------- anna josephine Then anna also invite his friend joey, jack, george and karen. now anna have this table below, anna --------- joey jack george karen and vice versa. but anna can't invite joe, since joe invited her already. anyway what is the best Relational Database for this? Thank you! Quote Link to comment Share on other sites More sharing options...
burn1337 Posted September 1, 2008 Share Posted September 1, 2008 I would say something like Although not sure it would work just off the top of my head UserId UserName ReferedUserId ReferedUserName each refered person a new row, or UserId UserName ReferCount ReferenceId ReferedName ReferedId Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.