1 files changed, 66 insertions, 0 deletions
diff --git a/actualbudget_models/src/actualbudget_schema.rs b/actualbudget_models/src/actualbudget_schema.rs
new file mode 100644
index 0000000..4e1ba24
--- /dev/null
+++ b/actualbudget_models/src/actualbudget_schema.rs
@@ -0,0 +1,66 @@
+diesel::table! {
+    accounts (id) {
+        id -> Text,
+        name -> Text,
+    }
+}
+
+diesel::table! {
+    categories (id) {
+        id -> Text,
+        name -> Text,
+    }
+}
+
+diesel::table! {
+    v_transactions (id) {
+        id -> Text,
+        is_parent -> Bool,
+        is_child -> Bool,
+        parent_id -> Nullable<Text>,
+        #[sql_name = "account"]
+        account_id -> Text,
+        #[sql_name = "category"]
+        category_id -> Nullable<Text>,
+        amount -> Integer,
+        payee -> Nullable<Text>,
+        notes -> Nullable<Text>,
+        date -> Integer,
+        transfer_id -> Nullable<Text>,
+        // imported_id -> Text,
+        // error -> Text,
+        // imported_payee -> Text,
+        // starting_balance_flag -> Integer,
+        // sort_order -> Real,
+        // cleared -> Integer,
+        // reconciled -> Integer,
+        // tombstone -> Integer,
+        // schedule -> Text,
+    }
+}
+
+diesel::table! {
+    payees (id) {
+        id -> Text,
+        name -> Text,
+        #[sql_name = "transfer_acct"]
+        transfer_account_id -> Nullable<Text>,
+        // category -> Nullable<Text>,
+        // favorite -> Bool,
+        // tombstone -> Integer,
+    }
+}
+
+diesel::table! {
+    zero_budgets (id) {
+        id -> Text,
+        month -> Integer,
+        #[sql_name = "category"]
+        category_id -> Text,
+        amount -> Integer,
+        #[sql_name = "carryover"]
+        do_carry_over -> Bool,
+        // goal -> Integer,
+        // long_goal -> Integer,
+    }
+}