Re: Multiple parent design
From: Laconic2 <laconic2_at_comcast.net>
Date: Fri, 16 Apr 2004 07:55:30 -0400
Message-ID: <64GdnYurVfsYVOLdRVn-sQ_at_comcast.com>
Date: Fri, 16 Apr 2004 07:55:30 -0400
Message-ID: <64GdnYurVfsYVOLdRVn-sQ_at_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