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>
Date: Tue, 28 Nov 2000 16:45:39 +0100
Message-ID: <3A23D323.954CACF_at_capgemini.fr>
Hi,
I have a hierarchy :
and one element of the table B has in relationship with one and only one
element
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 :
one element of a table A has a relationship with 1..n elements of a table B,
of the table 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