MySQL Forums
Forum List  »  MySQL Workbench

1:n Identifying keys
Posted by: Pete Watters
Date: October 12, 2017 11:46AM

I have a series of tables that are an inverted tree in the example Project is the start. When I link the table in a Model Diagram it appears to add the key to the higher table (one it links to) placed in the table that has the many side of the relationship.

For example, in the tables listed below the DROPS table will have its own key as part of a compound key where the Project, Residence, Rooms, Walls primary keys are added.
Is this correct?
are the individual fields of the Compound Primary key accesable??

Project
Residence
Rooms
Walls
Drops

Options: ReplyQuote


Subject
Views
Written By
Posted
1:n Identifying keys
42
October 12, 2017 11:46AM


Sorry, only registered users may post in this forum.

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.