title: How to define some tables in SQLite
body: <p>I am trying to make a database to manage expenses between people. I want a table where I can save how many euros has spend every person.</p>
  
  <p>I have a table called people which only have two columns, _id and name.</p>
  
  <p>Then I am trying to create a table with _id, total amount and save how many euros has spend everyone. I was thinking in made a column for each person with his _id and put how many euros has spend, but I don't know how to do it.</p>
  
  <p>For example:</p>
  
  <p><img src="https://i.stack.imgur.com/zB3Gn.png" alt="Example1"></p>
  
  <p>Or maybe I could use some columns to store the id and the amount, like this:
  (it is the same example)</p>
  
  <p><img src="https://i.stack.imgur.com/JgCrH.png" alt="example2"></p>
  
  <p>Thank you in advance!</p>