1 CREATE TABLE xonstat.player_game_stats
3 player_game_stat_id bigserial NOT NULL,
4 player_id integer NOT NULL,
5 game_id bigint NOT NULL,
6 nick character varying(128),
7 stripped_nick character varying(128),
23 carrier_frags integer,
28 scoreboardpos integer,
32 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
33 CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id),
34 CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id)
35 REFERENCES xonstat.players (player_id) MATCH SIMPLE
36 ON UPDATE NO ACTION ON DELETE NO ACTION,
37 CONSTRAINT player_game_stats_fk002 FOREIGN KEY (game_id)
38 REFERENCES xonstat.games (game_id) MATCH SIMPLE
39 ON UPDATE NO ACTION ON DELETE NO ACTION
45 CREATE INDEX player_game_stats_ix01 on player_game_stats(create_dt);
46 CREATE INDEX player_game_stats_ix02 on player_game_stats(game_id);
47 CREATE INDEX player_game_stats_ix03 on player_game_stats(player_id);
48 ALTER TABLE xonstat.player_game_stats OWNER TO xonstat;
50 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q1 (
51 CHECK ( create_dt >= DATE '2014-01-01' AND create_dt < DATE '2014-04-01' )
52 ) INHERITS (player_game_stats);
54 CREATE INDEX player_game_stats_2014q1_ix001 on player_game_stats_2014q1(create_dt);
55 CREATE INDEX player_game_stats_2014q1_ix002 on player_game_stats_2014q1(game_id);
56 CREATE INDEX player_game_stats_2014q1_ix003 on player_game_stats_2014q1(player_id);
58 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q2 (
59 CHECK ( create_dt >= DATE '2014-04-01' AND create_dt < DATE '2014-07-01' )
60 ) INHERITS (player_game_stats);
62 CREATE INDEX player_game_stats_2014q2_ix001 on player_game_stats_2014q2(create_dt);
63 CREATE INDEX player_game_stats_2014q2_ix002 on player_game_stats_2014q2(game_id);
64 CREATE INDEX player_game_stats_2014q2_ix003 on player_game_stats_2014q2(player_id);
66 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q3 (
67 CHECK ( create_dt >= DATE '2014-07-01' AND create_dt < DATE '2014-10-01' )
68 ) INHERITS (player_game_stats);
70 CREATE INDEX player_game_stats_2014q3_ix001 on player_game_stats_2014q3(create_dt);
71 CREATE INDEX player_game_stats_2014q3_ix002 on player_game_stats_2014q3(game_id);
72 CREATE INDEX player_game_stats_2014q3_ix003 on player_game_stats_2014q3(player_id);
74 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q4 (
75 CHECK ( create_dt >= DATE '2014-10-01' AND create_dt < DATE '2015-01-01' )
76 ) INHERITS (player_game_stats);
78 CREATE INDEX player_game_stats_2014q4_ix001 on player_game_stats_2014q4(create_dt);
79 CREATE INDEX player_game_stats_2014q4_ix002 on player_game_stats_2014q4(game_id);
80 CREATE INDEX player_game_stats_2014q4_ix003 on player_game_stats_2014q4(player_id);
82 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q1 (
83 CHECK ( create_dt >= DATE '2015-01-01' AND create_dt < DATE '2015-04-01' )
84 ) INHERITS (player_game_stats);
86 CREATE INDEX player_game_stats_2015q1_ix001 on player_game_stats_2015q1(create_dt);
87 CREATE INDEX player_game_stats_2015q1_ix002 on player_game_stats_2015q1(game_id);
88 CREATE INDEX player_game_stats_2015q1_ix003 on player_game_stats_2015q1(player_id);
90 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q2 (
91 CHECK ( create_dt >= DATE '2015-04-01' AND create_dt < DATE '2015-07-01' )
92 ) INHERITS (player_game_stats);
94 CREATE INDEX player_game_stats_2015q2_ix001 on player_game_stats_2015q2(create_dt);
95 CREATE INDEX player_game_stats_2015q2_ix002 on player_game_stats_2015q2(game_id);
96 CREATE INDEX player_game_stats_2015q2_ix003 on player_game_stats_2015q2(player_id);
98 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q3 (
99 CHECK ( create_dt >= DATE '2015-07-01' AND create_dt < DATE '2015-10-01' )
100 ) INHERITS (player_game_stats);
102 CREATE INDEX player_game_stats_2015q3_ix001 on player_game_stats_2015q3(create_dt);
103 CREATE INDEX player_game_stats_2015q3_ix002 on player_game_stats_2015q3(game_id);
104 CREATE INDEX player_game_stats_2015q3_ix003 on player_game_stats_2015q3(player_id);
106 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q4 (
107 CHECK ( create_dt >= DATE '2015-10-01' AND create_dt < DATE '2016-01-01' )
108 ) INHERITS (player_game_stats);
110 CREATE INDEX player_game_stats_2015q4_ix001 on player_game_stats_2015q4(create_dt);
111 CREATE INDEX player_game_stats_2015q4_ix002 on player_game_stats_2015q4(game_id);
112 CREATE INDEX player_game_stats_2015q4_ix003 on player_game_stats_2015q4(player_id);
114 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q1 (
115 CHECK ( create_dt >= DATE '2016-01-01' AND create_dt < DATE '2016-04-01' )
116 ) INHERITS (player_game_stats);
118 CREATE INDEX player_game_stats_2016q1_ix001 on player_game_stats_2016q1(create_dt);
119 CREATE INDEX player_game_stats_2016q1_ix002 on player_game_stats_2016q1(game_id);
120 CREATE INDEX player_game_stats_2016q1_ix003 on player_game_stats_2016q1(player_id);
122 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q2 (
123 CHECK ( create_dt >= DATE '2016-04-01' AND create_dt < DATE '2016-07-01' )
124 ) INHERITS (player_game_stats);
126 CREATE INDEX player_game_stats_2016q2_ix001 on player_game_stats_2016q2(create_dt);
127 CREATE INDEX player_game_stats_2016q2_ix002 on player_game_stats_2016q2(game_id);
128 CREATE INDEX player_game_stats_2016q2_ix003 on player_game_stats_2016q2(player_id);
130 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q3 (
131 CHECK ( create_dt >= DATE '2016-07-01' AND create_dt < DATE '2016-10-01' )
132 ) INHERITS (player_game_stats);
134 CREATE INDEX player_game_stats_2016q3_ix001 on player_game_stats_2016q3(create_dt);
135 CREATE INDEX player_game_stats_2016q3_ix002 on player_game_stats_2016q3(game_id);
136 CREATE INDEX player_game_stats_2016q3_ix003 on player_game_stats_2016q3(player_id);
138 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q4 (
139 CHECK ( create_dt >= DATE '2016-10-01' AND create_dt < DATE '2017-01-01' )
140 ) INHERITS (player_game_stats);
142 CREATE INDEX player_game_stats_2016q4_ix001 on player_game_stats_2016q4(create_dt);
143 CREATE INDEX player_game_stats_2016q4_ix002 on player_game_stats_2016q4(game_id);
144 CREATE INDEX player_game_stats_2016q4_ix003 on player_game_stats_2016q4(player_id);
146 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q1 (
147 CHECK ( create_dt >= DATE '2017-01-01' AND create_dt < DATE '2017-04-01' )
148 ) INHERITS (player_game_stats);
150 CREATE INDEX player_game_stats_2017q1_ix001 on player_game_stats_2017q1(create_dt);
151 CREATE INDEX player_game_stats_2017q1_ix002 on player_game_stats_2017q1(game_id);
152 CREATE INDEX player_game_stats_2017q1_ix003 on player_game_stats_2017q1(player_id);
154 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q2 (
155 CHECK ( create_dt >= DATE '2017-04-01' AND create_dt < DATE '2017-07-01' )
156 ) INHERITS (player_game_stats);
158 CREATE INDEX player_game_stats_2017q2_ix001 on player_game_stats_2017q2(create_dt);
159 CREATE INDEX player_game_stats_2017q2_ix002 on player_game_stats_2017q2(game_id);
160 CREATE INDEX player_game_stats_2017q2_ix003 on player_game_stats_2017q2(player_id);
162 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q3 (
163 CHECK ( create_dt >= DATE '2017-07-01' AND create_dt < DATE '2017-10-01' )
164 ) INHERITS (player_game_stats);
166 CREATE INDEX player_game_stats_2017q3_ix001 on player_game_stats_2017q3(create_dt);
167 CREATE INDEX player_game_stats_2017q3_ix002 on player_game_stats_2017q3(game_id);
168 CREATE INDEX player_game_stats_2017q3_ix003 on player_game_stats_2017q3(player_id);
170 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q4 (
171 CHECK ( create_dt >= DATE '2017-10-01' AND create_dt < DATE '2018-01-01' )
172 ) INHERITS (player_game_stats);
174 CREATE INDEX player_game_stats_2017q4_ix001 on player_game_stats_2017q4(create_dt);
175 CREATE INDEX player_game_stats_2017q4_ix002 on player_game_stats_2017q4(game_id);
176 CREATE INDEX player_game_stats_2017q4_ix003 on player_game_stats_2017q4(player_id);
178 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q1 (
179 CHECK ( create_dt >= DATE '2018-01-01' AND create_dt < DATE '2018-04-01' )
180 ) INHERITS (player_game_stats);
182 CREATE INDEX player_game_stats_2018q1_ix001 on player_game_stats_2018q1(create_dt);
183 CREATE INDEX player_game_stats_2018q1_ix002 on player_game_stats_2018q1(game_id);
184 CREATE INDEX player_game_stats_2018q1_ix003 on player_game_stats_2018q1(player_id);
186 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q2 (
187 CHECK ( create_dt >= DATE '2018-04-01' AND create_dt < DATE '2018-07-01' )
188 ) INHERITS (player_game_stats);
190 CREATE INDEX player_game_stats_2018q2_ix001 on player_game_stats_2018q2(create_dt);
191 CREATE INDEX player_game_stats_2018q2_ix002 on player_game_stats_2018q2(game_id);
192 CREATE INDEX player_game_stats_2018q2_ix003 on player_game_stats_2018q2(player_id);
194 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q3 (
195 CHECK ( create_dt >= DATE '2018-07-01' AND create_dt < DATE '2018-10-01' )
196 ) INHERITS (player_game_stats);
198 CREATE INDEX player_game_stats_2018q3_ix001 on player_game_stats_2018q3(create_dt);
199 CREATE INDEX player_game_stats_2018q3_ix002 on player_game_stats_2018q3(game_id);
200 CREATE INDEX player_game_stats_2018q3_ix003 on player_game_stats_2018q3(player_id);
202 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q4 (
203 CHECK ( create_dt >= DATE '2018-10-01' AND create_dt < DATE '2019-01-01' )
204 ) INHERITS (player_game_stats);
206 CREATE INDEX player_game_stats_2018q4_ix001 on player_game_stats_2018q4(create_dt);
207 CREATE INDEX player_game_stats_2018q4_ix002 on player_game_stats_2018q4(game_id);
208 CREATE INDEX player_game_stats_2018q4_ix003 on player_game_stats_2018q4(player_id);
210 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q1 (
211 CHECK ( create_dt >= DATE '2019-01-01' AND create_dt < DATE '2019-04-01' )
212 ) INHERITS (player_game_stats);
214 CREATE INDEX player_game_stats_2019q1_ix001 on player_game_stats_2019q1(create_dt);
215 CREATE INDEX player_game_stats_2019q1_ix002 on player_game_stats_2019q1(game_id);
216 CREATE INDEX player_game_stats_2019q1_ix003 on player_game_stats_2019q1(player_id);
218 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q2 (
219 CHECK ( create_dt >= DATE '2019-04-01' AND create_dt < DATE '2019-07-01' )
220 ) INHERITS (player_game_stats);
222 CREATE INDEX player_game_stats_2019q2_ix001 on player_game_stats_2019q2(create_dt);
223 CREATE INDEX player_game_stats_2019q2_ix002 on player_game_stats_2019q2(game_id);
224 CREATE INDEX player_game_stats_2019q2_ix003 on player_game_stats_2019q2(player_id);
226 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q3 (
227 CHECK ( create_dt >= DATE '2019-07-01' AND create_dt < DATE '2019-10-01' )
228 ) INHERITS (player_game_stats);
230 CREATE INDEX player_game_stats_2019q3_ix001 on player_game_stats_2019q3(create_dt);
231 CREATE INDEX player_game_stats_2019q3_ix002 on player_game_stats_2019q3(game_id);
232 CREATE INDEX player_game_stats_2019q3_ix003 on player_game_stats_2019q3(player_id);
234 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q4 (
235 CHECK ( create_dt >= DATE '2019-10-01' AND create_dt < DATE '2020-01-01' )
236 ) INHERITS (player_game_stats);
238 CREATE INDEX player_game_stats_2019q4_ix001 on player_game_stats_2019q4(create_dt);
239 CREATE INDEX player_game_stats_2019q4_ix002 on player_game_stats_2019q4(game_id);
240 CREATE INDEX player_game_stats_2019q4_ix003 on player_game_stats_2019q4(player_id);
242 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q1 (
243 CHECK ( create_dt >= DATE '2020-01-01' AND create_dt < DATE '2020-04-01' )
244 ) INHERITS (player_game_stats);
246 CREATE INDEX player_game_stats_2020q1_ix001 on player_game_stats_2020q1(create_dt);
247 CREATE INDEX player_game_stats_2020q1_ix002 on player_game_stats_2020q1(game_id);
248 CREATE INDEX player_game_stats_2020q1_ix003 on player_game_stats_2020q1(player_id);
250 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q2 (
251 CHECK ( create_dt >= DATE '2020-04-01' AND create_dt < DATE '2020-07-01' )
252 ) INHERITS (player_game_stats);
254 CREATE INDEX player_game_stats_2020q2_ix001 on player_game_stats_2020q2(create_dt);
255 CREATE INDEX player_game_stats_2020q2_ix002 on player_game_stats_2020q2(game_id);
256 CREATE INDEX player_game_stats_2020q2_ix003 on player_game_stats_2020q2(player_id);
258 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q3 (
259 CHECK ( create_dt >= DATE '2020-07-01' AND create_dt < DATE '2020-10-01' )
260 ) INHERITS (player_game_stats);
262 CREATE INDEX player_game_stats_2020q3_ix001 on player_game_stats_2020q3(create_dt);
263 CREATE INDEX player_game_stats_2020q3_ix002 on player_game_stats_2020q3(game_id);
264 CREATE INDEX player_game_stats_2020q3_ix003 on player_game_stats_2020q3(player_id);
266 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q4 (
267 CHECK ( create_dt >= DATE '2020-10-01' AND create_dt < DATE '2021-01-01' )
268 ) INHERITS (player_game_stats);
270 CREATE INDEX player_game_stats_2020q4_ix001 on player_game_stats_2020q4(create_dt);
271 CREATE INDEX player_game_stats_2020q4_ix002 on player_game_stats_2020q4(game_id);
272 CREATE INDEX player_game_stats_2020q4_ix003 on player_game_stats_2020q4(player_id);
274 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2021q1 (
275 CHECK ( create_dt >= DATE '2021-01-01' AND create_dt < DATE '2021-04-01' )
276 ) INHERITS (player_game_stats);
278 CREATE INDEX player_game_stats_2021q1_ix001 on player_game_stats_2021q1(create_dt);
279 CREATE INDEX player_game_stats_2021q1_ix002 on player_game_stats_2021q1(game_id);
280 CREATE INDEX player_game_stats_2021q1_ix003 on player_game_stats_2021q1(player_id);
282 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2021q2 (
283 CHECK ( create_dt >= DATE '2021-04-01' AND create_dt < DATE '2021-07-01' )
284 ) INHERITS (player_game_stats);
286 CREATE INDEX player_game_stats_2021q2_ix001 on player_game_stats_2021q2(create_dt);
287 CREATE INDEX player_game_stats_2021q2_ix002 on player_game_stats_2021q2(game_id);
288 CREATE INDEX player_game_stats_2021q2_ix003 on player_game_stats_2021q2(player_id);
290 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2021q3 (
291 CHECK ( create_dt >= DATE '2021-07-01' AND create_dt < DATE '2021-10-01' )
292 ) INHERITS (player_game_stats);
294 CREATE INDEX player_game_stats_2021q3_ix001 on player_game_stats_2021q3(create_dt);
295 CREATE INDEX player_game_stats_2021q3_ix002 on player_game_stats_2021q3(game_id);
296 CREATE INDEX player_game_stats_2021q3_ix003 on player_game_stats_2021q3(player_id);
298 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2021q4 (
299 CHECK ( create_dt >= DATE '2021-10-01' AND create_dt < DATE '2022-01-01' )
300 ) INHERITS (player_game_stats);
302 CREATE INDEX player_game_stats_2021q4_ix001 on player_game_stats_2021q4(create_dt);
303 CREATE INDEX player_game_stats_2021q4_ix002 on player_game_stats_2021q4(game_id);
304 CREATE INDEX player_game_stats_2021q4_ix003 on player_game_stats_2021q4(player_id);
306 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2022q1 (
307 CHECK ( create_dt >= DATE '2022-01-01' AND create_dt < DATE '2022-04-01' )
308 ) INHERITS (player_game_stats);
310 CREATE INDEX player_game_stats_2022q1_ix001 on player_game_stats_2022q1(create_dt);
311 CREATE INDEX player_game_stats_2022q1_ix002 on player_game_stats_2022q1(game_id);
312 CREATE INDEX player_game_stats_2022q1_ix003 on player_game_stats_2022q1(player_id);
314 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2022q2 (
315 CHECK ( create_dt >= DATE '2022-04-01' AND create_dt < DATE '2022-07-01' )
316 ) INHERITS (player_game_stats);
318 CREATE INDEX player_game_stats_2022q2_ix001 on player_game_stats_2022q2(create_dt);
319 CREATE INDEX player_game_stats_2022q2_ix002 on player_game_stats_2022q2(game_id);
320 CREATE INDEX player_game_stats_2022q2_ix003 on player_game_stats_2022q2(player_id);
322 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2022q3 (
323 CHECK ( create_dt >= DATE '2022-07-01' AND create_dt < DATE '2022-10-01' )
324 ) INHERITS (player_game_stats);
326 CREATE INDEX player_game_stats_2022q3_ix001 on player_game_stats_2022q3(create_dt);
327 CREATE INDEX player_game_stats_2022q3_ix002 on player_game_stats_2022q3(game_id);
328 CREATE INDEX player_game_stats_2022q3_ix003 on player_game_stats_2022q3(player_id);
330 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2022q4 (
331 CHECK ( create_dt >= DATE '2022-10-01' AND create_dt < DATE '2023-01-01' )
332 ) INHERITS (player_game_stats);
334 CREATE INDEX player_game_stats_2022q4_ix001 on player_game_stats_2022q4(create_dt);
335 CREATE INDEX player_game_stats_2022q4_ix002 on player_game_stats_2022q4(game_id);
336 CREATE INDEX player_game_stats_2022q4_ix003 on player_game_stats_2022q4(player_id);
338 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2023q1 (
339 CHECK ( create_dt >= DATE '2023-01-01' AND create_dt < DATE '2023-04-01' )
340 ) INHERITS (player_game_stats);
342 CREATE INDEX player_game_stats_2023q1_ix001 on player_game_stats_2023q1(create_dt);
343 CREATE INDEX player_game_stats_2023q1_ix002 on player_game_stats_2023q1(game_id);
344 CREATE INDEX player_game_stats_2023q1_ix003 on player_game_stats_2023q1(player_id);
346 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2023q2 (
347 CHECK ( create_dt >= DATE '2023-04-01' AND create_dt < DATE '2023-07-01' )
348 ) INHERITS (player_game_stats);
350 CREATE INDEX player_game_stats_2023q2_ix001 on player_game_stats_2023q2(create_dt);
351 CREATE INDEX player_game_stats_2023q2_ix002 on player_game_stats_2023q2(game_id);
352 CREATE INDEX player_game_stats_2023q2_ix003 on player_game_stats_2023q2(player_id);
354 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2023q3 (
355 CHECK ( create_dt >= DATE '2023-07-01' AND create_dt < DATE '2023-10-01' )
356 ) INHERITS (player_game_stats);
358 CREATE INDEX player_game_stats_2023q3_ix001 on player_game_stats_2023q3(create_dt);
359 CREATE INDEX player_game_stats_2023q3_ix002 on player_game_stats_2023q3(game_id);
360 CREATE INDEX player_game_stats_2023q3_ix003 on player_game_stats_2023q3(player_id);
362 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2023q4 (
363 CHECK ( create_dt >= DATE '2023-10-01' AND create_dt < DATE '2024-01-01' )
364 ) INHERITS (player_game_stats);
366 CREATE INDEX player_game_stats_2023q4_ix001 on player_game_stats_2023q4(create_dt);
367 CREATE INDEX player_game_stats_2023q4_ix002 on player_game_stats_2023q4(game_id);
368 CREATE INDEX player_game_stats_2023q4_ix003 on player_game_stats_2023q4(player_id);
370 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2024q1 (
371 CHECK ( create_dt >= DATE '2024-01-01' AND create_dt < DATE '2024-04-01' )
372 ) INHERITS (player_game_stats);
374 CREATE INDEX player_game_stats_2024q1_ix001 on player_game_stats_2024q1(create_dt);
375 CREATE INDEX player_game_stats_2024q1_ix002 on player_game_stats_2024q1(game_id);
376 CREATE INDEX player_game_stats_2024q1_ix003 on player_game_stats_2024q1(player_id);
378 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2024q2 (
379 CHECK ( create_dt >= DATE '2024-04-01' AND create_dt < DATE '2024-07-01' )
380 ) INHERITS (player_game_stats);
382 CREATE INDEX player_game_stats_2024q2_ix001 on player_game_stats_2024q2(create_dt);
383 CREATE INDEX player_game_stats_2024q2_ix002 on player_game_stats_2024q2(game_id);
384 CREATE INDEX player_game_stats_2024q2_ix003 on player_game_stats_2024q2(player_id);
386 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2024q3 (
387 CHECK ( create_dt >= DATE '2024-07-01' AND create_dt < DATE '2024-10-01' )
388 ) INHERITS (player_game_stats);
390 CREATE INDEX player_game_stats_2024q3_ix001 on player_game_stats_2024q3(create_dt);
391 CREATE INDEX player_game_stats_2024q3_ix002 on player_game_stats_2024q3(game_id);
392 CREATE INDEX player_game_stats_2024q3_ix003 on player_game_stats_2024q3(player_id);
394 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2024q4 (
395 CHECK ( create_dt >= DATE '2024-10-01' AND create_dt < DATE '2025-01-01' )
396 ) INHERITS (player_game_stats);
398 CREATE INDEX player_game_stats_2024q4_ix001 on player_game_stats_2024q4(create_dt);
399 CREATE INDEX player_game_stats_2024q4_ix002 on player_game_stats_2024q4(game_id);
400 CREATE INDEX player_game_stats_2024q4_ix003 on player_game_stats_2024q4(player_id);
402 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2025q1 (
403 CHECK ( create_dt >= DATE '2025-01-01' AND create_dt < DATE '2025-04-01' )
404 ) INHERITS (player_game_stats);
406 CREATE INDEX player_game_stats_2025q1_ix001 on player_game_stats_2025q1(create_dt);
407 CREATE INDEX player_game_stats_2025q1_ix002 on player_game_stats_2025q1(game_id);
408 CREATE INDEX player_game_stats_2025q1_ix003 on player_game_stats_2025q1(player_id);
410 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2025q2 (
411 CHECK ( create_dt >= DATE '2025-04-01' AND create_dt < DATE '2025-07-01' )
412 ) INHERITS (player_game_stats);
414 CREATE INDEX player_game_stats_2025q2_ix001 on player_game_stats_2025q2(create_dt);
415 CREATE INDEX player_game_stats_2025q2_ix002 on player_game_stats_2025q2(game_id);
416 CREATE INDEX player_game_stats_2025q2_ix003 on player_game_stats_2025q2(player_id);
418 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2025q3 (
419 CHECK ( create_dt >= DATE '2025-07-01' AND create_dt < DATE '2025-10-01' )
420 ) INHERITS (player_game_stats);
422 CREATE INDEX player_game_stats_2025q3_ix001 on player_game_stats_2025q3(create_dt);
423 CREATE INDEX player_game_stats_2025q3_ix002 on player_game_stats_2025q3(game_id);
424 CREATE INDEX player_game_stats_2025q3_ix003 on player_game_stats_2025q3(player_id);
426 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2025q4 (
427 CHECK ( create_dt >= DATE '2025-10-01' AND create_dt < DATE '2026-01-01' )
428 ) INHERITS (player_game_stats);
430 CREATE INDEX player_game_stats_2025q4_ix001 on player_game_stats_2025q4(create_dt);
431 CREATE INDEX player_game_stats_2025q4_ix002 on player_game_stats_2025q4(game_id);
432 CREATE INDEX player_game_stats_2025q4_ix003 on player_game_stats_2025q4(player_id);