retrom_db/
schema.rs

1// @generated automatically by Diesel CLI.
2
3diesel::table! {
4    clients (id) {
5        id -> Int4,
6        name -> Text,
7        created_at -> Nullable<Timestamptz>,
8        updated_at -> Nullable<Timestamptz>,
9    }
10}
11
12diesel::table! {
13    default_emulator_profiles (platform_id, client_id) {
14        platform_id -> Int4,
15        emulator_profile_id -> Int4,
16        created_at -> Nullable<Timestamptz>,
17        updated_at -> Nullable<Timestamptz>,
18        client_id -> Int4,
19    }
20}
21
22diesel::table! {
23    emulator_profiles (id) {
24        id -> Int4,
25        emulator_id -> Int4,
26        name -> Text,
27        supported_extensions -> Array<Text>,
28        custom_args -> Array<Text>,
29        created_at -> Nullable<Timestamptz>,
30        updated_at -> Nullable<Timestamptz>,
31        built_in -> Bool,
32    }
33}
34
35diesel::table! {
36    emulators (id) {
37        id -> Int4,
38        supported_platforms -> Array<Int4>,
39        name -> Text,
40        save_strategy -> Int4,
41        created_at -> Nullable<Timestamptz>,
42        updated_at -> Nullable<Timestamptz>,
43        built_in -> Bool,
44        libretro_name -> Nullable<Text>,
45        operating_systems -> Array<Int4>,
46    }
47}
48
49diesel::table! {
50    game_files (id) {
51        id -> Int4,
52        byte_size -> Int8,
53        path -> Text,
54        game_id -> Int4,
55        created_at -> Nullable<Timestamptz>,
56        updated_at -> Nullable<Timestamptz>,
57        deleted_at -> Nullable<Timestamptz>,
58        is_deleted -> Bool,
59    }
60}
61
62diesel::table! {
63    game_genre_maps (game_id, genre_id) {
64        game_id -> Int4,
65        genre_id -> Int4,
66        created_at -> Nullable<Timestamptz>,
67        updated_at -> Nullable<Timestamptz>,
68    }
69}
70
71diesel::table! {
72    game_genres (id) {
73        id -> Int4,
74        slug -> Text,
75        name -> Text,
76        created_at -> Nullable<Timestamptz>,
77        updated_at -> Nullable<Timestamptz>,
78    }
79}
80
81diesel::table! {
82    game_metadata (game_id) {
83        game_id -> Int4,
84        name -> Nullable<Text>,
85        description -> Nullable<Text>,
86        cover_url -> Nullable<Text>,
87        background_url -> Nullable<Text>,
88        icon_url -> Nullable<Text>,
89        igdb_id -> Nullable<Int8>,
90        created_at -> Nullable<Timestamptz>,
91        updated_at -> Nullable<Timestamptz>,
92        links -> Array<Text>,
93        video_urls -> Array<Text>,
94        screenshot_urls -> Array<Text>,
95        artwork_urls -> Array<Text>,
96        release_date -> Nullable<Timestamptz>,
97        last_played -> Nullable<Timestamptz>,
98        minutes_played -> Nullable<Int4>,
99    }
100}
101
102diesel::table! {
103    games (id) {
104        id -> Int4,
105        path -> Text,
106        platform_id -> Nullable<Int4>,
107        created_at -> Nullable<Timestamptz>,
108        updated_at -> Nullable<Timestamptz>,
109        deleted_at -> Nullable<Timestamptz>,
110        is_deleted -> Bool,
111        default_file_id -> Nullable<Int4>,
112        storage_type -> Int4,
113        third_party -> Bool,
114        steam_app_id -> Nullable<Int8>,
115    }
116}
117
118diesel::table! {
119    local_emulator_configs (id) {
120        id -> Int4,
121        emulator_id -> Int4,
122        client_id -> Int4,
123        created_at -> Nullable<Timestamptz>,
124        updated_at -> Nullable<Timestamptz>,
125        executable_path -> Text,
126        nickname -> Nullable<Text>,
127    }
128}
129
130diesel::table! {
131    platform_metadata (platform_id) {
132        platform_id -> Int4,
133        name -> Nullable<Text>,
134        description -> Nullable<Text>,
135        background_url -> Nullable<Text>,
136        logo_url -> Nullable<Text>,
137        igdb_id -> Nullable<Int8>,
138        created_at -> Nullable<Timestamptz>,
139        updated_at -> Nullable<Timestamptz>,
140    }
141}
142
143diesel::table! {
144    platforms (id) {
145        id -> Int4,
146        path -> Text,
147        created_at -> Nullable<Timestamptz>,
148        updated_at -> Nullable<Timestamptz>,
149        deleted_at -> Nullable<Timestamptz>,
150        is_deleted -> Bool,
151        third_party -> Bool,
152    }
153}
154
155diesel::table! {
156    similar_game_maps (game_id, similar_game_id) {
157        game_id -> Int4,
158        similar_game_id -> Int4,
159        created_at -> Nullable<Timestamptz>,
160        updated_at -> Nullable<Timestamptz>,
161    }
162}
163
164diesel::joinable!(default_emulator_profiles -> clients (client_id));
165diesel::joinable!(default_emulator_profiles -> emulator_profiles (emulator_profile_id));
166diesel::joinable!(default_emulator_profiles -> platforms (platform_id));
167diesel::joinable!(emulator_profiles -> emulators (emulator_id));
168diesel::joinable!(game_genre_maps -> game_genres (genre_id));
169diesel::joinable!(game_genre_maps -> games (game_id));
170diesel::joinable!(game_metadata -> games (game_id));
171diesel::joinable!(games -> platforms (platform_id));
172diesel::joinable!(local_emulator_configs -> clients (client_id));
173diesel::joinable!(local_emulator_configs -> emulators (emulator_id));
174diesel::joinable!(platform_metadata -> platforms (platform_id));
175
176diesel::allow_tables_to_appear_in_same_query!(
177    clients,
178    default_emulator_profiles,
179    emulator_profiles,
180    emulators,
181    game_files,
182    game_genre_maps,
183    game_genres,
184    game_metadata,
185    games,
186    local_emulator_configs,
187    platform_metadata,
188    platforms,
189    similar_game_maps,
190);
retrom_db/schema.rs

retrom_db/
schema.rs
