diesel::table! {
    accounts (id) {
        id -> Text,
        name -> Text,
    }
}

diesel::table! {
    categories (id) {
        id -> Text,
        #[sql_name = "cat_group"]
        group_id -> Nullable<Text>,
        name -> Text,
    }
}

diesel::table! {
    category_groups (id) {
        id -> Text,
        name -> Nullable<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>,
        starting_balance_flag -> Integer,
        // imported_id -> Text,
        // error -> Text,
        // imported_payee -> Text,
        // 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,
    }
}