[CDBI] Sequences with multiple primary keys

Perrin Harkins perrin at elem.com
Fri Jun 16 16:11:33 BST 2006


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?

- Perrin



More information about the ClassDBI mailing list