MySQL Forums
Forum List  »  MySQL Workbench

makes foreign key a primary key
Posted by: Pete Watters
Date: February 19, 2018 12:44PM

I am using workbench and workbench diagrams to link tables

My Parent Table is the Project Table which has a 1 to many relationship
with a project contacts table,

Since I need a 1 to many relationship I creaded a dummy column staff-id as the primary key then using a diagram I created a 1 to many identifying relationship since for a project contact to exist there must be a project associated with the row

When I created the 1 to many relationship in the diagram it created a foreign key
project_project_id but checked it as the primary key

Was this a mistake?

Options: ReplyQuote

Written By
makes foreign key a primary key
February 19, 2018 12:44PM

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.