From: "Nagasamudram, Prasanna Kumar" Date: 2006-10-17T23:24:46+09:00 Subject: Database schema.... ------_=_NextPart_001_01C6F1F7.F97BAA38 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =20 Hi All =20 This is my first mail to this mailing list. =20 I started using the rails framework for ruby. =20 I was able to understand and create the sample cookbook application. =20 Now I want to try something new. =20 I basically want to write a application which would be similar to orkut. =20 Basically I want to have a database table which will have the information about the registered users. =20 And each user should have the reference to his friends. =20 For example =20 ID NAME Friends 1 Name1 3,4 2 Name2 4 3 Name3 4 4 Name4 1,2 =20 =20 I am not able to deduce on a database schema to achieve this. Should I have another table for friends ? =20 PS: do not reply to this mail, if you think this mail is irrelevant to this mailing list. =20 =20 =20 Thanks Prasanna ------_=_NextPart_001_01C6F1F7.F97BAA38--