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);