1 files changed, 47 insertions, 0 deletions
diff --git a/backend/actualbudget_importer/src/schema.rs b/backend/actualbudget_importer/src/schema.rs
new file mode 100644
index 0000000..a872231
--- /dev/null
+++ b/backend/actualbudget_importer/src/schema.rs
@@ -0,0 +1,47 @@
+diesel::table! {
+    accounts (id) {
+        id -> Text,
+        name -> Text,
+    }
+}
+
+diesel::table! {
+    categories (id) {
+        id -> Text,
+        name -> Text,
+    }
+}
+
+diesel::table! {
+    transactions (id) {
+        id -> Text,
+        #[sql_name = "isParent"]
+        is_parent -> Bool,
+        #[sql_name = "isChild"]
+        is_child -> Bool,
+        #[sql_name = "acct"]
+        account_id -> Text,
+        #[sql_name = "category"]
+        category_id -> Text,
+        amount -> Integer,
+        #[sql_name = "description"]
+        payee -> Text,
+        notes -> Text,
+        date -> Integer,
+        parent_id -> Nullable<Text>,
+    }
+}
+
+diesel::table! {
+    zero_budgets (id) {
+        id -> Text,
+        month -> Integer,
+        #[sql_name = "category"]
+        category_id -> Text,
+        amount -> Integer,
+        #[sql_name = "carryover"]
+        do_carry_over -> Integer,
+        // goal -> Integer,
+        // long_goal -> Integer,
+    }
+}