diff options
| author | Joe Carstairs <me@joeac.net> | 2024-12-12 08:28:04 +0000 |
|---|---|---|
| committer | Joe Carstairs <me@joeac.net> | 2024-12-12 08:28:04 +0000 |
| commit | 54894f9de9bad4fecb2a116d59a03cdd003f84c0 (patch) | |
| tree | 6ce5517cecf23d4e93d7a381a374e1fa6c810cee /actualbudget_models/src/actualbudget_schema.rs | |
| parent | 8a30bcbdf9264d235bf93da3df8e170cfde53d02 (diff) | |
Moves rust workspace to root
Diffstat (limited to 'actualbudget_models/src/actualbudget_schema.rs')
| -rw-r--r-- | actualbudget_models/src/actualbudget_schema.rs | 66 |
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, + } +} |
