title: Accounting Database - storing credit and debit?
body: <p>When you store a transaction into a database</p>
  
  <p>1) Do you store Credit and debit in the same record under two different columns? (without the positive or the negative sign)</p>
  
  <p>Example 1A</p>
  
  <pre><code>TABLENAME
  ...
  ...
  (Credit) null
  (Debit) 100
  </code></pre>
  
  <p>Example 1B</p>
  
  <pre><code>TABLENAME
  ...
  ...
  (Credit) 250
  (Debit) null
  </code></pre>
  
  <p>Or </p>
  
  <p>2) Do you store 1 value with a positive for credit, and a negative sign for debit?</p>
  
  <p>Example 2A</p>
  
  <pre><code>TABLENAME
  ...
  ...
  (Amount) -100
  </code></pre>
  
  <p>Example 2B</p>
  
  <pre><code>TABLENAME
  ...
  ...
  (Amount) 250
  </code></pre>