// @generated automatically by Diesel CLI.

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

diesel::table! {
    budget_updates (id) {
        id -> Integer,
        category_id -> Integer,
        date -> Text,
        new_budget -> Integer,
        new_period -> Integer,
    }
}

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

diesel::table! {
    category_transfers (id) {
        id -> Integer,
        description -> Text,
        quantity -> Integer,
        from_category_id -> Integer,
        to_category_id -> Integer,
    }
}

diesel::table! {
    transaction_categorisations (id) {
        id -> Integer,
        description -> Text,
        quantity -> Integer,
        transaction_id -> Integer,
        category_id -> Integer,
    }
}

diesel::table! {
    transactions (id) {
        id -> Integer,
        description -> Text,
        payee -> Text,
        quantity -> Integer,
        date -> Text,
        account_id -> Integer,
    }
}

diesel::joinable!(budget_updates -> 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_transfers,
    transaction_categorisations,
    transactions,
);