title: Are multiples foreign keys necessary?
body: <p>I have Table A, this table has 3 foreign keys (id_tableA1, id_tableA2, id_tableA3).</p>
  
  <p>I need a table that has a foreign key from Table A. I´m modeling in MySQL Workbench and the same program creates the structure below:</p>
  
  <p><strong>Table B</strong></p>
  
  <ul>
  <li>tableB_id (pk)</li>
  <li>tableA_id (fk)</li>
  <li>tableA1_id (fk)</li>
  <li>tableA2_id (fk)</li>
  <li>tableA3_id(fk)</li>
  </ul>
  
  <p>Is this really necessary?  Using tableA_id isn't enough? And then (if I decide to be necessary) retrieve data from tableA1, tableA2 and tableA3?</p>
  
  <p>If you guys had the same question solved, please let me now the url for that.  English is not my primary language and I had trouble searching.</p>