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