RE: A newbie and his first MySQL schema

[Dathan Pattishall]

Don't think of it a column must hold mutiple values (unless your using
Sets or bitmasks) think that this table will hold mutiple rows, and each
person is a row with permissions for each project. So, a basic approach
is forevery authorized project a person is able to see that person has a
row indicating that they can use said project.

 

-----Original Message-----
From: Chris Kavanagh [mailto:chris@stripped] 
Sent: Monday, December 06, 2004 9:11 AM
To: mysql@stripped
Subject: A newbie and his first MySQL schema

Dear list,

So I'm having a bit of trouble with my first schema.  I'm sure I'm
missing something idiotic here, but days of learning MySQL and setting
up servers and working in UNIX have kind of fried my brain.  Okay, here
goes:

My project management system includes (among others) two tables: 
"people" and "projects".  I want each project to have a list of people
that are authorised to view it.  To my mind, the field ought to look a
bit like this:

--
Authorised list:
	Chris Kavanagh
	Joe Schmoe
	Jane Doe
--

But fields can't hold multiple values, can they?  And on my schema, it
seems to be a many-to-many relationship between the two tables, and I
heard that they are the work of the Devil and must be shunned.  I'm sure
I need to make a new table or something, but I'm not really sure which
one.  Can anyone help me?

Many thanks in advance,
CK.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1