MySQL Forums
Forum List  »  MySQL Workbench

Linking tables with EER
Posted by: Pete Watters
Date: September 17, 2017 01:31PM

Table material
material_id_sys Primary key generated auto increment

Table Prefered_Manufacture
prefered_mfg_id_sys is the primary key which is auto generated and not used
Material_id_fk links to the material table material_id_sys
prefered_mfg_fk is a foreign key linked to the manufactures table primary key

In EER Diagram

I hand created a column for the foreign key but when I linked the Material table and the Prefered manufacture table it create a new column/field for the
table. Should I delete the one I created and clean up the name of the key that was generated

Now I want to link the MANUFACTURE table to the PREFERED_MANUFACTURE table
the manufacture table has one unique id for each manufacture mfg_id_sys
and the PREFERED_MANUFACTURE table will have many manufacture columns with the same ID prefered_mfg_fk

when I pick the ---- 1:n icon

It will let me do a 1 to many prefered_mfg table 1 to the Manufacture table many

but does not let me do
a 1 Manufacture to Many prefered manufacture table

am I getting this wrong, should it me a 1:1

Options: ReplyQuote

Written By
Linking tables with EER
September 17, 2017 01:31PM

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.