--- Ryan <pgsql-sql@seahat.com> wrote:
> This is largely related to cross referencing part numbers
Why not
table master_part( part_id int primary key, part_no not null unique, ... );
table vendor( vendor_no primary key, ... );
table vendor_part( part_id int primary key default(seq), vendor_no references vendor, master_part references
master_part(part_id ), vendor_part, constraint unique( vendor_no, vendor_part ), ... );
Everything here is nice and normal (use part_id to avoid compound
primary keys). Then use views for all cross referencing.
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com