title: Optimization of the structure and database MySQL
body: <p>I have the following relationships:</p>
  <pre><code>order_products (1 or n) ———————— (1) orders (1) ————————— (1) transactions
      ...                                (1)                         (1)
      price                               |                           |   
      qty                                 |                           |
                                         (1)                         (1)
                                        users                       users
  </code></pre>
  <ol>
  <li>Should I leave 2 relationships to users table as above?</li>
  <li>I intend to show the total order amount or get the transaction amount will query the order_products table. This is better than adding the amount field at 1 of two tables (or both) orders, transactions?.</li>
  </ol>