MySQL Forums
Forum List  »  MySQL Workbench

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

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
Views
Written By
Posted
Defining referential integrity with alternative tables
2668
April 20, 2009 04:30AM


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.