MySQL Forums
Forum List  »  Newbie

Re: Foreign Key question
Posted by: Phillip Ward
Date: September 21, 2017 04:11AM

A single foreign key can only point to a single parent table (AFAIK).

However, you can have multiple foreign keys each pointing to a different parent table.

For example, a Car might have foreign keys to Model, Engine Specification and Paint colour.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
September 16, 2017 02:52PM
September 16, 2017 03:49PM
September 20, 2017 11:46AM
September 20, 2017 12:44PM
Re: Foreign Key question
September 21, 2017 04:11AM
September 22, 2017 08:45AM
September 20, 2017 12:35PM


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.