title: What do I need to keep in a database to record the history of orders?
body: <p>I want to keep customers' order history.</p>
  
  <p>I am thinking of keeping names of product, number of product ordered, price of product, date of order, name, address etc</p>
  
  <p>Table can be order_history and there will be field for id, date, cutomer_id,..</p>
  
  <p>Then a question regarding names and number of products came in my mind.</p>
  
  <p>How should I keep them in the database? </p>
  
  <p>A customer may order more than one product with different numbers.</p>
  
  <p>Should I keep it in one field in array, like {product1, 2, product2, 1, product3,2 etc}</p>
  
  <p>Or should I keep name and number separately?</p>
  
  <p>Or any other way?</p>
  
  <p>What is the common practice?</p>
  
  <p>Can you suggest an appropriate database structure, please?</p>