MySQL Forums
Forum List  »  Newbie

Defining referential integrity with alternative tables
Posted by: tomas bar
Date: April 20, 2009 04:31AM

Hi,

Is it possible to define a relationsip between a table and a number of alternative tables?
For instance if you have a table PEOPLE and one of the fields is VEHICLE_OWNED.The value of this field can be the primary key of either table CARS or table BICYCLES or table BOATS.
Is this design conceptually sound and how can this kind of referential integrity be defined? do you need triggers?

Thanks a lot.

Options: ReplyQuote


Subject
Written By
Posted
Defining referential integrity with alternative tables
April 20, 2009 04:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.