DESC firefly.category_transaction_journal;


0:"id"
1:"category_id"
2:"transaction_journal_id"

firefly.transaction_journals

0:Array[20]
0:"id"
1:"created_at"
2:"updated_at"
3:"deleted_at"
4:"user_id"
5:"user_group_id"
6:"transaction_type_id"
7:"transaction_group_id"
8:"bill_id"
9:"transaction_currency_id"
10:"description"
11:"date"
12:"date_tz"
13:"interest_date"
14:"book_date"
15:"process_date"
16:"order"
17:"tag_count"
18:"encrypted"
19:"completed"

DESC firefly.transactions;

values:Array[6]
0:Array[18]
0:"id"
1:"created_at"
2:"updated_at"
3:"deleted_at"
4:"reconciled"
5:"account_id"
6:"transaction_journal_id"
7:"description"
8:"transaction_currency_id"
9:"amount"
10:"balance_before"
11:"balance_after"
12:"balance_dirty"
13:"foreign_amount"
14:"foreign_currency_id"
15:"identifier"
16:"native_amount"
17:"native_foreign_amount"

firefly.categories

values:Array[6]
0:Array[8]
0:"id"
1:"created_at"
2:"updated_at"
3:"deleted_at"
4:"user_id"
5:"user_group_id"
6:"name"
7:"encrypted"


firefly.accounts

values:Array[6]
0:Array[14]
0:"id"
1:"created_at"
2:"updated_at"
3:"deleted_at"
4:"user_id"
5:"user_group_id"
6:"account_type_id"
7:"name"
8:"virtual_balance"
9:"iban"
10:"active"
11:"encrypted"
12:"order"
13:"native_virtual_balance"