title: Which one is the best database design for supporting multi-currency money values?
body: <p>I want to know the best database design for storing multi-currency money values in database.
  For example I have one Entity that has two money fields. These fields may have different currency types for each record.</p>
  
  <p>Example:</p>
  
  <pre><code>Table A:
  -------------
  Id
  Name
  Amount1
  Amount2
  </code></pre>
  
  <p>Sample records:</p>
  
  <pre><code>Id  Name    Amount1 Amount2
  1   aaa     12$     15£
  2   bbb     30€     17$
  </code></pre>
  
  <p>I cannot store values in one currency. For example I want to lend somebody money. I store its data in a table. The type of money can be different. When I lend someone 10€ I should take back 10€ and I cannot store all values in one currency like dollar.</p>
  
  <p>I want to know what the best and more efficient design for storing these values in database is.
  Should I store amount and currency sign in one column with string data type or it is better to define <code>Money</code> and <code>Currency</code> tables as separate tables for storing money values?
  Or any other design?</p>