From 19b020f9917bb154a88cc797ebaefe1c822a883a Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Mon, 26 Aug 2019 02:01:01 -0400 Subject: include the ids --- data/schema.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) 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 -- cgit v1.2.3-54-g00ecf