Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Representing networked people
08-05-2005, 08:07 AM #1
- Join Date
- Jun 2004
- Los Angeles, CA
- Thanked 0 Times in 0 Posts
Representing networked people
I'm trying to design a system for my work where different admins can add people connected to them. At the bare bones, this is just like a social networking site like Friendster.
From a database perspective, how do you implement a representation of people being linked to a variable number of other people. I was originally thinking to use some kind of variable array attribute in the person table. The only option is SET but that only allows for 64 items. Are there any efficient and flexible ways to implement this "social networking" structure?
08-05-2005, 10:43 PM #2
a classic many-to-many data realtionship: two tables
a table that stores the users
a table that links users together
the link table would look something like:
link_id (INT) PK
the user1 and user2 fields relate to the PK from the users table.