From e0d7cd9bbf02e7d52aadfb8d56f774a8a4099adf Mon Sep 17 00:00:00 2001
From: Joe Carstairs <me@joeac.net>
Date: Mon, 9 Sep 2024 21:54:04 +0100
Subject: Improves backend schema

---
 backend/src/schema.rs | 16 +++++++++-------
 1 file changed, 9 insertions(+), 7 deletions(-)

(limited to 'backend/src/schema.rs')

diff --git a/backend/src/schema.rs b/backend/src/schema.rs
index d98a629..942e913 100644
--- a/backend/src/schema.rs
+++ b/backend/src/schema.rs
@@ -29,21 +29,22 @@ diesel::table! {
 }
 
 diesel::table! {
-    category_transactions (id) {
+    category_transfers (id) {
         id -> Integer,
         description -> Text,
         quantity -> Integer,
-        category_id -> Integer,
+        from_category_id -> Integer,
+        to_category_id -> Integer,
     }
 }
 
 diesel::table! {
-    category_transfers (id) {
+    transaction_categorisations (id) {
         id -> Integer,
         description -> Text,
         quantity -> Integer,
-        from_category_id -> Integer,
-        to_category_id -> Integer,
+        transaction_id -> Integer,
+        category_id -> Integer,
     }
 }
 
@@ -58,14 +59,15 @@ diesel::table! {
 }
 
 diesel::joinable!(budget_updates -> categories (category_id));
-diesel::joinable!(category_transactions -> categories (category_id));
+diesel::joinable!(transaction_categorisations -> categories (category_id));
+diesel::joinable!(transaction_categorisations -> transactions (transaction_id));
 diesel::joinable!(transactions -> accounts (account_id));
 
 diesel::allow_tables_to_appear_in_same_query!(
     accounts,
     budget_updates,
     categories,
-    category_transactions,
     category_transfers,
+    transaction_categorisations,
     transactions,
 );
-- 
cgit v1.2.3