title: ER Diagram keeps showing One-to-many relationship
body: <p>I just generated a ER Diagram from MySQL workbench using table I'd created before and I encounter some problems.</p>
  
  <p><a href="https://i.stack.imgur.com/u2K4A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/u2K4A.png" alt="diagram"></a></p>
  
  <p>My problem is, the ER Diagram shows only one-to-many relationships. One of those relationship is between <code>bokar</code> table and <code>bokar_detail</code> table using field <code>nomorbokar</code> on each table, which I've marked before (take a look at red spheres).</p>
  
  <p>In fact, the relationship between those two tables is supposed to be one-to-one relationship, because each table can only contain one <code>nomorbokar</code> record, no duplication.</p>
  
  <p>I got that rule by setting <code>nomorbokar</code> field in <code>bokar_detail</code> table as a foreign key, referencing on <code>nomorbokar</code> field in <code>bokar</code> table.</p>
  
  <p>I set the referenced field as unique key (to prevent duplication) and then set the foreign key as primary key (to prevent duplication) which will obviously generate one-to-one relationship.</p>
  
  <p>What's wrong with my ER diagram?</p>