[CDBI] Sequences with multiple primary keys
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?
More information about the ClassDBI