home / football

elo_record

268 rows where team_id = 198

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_tournament, competition_id, date (date), created_at (date), updated_at (date)

elo_id ▼ team_id date rating k_factor delta source_match_id is_tournament competition_id created_at updated_at created_by_run_id updated_by_run_id source_id source_raw_key
18078 Nepal 198 1972-10-13 1489.5412378833112 40.0 -10.458762116688831 9039 0 Friendly 8 2026-06-07 07:00:25 2026-06-07 07:00:25 1   International Results CSV 1 elo://9039/away
26272 Nepal 198 1982-02-16 1479.81510753241 40.0 -9.726130350901258 13136 0 Friendly 8 2026-06-07 07:00:31 2026-06-07 07:00:31 1   International Results CSV 1 elo://13136/away
26285 Nepal 198 1982-02-17 1447.8666326185607 40.0 -31.948474913849168 13143 0 Friendly 8 2026-06-07 07:00:31 2026-06-07 07:00:31 1   International Results CSV 1 elo://13143/home
26443 Nepal 198 1982-04-01 1470.845348141601 40.0 22.978715523040364 13222 0 Friendly 8 2026-06-07 07:00:31 2026-06-07 07:00:31 1   International Results CSV 1 elo://13222/home
26467 Nepal 198 1982-04-19 1496.0103199264563 40.0 25.164971784855197 13234 0 Friendly 8 2026-06-07 07:00:31 2026-06-07 07:00:31 1   International Results CSV 1 elo://13234/home
26511 Nepal 198 1982-05-05 1467.8508691122054 40.0 -28.15945081425093 13256 1 King's Cup 65 2026-06-07 07:00:32 2026-06-07 07:00:32 1   International Results CSV 1 elo://13256/home
26946 Nepal 198 1982-11-21 1457.9076164528417 40.0 -9.94325265936368 13473 0 Asian Games 36 2026-06-07 07:00:32 2026-06-07 07:00:32 1   International Results CSV 1 elo://13473/away
26964 Nepal 198 1982-11-23 1452.798760994573 40.0 -5.108855458268636 13482 0 Asian Games 36 2026-06-07 07:00:32 2026-06-07 07:00:32 1   International Results CSV 1 elo://13482/away
26984 Nepal 198 1982-11-25 1432.2554123429725 40.0 -20.54334865160058 13492 0 Asian Games 36 2026-06-07 07:00:32 2026-06-07 07:00:32 1   International Results CSV 1 elo://13492/away
27720 Nepal 198 1983-09-19 1411.0489049674652 40.0 -21.20650737550727 13860 0 Merdeka Tournament 45 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://13860/away
27740 Nepal 198 1983-09-22 1384.8581374375524 40.0 -26.19076752991282 13870 0 Merdeka Tournament 45 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://13870/away
28607 Nepal 198 1984-09-18 1407.3777237401089 40.0 22.51958630255649 14304 0 South Asian Games 93 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14304/home
28619 Nepal 198 1984-09-20 1429.6412813008035 40.0 22.263557560694608 14310 0 South Asian Games 93 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14310/home
28623 Nepal 198 1984-09-21 1404.4870444396242 40.0 -25.154236861179243 14312 0 South Asian Games 93 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14312/home
28629 Nepal 198 1984-09-23 1422.121045564187 40.0 17.6340011245627 14315 0 South Asian Games 93 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14315/home
28746 Nepal 198 1984-10-19 1409.90784070873 40.0 -12.21320485545698 14373 1 AFC Asian Cup qualification 40 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14373/away
28762 Nepal 198 1984-10-22 1379.3277634237006 40.0 -30.580077285029347 14381 1 AFC Asian Cup qualification 40 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14381/away
28774 Nepal 198 1984-10-26 1363.5497182025258 40.0 -15.778045221174807 14387 1 AFC Asian Cup qualification 40 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14387/away
28784 Nepal 198 1984-10-28 1336.2314776589697 40.0 -27.318240543556158 14392 1 AFC Asian Cup qualification 40 2026-06-07 07:00:33 2026-06-07 07:00:33 1   International Results CSV 1 elo://14392/away
29249 Nepal 198 1985-03-02 1329.695509435694 40.0 -6.535968223275631 14625 1 FIFA World Cup qualification 31 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://14625/home
29299 Nepal 198 1985-03-16 1339.9080258019421 40.0 10.21251636624811 14650 1 FIFA World Cup qualification 31 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://14650/home
29394 Nepal 198 1985-03-31 1329.2255120220293 40.0 -10.682513779912824 14697 1 FIFA World Cup qualification 31 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://14697/away
29438 Nepal 198 1985-04-06 1322.2530452183134 40.0 -6.972466803715861 14719 1 FIFA World Cup qualification 31 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://14719/away
29554 Nepal 198 1985-04-29 1314.522415596204 40.0 -7.730629622109518 14777 0 Friendly 8 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://14777/away
29560 Nepal 198 1985-04-30 1298.4891197495072 40.0 -16.033295846696774 14780 0 Friendly 8 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://14780/away
30240 Nepal 198 1985-12-21 1283.8941072647783 40.0 -14.59501248472884 15120 0 South Asian Games 93 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://15120/away
30243 Nepal 198 1985-12-22 1310.4483226370742 40.0 26.554215372295857 15122 0 South Asian Games 93 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://15122/home
30252 Nepal 198 1985-12-25 1313.3107210752614 40.0 2.862398438187256 15126 0 South Asian Games 93 2026-06-07 07:00:34 2026-06-07 07:00:34 1   International Results CSV 1 elo://15126/away
30558 Nepal 198 1986-04-25 1307.1768817933903 40.0 -6.133839281871133 15279 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15279/away
30567 Nepal 198 1986-04-27 1301.7436816259788 40.0 -5.433200167411542 15284 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15284/home
30572 Nepal 198 1986-04-29 1296.6362650353371 40.0 -5.107416590641606 15286 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15286/away
30590 Nepal 198 1986-05-02 1281.9227431371464 40.0 -14.71352189819072 15295 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15295/away
30657 Nepal 198 1986-06-04 1315.0884821132975 40.0 33.16573897615103 15329 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15329/home
30683 Nepal 198 1986-06-07 1337.5177752979391 40.0 22.429293184641665 15342 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15342/home
30886 Nepal 198 1986-09-20 1332.072713848838 40.0 -5.445061449101104 15443 0 Asian Games 36 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15443/away
30901 Nepal 198 1986-09-22 1327.3197169056891 40.0 -4.752996943148901 15451 0 Asian Games 36 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15451/home
30933 Nepal 198 1986-09-26 1310.4928625413686 40.0 -16.826854364320525 15467 0 Asian Games 36 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15467/home
30952 Nepal 198 1986-09-28 1306.6645478606251 40.0 -3.8283146807434605 15476 0 Asian Games 36 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15476/away
31079 Nepal 198 1986-12-04 1331.440970939047 40.0 24.776423078421885 15540 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15540/home
31097 Nepal 198 1986-12-11 1326.6657313819585 40.0 -4.7752395570885255 15549 0 Friendly 8 2026-06-07 07:00:35 2026-06-07 07:00:35 1   International Results CSV 1 elo://15549/home
31743 Nepal 198 1987-11-21 1348.9486043623683 40.0 22.28287298040982 15872 0 South Asian Games 93 2026-06-07 07:00:36 2026-06-07 07:00:36 1   International Results CSV 1 elo://15872/home
31755 Nepal 198 1987-11-23 1367.0345498808895 40.0 18.085945518521157 15878 0 South Asian Games 93 2026-06-07 07:00:36 2026-06-07 07:00:36 1   International Results CSV 1 elo://15878/home
31760 Nepal 198 1987-11-26 1349.1760765407264 40.0 -17.858473340163073 15880 0 South Asian Games 93 2026-06-07 07:00:36 2026-06-07 07:00:36 1   International Results CSV 1 elo://15880/away
32301 Nepal 198 1988-05-25 1359.3238678314074 40.0 10.14779129068097 16151 1 AFC Asian Cup qualification 40 2026-06-07 07:00:36 2026-06-07 07:00:36 1   International Results CSV 1 elo://16151/home
32309 Nepal 198 1988-05-28 1351.7023530692186 40.0 -7.621514762188781 16155 1 AFC Asian Cup qualification 40 2026-06-07 07:00:36 2026-06-07 07:00:36 1   International Results CSV 1 elo://16155/home
32323 Nepal 198 1988-06-01 1340.1057244767087 40.0 -11.596628592509887 16162 1 AFC Asian Cup qualification 40 2026-06-07 07:00:36 2026-06-07 07:00:36 1   International Results CSV 1 elo://16162/home
32349 Nepal 198 1988-06-04 1335.5591883533139 40.0 -4.546536123394844 16175 1 AFC Asian Cup qualification 40 2026-06-07 07:00:36 2026-06-07 07:00:36 1   International Results CSV 1 elo://16175/home
33450 Nepal 198 1989-05-23 1321.0663758235034 40.0 -14.492812529810408 16725 1 FIFA World Cup qualification 31 2026-06-07 07:00:37 2026-06-07 07:00:37 1   International Results CSV 1 elo://16725/away
33460 Nepal 198 1989-05-25 1318.0097865789162 40.0 -3.056589244587258 16730 1 FIFA World Cup qualification 31 2026-06-07 07:00:37 2026-06-07 07:00:37 1   International Results CSV 1 elo://16730/away
33482 Nepal 198 1989-05-27 1300.7113426410897 40.0 -17.298443937826505 16741 1 FIFA World Cup qualification 31 2026-06-07 07:00:37 2026-06-07 07:00:37 1   International Results CSV 1 elo://16741/away
33529 Nepal 198 1989-06-03 1298.103404324598 40.0 -2.6079383164917544 16765 1 FIFA World Cup qualification 31 2026-06-07 07:00:37 2026-06-07 07:00:37 1   International Results CSV 1 elo://16765/home
33550 Nepal 198 1989-06-05 1283.1019426654066 40.0 -15.001461659191364 16775 1 FIFA World Cup qualification 31 2026-06-07 07:00:37 2026-06-07 07:00:37 1   International Results CSV 1 elo://16775/away
33556 Nepal 198 1989-06-07 1271.9502208429615 40.0 -11.151721822445097 16778 1 FIFA World Cup qualification 31 2026-06-07 07:00:37 2026-06-07 07:00:37 1   International Results CSV 1 elo://16778/away
34026 Nepal 198 1989-10-20 1274.0253393123382 40.0 2.0751184693767755 17013 0 South Asian Games 93 2026-06-07 07:00:38 2026-06-07 07:00:38 1   International Results CSV 1 elo://17013/away
34034 Nepal 198 1989-10-22 1275.8436129716615 40.0 1.8182736593232676 17017 0 South Asian Games 93 2026-06-07 07:00:38 2026-06-07 07:00:38 1   International Results CSV 1 elo://17017/away
34062 Nepal 198 1989-10-26 1261.3941517371718 40.0 -14.449461234489718 17031 0 South Asian Games 93 2026-06-07 07:00:38 2026-06-07 07:00:38 1   International Results CSV 1 elo://17031/away
36194 Nepal 198 1991-12-22 1257.060047938906 40.0 -4.334103798265687 18097 0 South Asian Games 93 2026-06-07 07:00:39 2026-06-07 07:00:39 1   International Results CSV 1 elo://18097/away
36200 Nepal 198 1991-12-24 1238.7180493654741 40.0 -18.341998573431965 18100 0 South Asian Games 93 2026-06-07 07:00:39 2026-06-07 07:00:39 1   International Results CSV 1 elo://18100/away
36210 Nepal 198 1991-12-28 1223.0124716095384 40.0 -15.705577755935792 18105 0 South Asian Games 93 2026-06-07 07:00:39 2026-06-07 07:00:39 1   International Results CSV 1 elo://18105/away
38989 Nepal 198 1993-12-22 1227.4160655519568 40.0 4.403593942418411 19495 0 South Asian Games 93 2026-06-07 07:00:41 2026-06-07 07:00:41 1   International Results CSV 1 elo://19495/home
38994 Nepal 198 1993-12-24 1252.8301580002733 40.0 25.414092448316524 19497 0 South Asian Games 93 2026-06-07 07:00:41 2026-06-07 07:00:41 1   International Results CSV 1 elo://19497/away
38999 Nepal 198 1993-12-26 1258.535918554896 40.0 5.705760554622657 19500 0 South Asian Games 93 2026-06-07 07:00:41 2026-06-07 07:00:41 1   International Results CSV 1 elo://19500/home
39836 Nepal 198 1994-10-01 1255.4888185370548 40.0 -3.047100017841103 19918 0 Asian Games 36 2026-06-07 07:00:42 2026-06-07 07:00:42 1   International Results CSV 1 elo://19918/away
39848 Nepal 198 1994-10-03 1251.033719234068 40.0 -4.45509930298681 19924 0 Asian Games 36 2026-06-07 07:00:42 2026-06-07 07:00:42 1   International Results CSV 1 elo://19924/away
39900 Nepal 198 1994-10-09 1241.9204365325688 40.0 -9.113282701499202 19950 0 Asian Games 36 2026-06-07 07:00:42 2026-06-07 07:00:42 1   International Results CSV 1 elo://19950/away
40405 Nepal 198 1995-03-25 1224.1805786907034 40.0 -17.739857841865387 20203 1 SAFF Cup 122 2026-06-07 07:00:42 2026-06-07 07:00:42 1   International Results CSV 1 elo://20203/home
40447 Nepal 198 1995-03-29 1245.0084212781292 40.0 20.82784258742572 20224 1 SAFF Cup 122 2026-06-07 07:00:42 2026-06-07 07:00:42 1   International Results CSV 1 elo://20224/home
40476 Nepal 198 1995-03-31 1221.5619093220967 40.0 -23.44651195603251 20238 1 SAFF Cup 122 2026-06-07 07:00:42 2026-06-07 07:00:42 1   International Results CSV 1 elo://20238/away
41523 Nepal 198 1995-12-19 1244.2344388179606 40.0 22.672529495863955 20762 0 South Asian Games 93 2026-06-07 07:00:43 2026-06-07 07:00:43 1   International Results CSV 1 elo://20762/home
41542 Nepal 198 1995-12-23 1227.7262515475047 40.0 -16.508187270455892 20771 0 South Asian Games 93 2026-06-07 07:00:43 2026-06-07 07:00:43 1   International Results CSV 1 elo://20771/away
41548 Nepal 198 1995-12-25 1213.3898079368 40.0 -14.336443610704691 20774 0 South Asian Games 93 2026-06-07 07:00:43 2026-06-07 07:00:43 1   International Results CSV 1 elo://20774/away
41554 Nepal 198 1995-12-27 1212.5985855443116 40.0 -0.7912223924884074 20777 0 South Asian Games 93 2026-06-07 07:00:43 2026-06-07 07:00:43 1   International Results CSV 1 elo://20777/away
42236 Nepal 198 1996-06-10 1209.87821676986 40.0 -2.720368774451572 21118 1 AFC Asian Cup qualification 40 2026-06-07 07:00:44 2026-06-07 07:00:44 1   International Results CSV 1 elo://21118/away
42251 Nepal 198 1996-06-12 1201.8307336322816 40.0 -8.04748313757841 21126 1 AFC Asian Cup qualification 40 2026-06-07 07:00:44 2026-06-07 07:00:44 1   International Results CSV 1 elo://21126/home
42274 Nepal 198 1996-06-14 1181.151710386013 40.0 -20.67902324626857 21137 1 AFC Asian Cup qualification 40 2026-06-07 07:00:44 2026-06-07 07:00:44 1   International Results CSV 1 elo://21137/away
42318 Nepal 198 1996-06-17 1174.0833546330366 40.0 -7.0683557529764585 21159 1 AFC Asian Cup qualification 40 2026-06-07 07:00:44 2026-06-07 07:00:44 1   International Results CSV 1 elo://21159/away
42333 Nepal 198 1996-06-19 1172.0654106141876 40.0 -2.0179440188489934 21167 1 AFC Asian Cup qualification 40 2026-06-07 07:00:44 2026-06-07 07:00:44 1   International Results CSV 1 elo://21167/home
42347 Nepal 198 1996-06-21 1153.6957535210734 40.0 -18.369657093114256 21174 1 AFC Asian Cup qualification 40 2026-06-07 07:00:44 2026-06-07 07:00:44 1   International Results CSV 1 elo://21174/home
43559 Nepal 198 1997-03-23 1159.6529347750122 40.0 5.95718125393887 21780 1 FIFA World Cup qualification 31 2026-06-07 07:00:45 2026-06-07 07:00:45 1   International Results CSV 1 elo://21780/home
43570 Nepal 198 1997-03-25 1152.1414226855331 40.0 -7.511512089479083 21785 1 FIFA World Cup qualification 31 2026-06-07 07:00:45 2026-06-07 07:00:45 1   International Results CSV 1 elo://21785/away
43571 Nepal 198 1997-03-27 1150.7244155886954 40.0 -1.4170070968377786 21786 1 FIFA World Cup qualification 31 2026-06-07 07:00:45 2026-06-07 07:00:45 1   International Results CSV 1 elo://21786/home
44233 Nepal 198 1997-06-22 1144.127712089988 40.0 -6.596703498707257 22117 1 FIFA World Cup qualification 31 2026-06-07 07:00:45 2026-06-07 07:00:45 1   International Results CSV 1 elo://22117/home
44244 Nepal 198 1997-06-25 1142.9039330345786 40.0 -1.2237790554095227 22122 1 FIFA World Cup qualification 31 2026-06-07 07:00:45 2026-06-07 07:00:45 1   International Results CSV 1 elo://22122/away
44256 Nepal 198 1997-06-28 1127.776387953712 40.0 -15.12754508086664 22128 1 FIFA World Cup qualification 31 2026-06-07 07:00:45 2026-06-07 07:00:45 1   International Results CSV 1 elo://22128/away
44531 Nepal 198 1997-09-04 1111.4881278745643 40.0 -16.288260079147676 22266 1 SAFF Cup 122 2026-06-07 07:00:46 2026-06-07 07:00:46 1   International Results CSV 1 elo://22266/home
44581 Nepal 198 1997-09-08 1099.0556277393707 40.0 -12.43250013519355 22291 1 SAFF Cup 122 2026-06-07 07:00:46 2026-06-07 07:00:46 1   International Results CSV 1 elo://22291/home
46442 Nepal 198 1998-11-27 1096.4847465692462 40.0 -2.570881170124494 23221 0 Friendly 8 2026-06-07 07:00:47 2026-06-07 07:00:47 1   International Results CSV 1 elo://23221/away
46451 Nepal 198 1998-12-01 1095.2105185691748 40.0 -1.274228000071389 23226 0 Asian Games 36 2026-06-07 07:00:47 2026-06-07 07:00:47 1   International Results CSV 1 elo://23226/home
46484 Nepal 198 1998-12-05 1088.2503683845553 40.0 -6.960150184619579 23242 0 Asian Games 36 2026-06-07 07:00:47 2026-06-07 07:00:47 1   International Results CSV 1 elo://23242/away
46978 Nepal 198 1999-04-25 1115.0660411462993 40.0 26.815672761744054 23489 1 SAFF Cup 122 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23489/away
46983 Nepal 198 1999-04-27 1099.1989014277463 40.0 -15.867139718553062 23492 1 SAFF Cup 122 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23492/home
47020 Nepal 198 1999-04-29 1088.2355982295696 40.0 -10.963303198176618 23510 1 SAFF Cup 122 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23510/away
47026 Nepal 198 1999-05-01 1074.0208228938136 40.0 -14.21477533575603 23513 1 SAFF Cup 122 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23513/away
47797 Nepal 198 1999-09-26 1105.3630407424998 40.0 31.342217848686232 23899 0 South Asian Games 93 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23899/home
47805 Nepal 198 1999-09-28 1128.7151483631512 40.0 23.352107620651395 23903 0 South Asian Games 93 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23903/home
47811 Nepal 198 1999-09-30 1121.7600032077676 40.0 -6.955145155383661 23906 0 South Asian Games 93 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23906/home
47817 Nepal 198 1999-10-02 1148.6695381358952 40.0 26.90953492812764 23909 0 South Asian Games 93 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23909/home
47823 Nepal 198 1999-10-04 1136.164146353066 40.0 -12.505391782829292 23912 0 South Asian Games 93 2026-06-07 07:00:48 2026-06-07 07:00:48 1   International Results CSV 1 elo://23912/home
48325 Nepal 198 2000-02-10 1127.0709048363722 40.0 -9.093241516693752 24163 1 AFC Asian Cup qualification 40 2026-06-07 07:00:49 2026-06-07 07:00:49 1   International Results CSV 1 elo://24163/home
48335 Nepal 198 2000-02-12 1152.6472020055267 40.0 25.576297169154486 24168 1 AFC Asian Cup qualification 40 2026-06-07 07:00:49 2026-06-07 07:00:49 1   International Results CSV 1 elo://24168/home

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE elo_record (
            elo_id INTEGER NOT NULL,
            team_id INTEGER NOT NULL,
            date DATE NOT NULL,
            rating FLOAT NOT NULL,
            k_factor FLOAT NOT NULL,
            delta FLOAT,
            source_match_id INTEGER,
            is_tournament BOOLEAN NOT NULL,
            competition_id INTEGER,
            created_at DATETIME NOT NULL,
            updated_at DATETIME NOT NULL,
            created_by_run_id INTEGER,
            updated_by_run_id INTEGER,
            source_id INTEGER NOT NULL,
            source_raw_key VARCHAR(512),
            CONSTRAINT pk_elo_record PRIMARY KEY (elo_id),
            CONSTRAINT fk_elo_record_team FOREIGN KEY(team_id) REFERENCES team (team_id),
            CONSTRAINT fk_elo_record_match FOREIGN KEY(source_match_id) REFERENCES match (match_id),
            CONSTRAINT fk_elo_record_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
            CONSTRAINT fk_elo_record_competition FOREIGN KEY(competition_id) REFERENCES competition (competition_id)
        );
Powered by Datasette · Queries took 1165.391ms