Improves backend schema

1 files changed, 9 insertions, 7 deletions

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,
 );