diff options
author | Jesse Luehrs <doy@tozt.net> | 2019-08-26 02:01:01 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2019-08-26 02:01:01 -0400 |
commit | 19b020f9917bb154a88cc797ebaefe1c822a883a (patch) | |
tree | 477aa8c6a8b5b5c7702481d9aea02ad3a3a0d973 /data | |
parent | 1321a926fb17f8712d2a32aba045061d9b780ff7 (diff) | |
download | ynab-export-19b020f9917bb154a88cc797ebaefe1c822a883a.tar.gz ynab-export-19b020f9917bb154a88cc797ebaefe1c822a883a.zip |
include the ids
Diffstat (limited to 'data')
-rw-r--r-- | data/schema.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/data/schema.sql b/data/schema.sql index 0977f67..6478769 100644 --- a/data/schema.sql +++ b/data/schema.sql @@ -163,10 +163,15 @@ CREATE VIEW denorm_transactions AS ( cleared, approved, flag_color, + account_id, accounts.name AS account, + payee_id, payees.name AS payee, + category_group_id, category_groups.name AS category_group, + category_id categories.name AS category, + transfer_account_id, transfer_accounts.name AS transfer_account FROM transactions_with_subtransactions LEFT JOIN accounts ON ( @@ -210,10 +215,15 @@ CREATE VIEW denorm_scheduled_transactions AS ( amount / 1000.0 as amount, memo, flag_color, + account_id, accounts.name AS account, + payee_id, payees.name AS payee, + category_group_id, category_groups.name AS category_group, + category_id, categories.name AS category, + transfer_account_id, transfer_accounts.name AS transfer_account FROM scheduled_transactions_with_subtransactions LEFT JOIN accounts ON ( @@ -376,10 +386,15 @@ CREATE VIEW future_transactions AS ( amount, memo, flag_color, + account_id, account, + payee_id, payee, + category_group_id, category_group, + category_id, category, + transfer_account_id, transfer_account FROM denorm_scheduled_transactions @@ -403,10 +418,15 @@ CREATE VIEW future_transactions AS ( amount, memo, flag_color, + account_id, account, + payee_id, payee, + category_group_id, category_group, + category_id, category, + transfer_account_id, transfer_account FROM repeated_transactions |