Re: Sub-Entities

>> If individuals and organizations don't share a parent table what should the DDL for the orders table be? <<

I look to my rule about industry standards and not inventing my own codes and find the Dun & Bradstreeet numbers for customers. I do not care if it is a company or a person as long as they pay on time.

CREATE TABLE Orders
(order_nbr INTEGER NOT NULL PRIMARY KEY
  CHECK ( <<check digit logic>>),
 duns_nbr CHAR(9) NOT NULL

        REFERENCES DunNumbers (duns_nbr)    ON UPDATE CASCADE
   ON DELETE CASCADE,
 ..
) Received on Sun Jul 03 2005 - 18:31:03 CEST