Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Multiple parent design

Re: Multiple parent design

From: Laconic2 <laconic2_at_comcast.net>
Date: Fri, 16 Apr 2004 07:55:30 -0400
Message-ID: <64GdnYurVfsYVOLdRVn-sQ@comcast.com>


Create two columns in the phone table, Person_id and Company_id. Enforce referential integrity on each one separately. Allow each one to be NULL.

If necessary, enforce a constraint that either Person_id or Company_id must be null. Received on Fri Apr 16 2004 - 06:55:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US