makes foreign key a primary key
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?
Subject
Views
Written By
Posted
makes foreign key a primary key
669
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.