```mermaid
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"
```