[CDBI] Sequences with multiple primary keys

Andrew Gianni agianni at buffalo.edu
Fri Jun 16 16:18:05 BST 2006


On 6/16/06 11:11 AM, "Perrin Harkins" <perrin at elem.com> wrote:

> Andrew Gianni wrote:
>> The one-to-many tables off of that table have at least two
>> primary keys: the foreign key from the main table as well as a unique id for
>> that table, which also comes from a sequence specific to that table.
> 
> May I ask why?  I can't see a reason to include the foreign key in this
> table's primary key if it already has a unique ID.  Maybe what you want
> there is a unique constraint instead?

Ask our database architect, I can't pretend to understand either, but it's
what I have to work with :P

Andrew




More information about the ClassDBI mailing list