From: Date: December 7 2004 6:09pm
Subject: Re: A newbie and his first MySQL schema
List-Archive: http://lists.mysql.com/mysql/176999
Message-Id: <BD712122-4872-11D9-8933-000393971BD0@logorocks.com>
MIME-Version: 1.0 (Apple Message framework v619)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Content-Transfer-Encoding: 7bit

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 employee as you like 
> but no
> way to say that Employee 1 is on Project B *twice*. That's exactly 
> what you
> want.

This info was just what I needed.  Followup question: do I need to 
somehow tell MySQL that this combination is the primary key?

Kind regards,
CK.