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 | |
| parent | 1321a926fb17f8712d2a32aba045061d9b780ff7 (diff) | |
| download | ynab-export-19b020f9917bb154a88cc797ebaefe1c822a883a.tar.gz ynab-export-19b020f9917bb154a88cc797ebaefe1c822a883a.zip | |
include the ids
| -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 |