Rhino wrote:
The primary key for the intersection table is the COMBINATION of EmpID
and
ProjID! Neither column by itself would make sense as the primary key
of the
table; the EmpID and ProjID need to be combined to form the primary
key. It
is now possible to store as many projects for an employe
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 indica
- Original Message -
From: "Chris Kavanagh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 06, 2004 12:11 PM
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 h
