Re: Using FKs to non PK unique-indexes

From: <before.the.gods_at_gmail.com>
Date: 11 Feb 2006 08:21:04 -0800
Message-ID: <1139674864.573235.94660_at_g14g2000cwa.googlegroups.com>

Hello Brian

Consider the following data

CLIENTS
client1
client2

PRODUCTS
product1
product2

CLIENTS_PRODUCTS
clientproduct1 client1 product1
clientproduct2 client2 product2

ORDERS
order1 client1

ORDERS_PRODUCTS
orderproduct1 order1 clientproduct2

It is exactly the situation I want to avoid. In ORDERS_PRODUCTS, I got a pair of client/product that does not belong to the client that placed order1. The integrity plan you proposed failed to discard this situation

BTG Received on Sat Feb 11 2006 - 17:21:04 CET

This message: [ Message body ]
Next message: -CELKO-: "Re: OT - Best way to handle dbdebunk"
Previous message: Tony Rogerson: "Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec"
In reply to: Brian Selzer: "Re: Using FKs to non PK unique-indexes"
Next in thread: Tony Rogerson: "Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec"
Reply: Brian Selzer: "Re: Using FKs to non PK unique-indexes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message