1 CREATE TABLE xonstat.team_game_stats
3 team_game_stat_id bigserial NOT NULL,
4 game_id bigint NOT NULL,
9 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
10 CONSTRAINT team_game_stats_pk PRIMARY KEY (team_game_stat_id),
11 CONSTRAINT team_game_stats_uk001 UNIQUE (game_id, team),
12 CONSTRAINT team_game_stats_fk001 FOREIGN KEY (game_id)
13 REFERENCES xonstat.games (game_id) MATCH SIMPLE
14 ON UPDATE NO ACTION ON DELETE CASCADE
20 CREATE INDEX team_game_stats_ix01 on team_game_stats(game_id);
21 ALTER TABLE xonstat.team_game_stats OWNER TO xonstat;
23 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2014q1 (
24 CHECK ( create_dt >= DATE '2014-01-01' AND create_dt < DATE '2014-04-01' )
25 ) INHERITS (team_game_stats);
27 CREATE INDEX team_game_stats_2014q1_ix001 on team_game_stats_2014q1(create_dt);
28 CREATE INDEX team_game_stats_2014q1_ix002 on team_game_stats_2014q1(game_id);
30 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2014q2 (
31 CHECK ( create_dt >= DATE '2014-04-01' AND create_dt < DATE '2014-07-01' )
32 ) INHERITS (team_game_stats);
34 CREATE INDEX team_game_stats_2014q2_ix001 on team_game_stats_2014q2(create_dt);
35 CREATE INDEX team_game_stats_2014q2_ix002 on team_game_stats_2014q2(game_id);
37 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2014q3 (
38 CHECK ( create_dt >= DATE '2014-07-01' AND create_dt < DATE '2014-10-01' )
39 ) INHERITS (team_game_stats);
41 CREATE INDEX team_game_stats_2014q3_ix001 on team_game_stats_2014q3(create_dt);
42 CREATE INDEX team_game_stats_2014q3_ix002 on team_game_stats_2014q3(game_id);
44 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2014q4 (
45 CHECK ( create_dt >= DATE '2014-10-01' AND create_dt < DATE '2015-01-01' )
46 ) INHERITS (team_game_stats);
48 CREATE INDEX team_game_stats_2014q4_ix001 on team_game_stats_2014q4(create_dt);
49 CREATE INDEX team_game_stats_2014q4_ix002 on team_game_stats_2014q4(game_id);
51 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2015q1 (
52 CHECK ( create_dt >= DATE '2015-01-01' AND create_dt < DATE '2015-04-01' )
53 ) INHERITS (team_game_stats);
55 CREATE INDEX team_game_stats_2015q1_ix001 on team_game_stats_2015q1(create_dt);
56 CREATE INDEX team_game_stats_2015q1_ix002 on team_game_stats_2015q1(game_id);
58 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2015q2 (
59 CHECK ( create_dt >= DATE '2015-04-01' AND create_dt < DATE '2015-07-01' )
60 ) INHERITS (team_game_stats);
62 CREATE INDEX team_game_stats_2015q2_ix001 on team_game_stats_2015q2(create_dt);
63 CREATE INDEX team_game_stats_2015q2_ix002 on team_game_stats_2015q2(game_id);
65 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2015q3 (
66 CHECK ( create_dt >= DATE '2015-07-01' AND create_dt < DATE '2015-10-01' )
67 ) INHERITS (team_game_stats);
69 CREATE INDEX team_game_stats_2015q3_ix001 on team_game_stats_2015q3(create_dt);
70 CREATE INDEX team_game_stats_2015q3_ix002 on team_game_stats_2015q3(game_id);
72 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2015q4 (
73 CHECK ( create_dt >= DATE '2015-10-01' AND create_dt < DATE '2016-01-01' )
74 ) INHERITS (team_game_stats);
76 CREATE INDEX team_game_stats_2015q4_ix001 on team_game_stats_2015q4(create_dt);
77 CREATE INDEX team_game_stats_2015q4_ix002 on team_game_stats_2015q4(game_id);
79 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2016q1 (
80 CHECK ( create_dt >= DATE '2016-01-01' AND create_dt < DATE '2016-04-01' )
81 ) INHERITS (team_game_stats);
83 CREATE INDEX team_game_stats_2016q1_ix001 on team_game_stats_2016q1(create_dt);
84 CREATE INDEX team_game_stats_2016q1_ix002 on team_game_stats_2016q1(game_id);
86 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2016q2 (
87 CHECK ( create_dt >= DATE '2016-04-01' AND create_dt < DATE '2016-07-01' )
88 ) INHERITS (team_game_stats);
90 CREATE INDEX team_game_stats_2016q2_ix001 on team_game_stats_2016q2(create_dt);
91 CREATE INDEX team_game_stats_2016q2_ix002 on team_game_stats_2016q2(game_id);
93 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2016q3 (
94 CHECK ( create_dt >= DATE '2016-07-01' AND create_dt < DATE '2016-10-01' )
95 ) INHERITS (team_game_stats);
97 CREATE INDEX team_game_stats_2016q3_ix001 on team_game_stats_2016q3(create_dt);
98 CREATE INDEX team_game_stats_2016q3_ix002 on team_game_stats_2016q3(game_id);
100 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2016q4 (
101 CHECK ( create_dt >= DATE '2016-10-01' AND create_dt < DATE '2017-01-01' )
102 ) INHERITS (team_game_stats);
104 CREATE INDEX team_game_stats_2016q4_ix001 on team_game_stats_2016q4(create_dt);
105 CREATE INDEX team_game_stats_2016q4_ix002 on team_game_stats_2016q4(game_id);
107 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2017q1 (
108 CHECK ( create_dt >= DATE '2017-01-01' AND create_dt < DATE '2017-04-01' )
109 ) INHERITS (team_game_stats);
111 CREATE INDEX team_game_stats_2017q1_ix001 on team_game_stats_2017q1(create_dt);
112 CREATE INDEX team_game_stats_2017q1_ix002 on team_game_stats_2017q1(game_id);
114 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2017q2 (
115 CHECK ( create_dt >= DATE '2017-04-01' AND create_dt < DATE '2017-07-01' )
116 ) INHERITS (team_game_stats);
118 CREATE INDEX team_game_stats_2017q2_ix001 on team_game_stats_2017q2(create_dt);
119 CREATE INDEX team_game_stats_2017q2_ix002 on team_game_stats_2017q2(game_id);
121 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2017q3 (
122 CHECK ( create_dt >= DATE '2017-07-01' AND create_dt < DATE '2017-10-01' )
123 ) INHERITS (team_game_stats);
125 CREATE INDEX team_game_stats_2017q3_ix001 on team_game_stats_2017q3(create_dt);
126 CREATE INDEX team_game_stats_2017q3_ix002 on team_game_stats_2017q3(game_id);
128 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2017q4 (
129 CHECK ( create_dt >= DATE '2017-10-01' AND create_dt < DATE '2018-01-01' )
130 ) INHERITS (team_game_stats);
132 CREATE INDEX team_game_stats_2017q4_ix001 on team_game_stats_2017q4(create_dt);
133 CREATE INDEX team_game_stats_2017q4_ix002 on team_game_stats_2017q4(game_id);
135 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2018q1 (
136 CHECK ( create_dt >= DATE '2018-01-01' AND create_dt < DATE '2018-04-01' )
137 ) INHERITS (team_game_stats);
139 CREATE INDEX team_game_stats_2018q1_ix001 on team_game_stats_2018q1(create_dt);
140 CREATE INDEX team_game_stats_2018q1_ix002 on team_game_stats_2018q1(game_id);
142 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2018q2 (
143 CHECK ( create_dt >= DATE '2018-04-01' AND create_dt < DATE '2018-07-01' )
144 ) INHERITS (team_game_stats);
146 CREATE INDEX team_game_stats_2018q2_ix001 on team_game_stats_2018q2(create_dt);
147 CREATE INDEX team_game_stats_2018q2_ix002 on team_game_stats_2018q2(game_id);
149 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2018q3 (
150 CHECK ( create_dt >= DATE '2018-07-01' AND create_dt < DATE '2018-10-01' )
151 ) INHERITS (team_game_stats);
153 CREATE INDEX team_game_stats_2018q3_ix001 on team_game_stats_2018q3(create_dt);
154 CREATE INDEX team_game_stats_2018q3_ix002 on team_game_stats_2018q3(game_id);
156 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2018q4 (
157 CHECK ( create_dt >= DATE '2018-10-01' AND create_dt < DATE '2019-01-01' )
158 ) INHERITS (team_game_stats);
160 CREATE INDEX team_game_stats_2018q4_ix001 on team_game_stats_2018q4(create_dt);
161 CREATE INDEX team_game_stats_2018q4_ix002 on team_game_stats_2018q4(game_id);
163 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2019q1 (
164 CHECK ( create_dt >= DATE '2019-01-01' AND create_dt < DATE '2019-04-01' )
165 ) INHERITS (team_game_stats);
167 CREATE INDEX team_game_stats_2019q1_ix001 on team_game_stats_2019q1(create_dt);
168 CREATE INDEX team_game_stats_2019q1_ix002 on team_game_stats_2019q1(game_id);
170 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2019q2 (
171 CHECK ( create_dt >= DATE '2019-04-01' AND create_dt < DATE '2019-07-01' )
172 ) INHERITS (team_game_stats);
174 CREATE INDEX team_game_stats_2019q2_ix001 on team_game_stats_2019q2(create_dt);
175 CREATE INDEX team_game_stats_2019q2_ix002 on team_game_stats_2019q2(game_id);
177 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2019q3 (
178 CHECK ( create_dt >= DATE '2019-07-01' AND create_dt < DATE '2019-10-01' )
179 ) INHERITS (team_game_stats);
181 CREATE INDEX team_game_stats_2019q3_ix001 on team_game_stats_2019q3(create_dt);
182 CREATE INDEX team_game_stats_2019q3_ix002 on team_game_stats_2019q3(game_id);
184 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2019q4 (
185 CHECK ( create_dt >= DATE '2019-10-01' AND create_dt < DATE '2020-01-01' )
186 ) INHERITS (team_game_stats);
188 CREATE INDEX team_game_stats_2019q4_ix001 on team_game_stats_2019q4(create_dt);
189 CREATE INDEX team_game_stats_2019q4_ix002 on team_game_stats_2019q4(game_id);
191 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2020q1 (
192 CHECK ( create_dt >= DATE '2020-01-01' AND create_dt < DATE '2020-04-01' )
193 ) INHERITS (team_game_stats);
195 CREATE INDEX team_game_stats_2020q1_ix001 on team_game_stats_2020q1(create_dt);
196 CREATE INDEX team_game_stats_2020q1_ix002 on team_game_stats_2020q1(game_id);
198 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2020q2 (
199 CHECK ( create_dt >= DATE '2020-04-01' AND create_dt < DATE '2020-07-01' )
200 ) INHERITS (team_game_stats);
202 CREATE INDEX team_game_stats_2020q2_ix001 on team_game_stats_2020q2(create_dt);
203 CREATE INDEX team_game_stats_2020q2_ix002 on team_game_stats_2020q2(game_id);
205 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2020q3 (
206 CHECK ( create_dt >= DATE '2020-07-01' AND create_dt < DATE '2020-10-01' )
207 ) INHERITS (team_game_stats);
209 CREATE INDEX team_game_stats_2020q3_ix001 on team_game_stats_2020q3(create_dt);
210 CREATE INDEX team_game_stats_2020q3_ix002 on team_game_stats_2020q3(game_id);
212 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2020q4 (
213 CHECK ( create_dt >= DATE '2020-10-01' AND create_dt < DATE '2021-01-01' )
214 ) INHERITS (team_game_stats);
216 CREATE INDEX team_game_stats_2020q4_ix001 on team_game_stats_2020q4(create_dt);
217 CREATE INDEX team_game_stats_2020q4_ix002 on team_game_stats_2020q4(game_id);
219 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2021q1 (
220 CHECK ( create_dt >= DATE '2021-01-01' AND create_dt < DATE '2021-04-01' )
221 ) INHERITS (team_game_stats);
223 CREATE INDEX team_game_stats_2021q1_ix001 on team_game_stats_2021q1(create_dt);
224 CREATE INDEX team_game_stats_2021q1_ix002 on team_game_stats_2021q1(game_id);
226 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2021q2 (
227 CHECK ( create_dt >= DATE '2021-04-01' AND create_dt < DATE '2021-07-01' )
228 ) INHERITS (team_game_stats);
230 CREATE INDEX team_game_stats_2021q2_ix001 on team_game_stats_2021q2(create_dt);
231 CREATE INDEX team_game_stats_2021q2_ix002 on team_game_stats_2021q2(game_id);
233 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2021q3 (
234 CHECK ( create_dt >= DATE '2021-07-01' AND create_dt < DATE '2021-10-01' )
235 ) INHERITS (team_game_stats);
237 CREATE INDEX team_game_stats_2021q3_ix001 on team_game_stats_2021q3(create_dt);
238 CREATE INDEX team_game_stats_2021q3_ix002 on team_game_stats_2021q3(game_id);
240 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2021q4 (
241 CHECK ( create_dt >= DATE '2021-10-01' AND create_dt < DATE '2022-01-01' )
242 ) INHERITS (team_game_stats);
244 CREATE INDEX team_game_stats_2021q4_ix001 on team_game_stats_2021q4(create_dt);
245 CREATE INDEX team_game_stats_2021q4_ix002 on team_game_stats_2021q4(game_id);
247 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2022q1 (
248 CHECK ( create_dt >= DATE '2022-01-01' AND create_dt < DATE '2022-04-01' )
249 ) INHERITS (team_game_stats);
251 CREATE INDEX team_game_stats_2022q1_ix001 on team_game_stats_2022q1(create_dt);
252 CREATE INDEX team_game_stats_2022q1_ix002 on team_game_stats_2022q1(game_id);
254 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2022q2 (
255 CHECK ( create_dt >= DATE '2022-04-01' AND create_dt < DATE '2022-07-01' )
256 ) INHERITS (team_game_stats);
258 CREATE INDEX team_game_stats_2022q2_ix001 on team_game_stats_2022q2(create_dt);
259 CREATE INDEX team_game_stats_2022q2_ix002 on team_game_stats_2022q2(game_id);
261 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2022q3 (
262 CHECK ( create_dt >= DATE '2022-07-01' AND create_dt < DATE '2022-10-01' )
263 ) INHERITS (team_game_stats);
265 CREATE INDEX team_game_stats_2022q3_ix001 on team_game_stats_2022q3(create_dt);
266 CREATE INDEX team_game_stats_2022q3_ix002 on team_game_stats_2022q3(game_id);
268 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2022q4 (
269 CHECK ( create_dt >= DATE '2022-10-01' AND create_dt < DATE '2023-01-01' )
270 ) INHERITS (team_game_stats);
272 CREATE INDEX team_game_stats_2022q4_ix001 on team_game_stats_2022q4(create_dt);
273 CREATE INDEX team_game_stats_2022q4_ix002 on team_game_stats_2022q4(game_id);
275 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2023q1 (
276 CHECK ( create_dt >= DATE '2023-01-01' AND create_dt < DATE '2023-04-01' )
277 ) INHERITS (team_game_stats);
279 CREATE INDEX team_game_stats_2023q1_ix001 on team_game_stats_2023q1(create_dt);
280 CREATE INDEX team_game_stats_2023q1_ix002 on team_game_stats_2023q1(game_id);
282 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2023q2 (
283 CHECK ( create_dt >= DATE '2023-04-01' AND create_dt < DATE '2023-07-01' )
284 ) INHERITS (team_game_stats);
286 CREATE INDEX team_game_stats_2023q2_ix001 on team_game_stats_2023q2(create_dt);
287 CREATE INDEX team_game_stats_2023q2_ix002 on team_game_stats_2023q2(game_id);
289 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2023q3 (
290 CHECK ( create_dt >= DATE '2023-07-01' AND create_dt < DATE '2023-10-01' )
291 ) INHERITS (team_game_stats);
293 CREATE INDEX team_game_stats_2023q3_ix001 on team_game_stats_2023q3(create_dt);
294 CREATE INDEX team_game_stats_2023q3_ix002 on team_game_stats_2023q3(game_id);
296 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2023q4 (
297 CHECK ( create_dt >= DATE '2023-10-01' AND create_dt < DATE '2024-01-01' )
298 ) INHERITS (team_game_stats);
300 CREATE INDEX team_game_stats_2023q4_ix001 on team_game_stats_2023q4(create_dt);
301 CREATE INDEX team_game_stats_2023q4_ix002 on team_game_stats_2023q4(game_id);
303 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2024q1 (
304 CHECK ( create_dt >= DATE '2024-01-01' AND create_dt < DATE '2024-04-01' )
305 ) INHERITS (team_game_stats);
307 CREATE INDEX team_game_stats_2024q1_ix001 on team_game_stats_2024q1(create_dt);
308 CREATE INDEX team_game_stats_2024q1_ix002 on team_game_stats_2024q1(game_id);
310 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2024q2 (
311 CHECK ( create_dt >= DATE '2024-04-01' AND create_dt < DATE '2024-07-01' )
312 ) INHERITS (team_game_stats);
314 CREATE INDEX team_game_stats_2024q2_ix001 on team_game_stats_2024q2(create_dt);
315 CREATE INDEX team_game_stats_2024q2_ix002 on team_game_stats_2024q2(game_id);
317 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2024q3 (
318 CHECK ( create_dt >= DATE '2024-07-01' AND create_dt < DATE '2024-10-01' )
319 ) INHERITS (team_game_stats);
321 CREATE INDEX team_game_stats_2024q3_ix001 on team_game_stats_2024q3(create_dt);
322 CREATE INDEX team_game_stats_2024q3_ix002 on team_game_stats_2024q3(game_id);
324 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2024q4 (
325 CHECK ( create_dt >= DATE '2024-10-01' AND create_dt < DATE '2025-01-01' )
326 ) INHERITS (team_game_stats);
328 CREATE INDEX team_game_stats_2024q4_ix001 on team_game_stats_2024q4(create_dt);
329 CREATE INDEX team_game_stats_2024q4_ix002 on team_game_stats_2024q4(game_id);
331 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2025q1 (
332 CHECK ( create_dt >= DATE '2025-01-01' AND create_dt < DATE '2025-04-01' )
333 ) INHERITS (team_game_stats);
335 CREATE INDEX team_game_stats_2025q1_ix001 on team_game_stats_2025q1(create_dt);
336 CREATE INDEX team_game_stats_2025q1_ix002 on team_game_stats_2025q1(game_id);
338 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2025q2 (
339 CHECK ( create_dt >= DATE '2025-04-01' AND create_dt < DATE '2025-07-01' )
340 ) INHERITS (team_game_stats);
342 CREATE INDEX team_game_stats_2025q2_ix001 on team_game_stats_2025q2(create_dt);
343 CREATE INDEX team_game_stats_2025q2_ix002 on team_game_stats_2025q2(game_id);
345 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2025q3 (
346 CHECK ( create_dt >= DATE '2025-07-01' AND create_dt < DATE '2025-10-01' )
347 ) INHERITS (team_game_stats);
349 CREATE INDEX team_game_stats_2025q3_ix001 on team_game_stats_2025q3(create_dt);
350 CREATE INDEX team_game_stats_2025q3_ix002 on team_game_stats_2025q3(game_id);
352 CREATE TABLE IF NOT EXISTS xonstat.team_game_stats_2025q4 (
353 CHECK ( create_dt >= DATE '2025-10-01' AND create_dt < DATE '2026-01-01' )
354 ) INHERITS (team_game_stats);
356 CREATE INDEX team_game_stats_2025q4_ix001 on team_game_stats_2025q4(create_dt);
357 CREATE INDEX team_game_stats_2025q4_ix002 on team_game_stats_2025q4(game_id);