Database Answers Belonging thru Networking
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for My Facebook App Invitations 
Back to the Data Model
Subject: Facebook / Spocial Networking Plug-Ins

I want to create a database where i'm confused to know how to arrange my data and user's information. 

It is a facebook App and i think the database will be hierarchy type. 

The idea behind the App is that a user(i'm) has lots of friends and i invite my friends for like my App and 
if my friend accept my request then i got max points (5) then if my friend send to his friends and if they 
accept request or like this then i (first user) got 3 points and my friend who invite him gets 5 points and 
if his friend of friend invites and accepting their request then he got 5 then his friend 3 and mine point 
will be 1. 

After this when lastly 5 points friend invites other friend then he got 5 and his friend 3 and his friend 3 
and his friend 1 point.

As the hierarchy increases and makes a tree and i (first user) got zero point and will be out from this 
hierarchy and the remaining chain will be continue. So any idea plz to arrange that kind of info....

A. The Things of Interest are :-
A.1 Friends
A.2 Points
A.3 Invitations 
A.4 Requests
A.5 Others to be determined

B. How are they related ?
   B.1 To be determined

Barry Williams 

August 27th. 2011
Principal Consultant
Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map