How to specify in which currency the payment was made?

Question

MongoDB

Do you think it would be better to store an additional field in the document indicating the code of the currency in which the payment was made:

{  
  "price": 20.52,
  "cuurency": "USD"
}

Or would it be better to shove it into one field? Are there other smarter options?

Answer 1

Miscellaneous fields
So that you can count without parsing your string '$10' or '10 USD' or '10 bucks' Use standard
currency codes

Answer 2

Options:
Use one currency
Create a separate list of currencies