CoinX DataBase Relations

erDiagram
  Transactions {
    text id PK
    date transaction_time "transaction time"
    real amount "Money for the transaction"
    text type "Income or Expense"
    text note "Any Note to associate a transaction"
  }
  
  Category {
    text id PK
    text name "Category Name"
    text color "Color for a Category"
    text type  "Income or Expense"
  }
  
  Transactions ||--|{ Category : "Belongs To"