MYSQL / PHP - Efficient method for attaching users to a project

views:

answers:

MYSQL / PHP - Efficient method for attaching users to a project

I'm building a system that has a user table and a project table. I'm trying to determine the most efficient way to connect users to a project.

I'm was thinking about a table that records the relationship, but I wasn't sure if a serialized list in one field would work just as well.

+1 A:

A join table (e.g. UserJoinProject) would be my preference and would be well normalized. Assuming you have an ID column as a primary key for projects and for users.

Serializing the list will make it difficult for mysql to do any kind of operation on that data.

mopoke 2009-12-29 02:54:59

Okay that makes sense. I just wondered about the size of a db that contains many relationships

Tim 2009-12-29 03:04:39

Size shouldn't be an issue in terms of storage and you're unlikely to save much (if any) by keeping the relationship in one of the other tables.

mopoke 2009-12-29 03:07:42

If it is many to many relationship then you can create another table which just associates project id with a user id.

Srirangan 2009-12-29 02:56:06

Same as mopoke, didn't see his answer as we posted same time. :)

Srirangan 2009-12-29 02:57:48

ansaurus

tags:

views:

answers:

MYSQL / PHP - Efficient method for attaching users to a project

related questions