My .schema is: CREATE TABLE account (transaction_date text, amount integer, hst integer, subtotal integer, description text, debitcredit integer, category_id i

My .schema is: 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);