summaryrefslogtreecommitdiff
path: root/backend/core/src/schema.rs
blob: 372f8f300bab44fff3835f4ac0e6b090934820c2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
// @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,
);