terminology q. regarding FK

From: <mh_at_pixar.com>
Date: Mon, 03 Nov 2008 03:50:10 GMT
Message-ID: <SxuPk.5084$as4.908@nlpi069.nbdc.sbc.com>


I'm doing some FK analysis of our tables by making a directed graph representing FK dependencies and then traversing the graph. In my code, I name everything using directed graph terminology, but I'd like to have something a bit more "user friendly" in the report.

In this scenario:

    create table t1(a varchar2(20));
    alter table t1 add constraint t1_fk foreign key(a) references t2(b);

t1.a must exist in t2.b. So,

t1 is the _______ of t2.
t2 is the _______ of t1.

Many TIA!
Mark

-- 
Mark Harrison
Pixar Animation Studios
Received on Sun Nov 02 2008 - 21:50:10 CST

Original text of this message