CREATE TABLE account (transaction_date text, amount integer, hst integer, subtotal integer, description text, debitcredit integer, category_id integer, account_id integer, business_percent integer, notes text);

CREATE TABLE category(category_id int, name text);