title: Why does MySQL Workbench automatically create multiple keys when creating relationships between tables?
body: <p>Check out the image below. In the <code>movie_custom</code> table you'll see that when I added a 1:m relationship between <code>plist_field</code> and <code>movie_custom</code>, MySQL Workbench added keys for the attached tables of <code>plist_type</code> and <code>plist_view_type</code> in additional to the key I was expecting.</p>
  
  <p>Why is that? </p>
  
  <p>Can/should I remove them? </p>
  
  <p>Or if I should keep them, how do I auto-insert the key values from the deeper tables when doing an insert into <code>movie_custom</code> and I know a key of <code>plist_field</code>?</p>
  
  <p><a href="https://i.stack.imgur.com/Tn4dG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tn4dG.png" alt="enter image description here"></a></p>