Database schema for social network members table

Database schema for social network members table

El Forum
Guest

10-16-2009, 07:41 AM

[eluser]jedd[/eluser]
What have you got so far?

I'm guessing:

person
id
name (various fields)
email
join_date
etc

friend
id
person1_id // fk to person.id
person2_id // fk to person.id
created_when
pending // boolean

- for starters.

What are you getting stuck on?

Messages In This Thread

Database schema for social network members table - by El Forum - 10-16-2009, 07:32 AM

Database schema for social network members table - by El Forum - 10-16-2009, 07:41 AM

Database schema for social network members table - by El Forum - 10-19-2009, 05:43 PM

Database schema for social network members table - by El Forum - 10-19-2009, 07:26 PM

Database schema for social network members table - by El Forum - 10-19-2009, 08:09 PM

Database schema for social network members table - by El Forum - 10-19-2009, 08:16 PM

Database schema for social network members table - by El Forum - 10-19-2009, 08:25 PM

Database schema for social network members table - by El Forum - 10-19-2009, 09:00 PM