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
a
row indicating that they can use said project.
-Original Message-
From: Chris Kavanagh [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 9:11 AM
To: [EMAIL PROTECTED]
Subject: A newbie and his first MySQL schema
Dear list,
So I'm having a bit of trouble with my first schema.
- 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&#x
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:
"p
