primary key in a hierarchy

From: Christophe Geraud <cgeraud_at_capgemini.fr>
Date: Tue, 28 Nov 2000 16:45:39 +0100
Message-ID: <3A23D323.954CACF_at_capgemini.fr>


Hi,

I have a hierarchy :
one element of a table A has a relationship with 1..n elements of a table B,

and one element of the table B has in relationship with one and only one element
of the table A.

The table A has a primary key named : ID_A (from a sequence) I know two ways to create the primary key for the table B : 1. ID_B (independant of ID_A)
2. (ID_A, Number)

Is one of the two ways better ?

Thanks for help

Christophe Geraud Received on Tue Nov 28 2000 - 16:45:39 CET

Original text of this message