fish_lib/
schema.rs

1diesel::table! {
2    fish_users (id) {
3        id -> BigInt,
4        external_id -> BigInt,
5        credits -> BigInt,
6        created_at -> Timestamptz,
7        updated_at -> Timestamptz,
8        timezone -> VarChar
9    }
10}
11
12diesel::table! {
13    fish_user_locations (user_id, location_id) {
14        user_id -> BigInt,
15        location_id -> Integer,
16        unlocked_at -> Timestamptz,
17    }
18}
19
20diesel::table! {
21    fish_specimens (id) {
22        id -> BigInt,
23        user_id -> BigInt,
24        species_id -> Integer,
25        created_at -> Timestamptz,
26        updated_at -> Timestamptz,
27        size_baby_ratio -> Float,
28        size_adult_ratio -> Float,
29        lifespan_days_ratio -> Float,
30        catch_age -> Float
31    }
32}
33
34diesel::table! {
35    fish_ponds (id) {
36        id -> BigInt,
37        user_id -> BigInt,
38        created_at -> Timestamptz,
39        updated_at -> Timestamptz,
40        capacity -> Integer
41    }
42}
43
44diesel::table! {
45    fish_fishing_history_entries (id) {
46        id -> BigInt,
47        user_id -> BigInt,
48        species_id -> Integer,
49        created_at -> Timestamptz,
50        updated_at -> Timestamptz,
51        caught_count -> Integer,
52        sold_count -> Integer,
53        smallest_catch_size_ratio -> Float,
54        largest_catch_size_ratio -> Float,
55        last_catch -> Timestamptz,
56        first_sell -> Nullable<Timestamptz>,
57        last_sell -> Nullable<Timestamptz>,
58    }
59}
60
61diesel::table! {
62    fish_items (id) {
63        id -> BigInt,
64        user_id -> BigInt,
65        type_id -> Integer,
66        properties -> Jsonb,
67        created_at -> Timestamptz,
68        updated_at -> Timestamptz,
69    }
70}
71
72diesel::joinable!(fish_user_locations -> fish_users (user_id));
73diesel::allow_tables_to_appear_in_same_query!(fish_user_locations, fish_users);
74
75diesel::joinable!(fish_specimens -> fish_users (user_id));
76diesel::allow_tables_to_appear_in_same_query!(fish_specimens, fish_users);
77
78diesel::joinable!(fish_ponds -> fish_users (user_id));
79diesel::allow_tables_to_appear_in_same_query!(fish_ponds, fish_users);
80
81diesel::joinable!(fish_fishing_history_entries -> fish_users (user_id));
82diesel::allow_tables_to_appear_in_same_query!(fish_fishing_history_entries, fish_users);
83
84diesel::joinable!(fish_items -> fish_users (user_id));
85diesel::allow_tables_to_appear_in_same_query!(fish_items, fish_users);