home / football

h2h_record

93 rows where team_a_id = 76

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_b_id, total_matches, wins_a, wins_b, draws, goals_a, last_result, date (date), last_match_date (date), created_at (date), updated_at (date)

h2h_id ▼ team_a_id team_b_id date total_matches wins_a wins_b draws goals_a goals_b last_match_date last_result last_match_id competition_id created_at updated_at created_by_run_id updated_by_run_id source_id source_raw_key
2593 Nicaragua 76 Panama 87 1941-05-18 0 0 0 0 0 0         2026-06-07 07:03:18.454717 2026-06-07 07:03:18.454717 1   International Results CSV 1 h2h://76:87/1941-05-18
2827 Nicaragua 76 Panama 87 1946-03-10 1 0 1 0 2 5 1941-05-18 W     2026-06-07 07:03:18.457461 2026-06-07 07:03:18.457461 1   International Results CSV 1 h2h://87:76/1946-03-10
3473 Nicaragua 76 Panama 87 1951-02-28 2 1 1 0 4 5 1946-03-10 L     2026-06-07 07:03:18.463162 2026-06-07 07:03:18.463162 1   International Results CSV 1 h2h://87:76/1951-02-28
3476 Nicaragua 76 Panama 87 1951-03-04 3 1 2 0 4 9 1951-02-28 W     2026-06-07 07:03:18.463186 2026-06-07 07:03:18.463186 1   International Results CSV 1 h2h://87:76/1951-03-04
3717 Nicaragua 76 Panama 87 1953-03-14 4 1 3 0 6 15 1951-03-04 W     2026-06-07 07:03:18.465287 2026-06-07 07:03:18.465287 1   International Results CSV 1 h2h://87:76/1953-03-14
5747 Nicaragua 76 Panama 87 1963-03-29 5 2 3 0 8 15 1953-03-14 W     2026-06-07 07:03:19.019615 2026-06-07 07:03:19.019615 1   International Results CSV 1 h2h://76:87/1963-03-29
6545 Nicaragua 76 Panama 87 1966-02-08 6 2 4 0 8 20 1963-03-29 W     2026-06-07 07:03:19.171350 2026-06-07 07:03:19.171350 1   International Results CSV 1 h2h://87:76/1966-02-08
6944 Nicaragua 76 Panama 87 1967-02-09 7 2 5 0 9 23 1966-02-08 L     2026-06-07 07:03:19.247118 2026-06-07 07:03:19.247118 1   International Results CSV 1 h2h://76:87/1967-02-09
9579 Nicaragua 76 Panama 87 1973-12-02 8 3 5 0 12 24 1967-02-09 L     2026-06-07 07:03:19.761063 2026-06-07 07:03:19.761063 1   International Results CSV 1 h2h://87:76/1973-12-02
14105 Nicaragua 76 Panama 87 1984-04-27 9 3 6 0 12 26 1973-12-02 W     2026-06-07 07:03:20.959492 2026-06-07 07:03:20.959492 1   International Results CSV 1 h2h://87:76/1984-04-27
20606 Nicaragua 76 Panama 87 1995-10-22 10 3 7 0 12 28 1984-04-27 W     2026-06-07 07:03:22.861597 2026-06-07 07:03:22.861598 1   International Results CSV 1 h2h://87:76/1995-10-22
20614 Nicaragua 76 Panama 87 1995-10-29 11 3 8 0 12 30 1995-10-22 L     2026-06-07 07:03:22.863123 2026-06-07 07:03:22.863124 1   International Results CSV 1 h2h://76:87/1995-10-29
24247 Nicaragua 76 Cuba 77 2000-03-09 0 0 0 0 0 0         2026-06-07 07:03:23.562977 2026-06-07 07:03:23.562977 1   International Results CSV 1 h2h://77:76/2000-03-09
24271 Nicaragua 76 Panama 87 2000-03-19 12 3 9 0 12 35 1995-10-29 L     2026-06-07 07:03:23.567724 2026-06-07 07:03:23.567724 1   International Results CSV 1 h2h://76:87/2000-03-19
24499 Nicaragua 76 Panama 87 2000-05-21 13 3 10 0 12 37 2000-03-19 W     2026-06-07 07:03:23.611678 2026-06-07 07:03:23.611678 1   International Results CSV 1 h2h://87:76/2000-05-21
25449 Nicaragua 76 Belize 225 2001-04-24 0 0 0 0 0 0         2026-06-07 07:03:24.124451 2026-06-07 07:03:24.124452 1   International Results CSV 1 h2h://225:76/2001-04-24
25486 Nicaragua 76 Belize 225 2001-04-26 1 0 1 0 0 2 2001-04-24 W     2026-06-07 07:03:24.131508 2026-06-07 07:03:24.131508 1   International Results CSV 1 h2h://225:76/2001-04-26
25579 Nicaragua 76 Panama 87 2001-05-27 14 3 11 0 12 41 2000-05-21 W     2026-06-07 07:03:24.149288 2026-06-07 07:03:24.149288 1   International Results CSV 1 h2h://87:76/2001-05-27
26330 Nicaragua 76 Belize 225 2002-04-17 2 0 2 0 1 4 2001-04-26 W     2026-06-07 07:03:24.292861 2026-06-07 07:03:24.292862 1   International Results CSV 1 h2h://225:76/2002-04-17
26757 Nicaragua 76 Cayman Islands 226 2002-11-17 0 0 0 0 0 0         2026-06-07 07:03:24.375185 2026-06-07 07:03:24.375186 1   International Results CSV 1 h2h://226:76/2002-11-17
26976 Nicaragua 76 Panama 87 2003-02-21 15 3 12 0 12 47 2001-05-27 W     2026-06-07 07:03:24.417686 2026-06-07 07:03:24.417686 1   International Results CSV 1 h2h://87:76/2003-02-21
28018 Nicaragua 76 Bermuda 180 2004-03-31 0 0 0 0 0 0         2026-06-07 07:03:24.617158 2026-06-07 07:03:24.617158 1   International Results CSV 1 h2h://180:76/2004-03-31
28064 Nicaragua 76 Bermuda 180 2004-04-02 1 0 1 0 0 3 2004-03-31 W     2026-06-07 07:03:24.625956 2026-06-07 07:03:24.625957 1   International Results CSV 1 h2h://180:76/2004-04-02
28113 Nicaragua 76 Bermuda 180 2004-04-30 2 0 2 0 1 5 2004-04-02 L     2026-06-07 07:03:24.635219 2026-06-07 07:03:24.635219 1   International Results CSV 1 h2h://76:180/2004-04-30
28116 Nicaragua 76 Bermuda 180 2004-05-02 3 1 2 0 3 5 2004-04-30 W     2026-06-07 07:03:24.635805 2026-06-07 07:03:24.635806 1   International Results CSV 1 h2h://76:180/2004-05-02
28298 Nicaragua 76 Saint Vincent and the Grenadines 165 2004-06-13 0 0 0 0 0 0         2026-06-07 07:03:24.670617 2026-06-07 07:03:24.670617 1   International Results CSV 1 h2h://76:165/2004-06-13
28343 Nicaragua 76 Saint Vincent and the Grenadines 165 2004-06-20 1 0 0 1 2 2 2004-06-13 D     2026-06-07 07:03:24.679200 2026-06-07 07:03:24.679201 1   International Results CSV 1 h2h://165:76/2004-06-20
29011 Nicaragua 76 Belize 225 2005-02-23 3 0 3 0 2 11 2002-04-17 L     2026-06-07 07:03:24.807077 2026-06-07 07:03:24.807078 1   International Results CSV 1 h2h://76:225/2005-02-23
30669 Nicaragua 76 Belize 225 2007-02-12 4 1 3 0 3 11 2005-02-23 W     2026-06-07 07:03:25.457400 2026-06-07 07:03:25.457400 1   International Results CSV 1 h2h://76:225/2007-02-12
32712 Nicaragua 76 Belize 225 2009-01-26 5 2 3 0 7 13 2007-02-12 W     2026-06-07 07:03:25.851931 2026-06-07 07:03:25.851932 1   International Results CSV 1 h2h://76:225/2009-01-26
33132 Nicaragua 76 Guadeloupe 81 2009-07-09 0 0 0 0 0 0         2026-06-07 07:03:25.932516 2026-06-07 07:03:25.932517 1   International Results CSV 1 h2h://81:76/2009-07-09
33141 Nicaragua 76 Panama 87 2009-07-12 16 4 12 0 13 47 2003-02-21 L     2026-06-07 07:03:25.934232 2026-06-07 07:03:25.934232 1   International Results CSV 1 h2h://87:76/2009-07-12
34476 Nicaragua 76 Panama 87 2011-01-16 17 4 13 0 13 51 2009-07-12 W     2026-06-07 07:03:26.189476 2026-06-07 07:03:26.189476 1   International Results CSV 1 h2h://87:76/2011-01-16
34486 Nicaragua 76 Belize 225 2011-01-18 6 2 3 1 8 14 2009-01-26 D     2026-06-07 07:03:26.191407 2026-06-07 07:03:26.191407 1   International Results CSV 1 h2h://76:225/2011-01-18
34704 Nicaragua 76 Cuba 77 2011-05-26 1 0 1 0 0 4 2000-03-09 W     2026-06-07 07:03:26.233112 2026-06-07 07:03:26.233112 1   International Results CSV 1 h2h://77:76/2011-05-26
34707 Nicaragua 76 Cuba 77 2011-05-28 2 0 1 1 1 5 2011-05-26 D     2026-06-07 07:03:26.233713 2026-06-07 07:03:26.233713 1   International Results CSV 1 h2h://77:76/2011-05-28
35084 Nicaragua 76 Dominica 79 2011-09-02 0 0 0 0 0 0         2026-06-07 07:03:26.654774 2026-06-07 07:03:26.654774 1   International Results CSV 1 h2h://79:76/2011-09-02
35194 Nicaragua 76 Panama 87 2011-09-06 18 4 14 0 13 53 2011-01-16 L     2026-06-07 07:03:26.675778 2026-06-07 07:03:26.675778 1   International Results CSV 1 h2h://76:87/2011-09-06
35341 Nicaragua 76 Panama 87 2011-10-11 19 4 15 0 14 55 2011-09-06 W     2026-06-07 07:03:26.704059 2026-06-07 07:03:26.704059 1   International Results CSV 1 h2h://87:76/2011-10-11
35399 Nicaragua 76 Dominica 79 2011-11-11 1 1 0 0 2 0 2011-09-02 W     2026-06-07 07:03:26.715174 2026-06-07 07:03:26.715174 1   International Results CSV 1 h2h://76:79/2011-11-11
35624 Nicaragua 76 Puerto Rico 97 2012-02-24 0 0 0 0 0 0         2026-06-07 07:03:26.758275 2026-06-07 07:03:26.758275 1   International Results CSV 1 h2h://76:97/2012-02-24
35629 Nicaragua 76 Puerto Rico 97 2012-02-26 1 1 0 0 1 0 2012-02-24 W     2026-06-07 07:03:26.759214 2026-06-07 07:03:26.759214 1   International Results CSV 1 h2h://76:97/2012-02-26
35823 Nicaragua 76 Puerto Rico 97 2012-06-01 2 2 0 0 5 1 2012-02-26 L     2026-06-07 07:03:26.796155 2026-06-07 07:03:26.796155 1   International Results CSV 1 h2h://97:76/2012-06-01
35862 Nicaragua 76 Puerto Rico 97 2012-06-03 3 2 1 0 6 4 2012-06-01 W     2026-06-07 07:03:26.803674 2026-06-07 07:03:26.803675 1   International Results CSV 1 h2h://97:76/2012-06-03
36632 Nicaragua 76 Belize 225 2013-01-22 7 2 3 2 9 15 2011-01-18 D     2026-06-07 07:03:26.952318 2026-06-07 07:03:26.952318 1   International Results CSV 1 h2h://76:225/2013-01-22
38511 Nicaragua 76 Anguilla 227 2015-03-23 0 0 0 0 0 0         2026-06-07 07:03:27.326661 2026-06-07 07:03:27.326662 1   International Results CSV 1 h2h://76:227/2015-03-23
38571 Nicaragua 76 Anguilla 227 2015-03-29 1 1 0 0 5 0 2015-03-23 L     2026-06-07 07:03:27.338557 2026-06-07 07:03:27.338558 1   International Results CSV 1 h2h://227:76/2015-03-29
39420 Nicaragua 76 Cuba 77 2015-12-08 3 0 2 1 2 7 2011-05-28 L     2026-06-07 07:03:27.507476 2026-06-07 07:03:27.507476 1   International Results CSV 1 h2h://76:77/2015-12-08
39421 Nicaragua 76 Cuba 77 2015-12-11 4 1 2 1 7 7 2015-12-08 W     2026-06-07 07:03:27.507669 2026-06-07 07:03:27.507669 1   International Results CSV 1 h2h://76:77/2015-12-11
40397 Nicaragua 76 Belize 225 2017-01-20 8 2 4 2 10 17 2013-01-22 L     2026-06-07 07:03:28.046190 2026-06-07 07:03:28.046190 1   International Results CSV 1 h2h://76:225/2017-01-20
40830 Nicaragua 76 Martinique 78 2017-07-08 0 0 0 0 0 0         2026-06-07 07:03:28.129019 2026-06-07 07:03:28.129020 1   International Results CSV 1 h2h://78:76/2017-07-08
40837 Nicaragua 76 Panama 87 2017-07-12 20 4 16 0 15 60 2011-10-11 W     2026-06-07 07:03:28.130382 2026-06-07 07:03:28.130383 1   International Results CSV 1 h2h://87:76/2017-07-12
41116 Nicaragua 76 Dominican Republic 117 2017-11-08 0 0 0 0 0 0         2026-06-07 07:03:28.183977 2026-06-07 07:03:28.183977 1   International Results CSV 1 h2h://76:117/2017-11-08
41146 Nicaragua 76 Dominican Republic 117 2017-11-11 1 0 1 0 0 3 2017-11-08 W     2026-06-07 07:03:28.189714 2026-06-07 07:03:28.189715 1   International Results CSV 1 h2h://117:76/2017-11-11
41321 Nicaragua 76 Cuba 77 2018-03-22 5 2 2 1 8 7 2015-12-11 W     2026-06-07 07:03:28.223438 2026-06-07 07:03:28.223438 1   International Results CSV 1 h2h://76:77/2018-03-22
41378 Nicaragua 76 Cuba 77 2018-03-25 6 3 2 1 11 8 2018-03-22 W     2026-06-07 07:03:28.234409 2026-06-07 07:03:28.234409 1   International Results CSV 1 h2h://76:77/2018-03-25
41779 Nicaragua 76 Saint Vincent and the Grenadines 165 2018-09-08 2 0 1 1 3 6 2004-06-20 W     2026-06-07 07:03:28.311774 2026-06-07 07:03:28.311774 1   International Results CSV 1 h2h://165:76/2018-09-08
41955 Nicaragua 76 Anguilla 227 2018-10-14 2 2 0 0 8 0 2015-03-29 W     2026-06-07 07:03:28.345853 2026-06-07 07:03:28.345853 1   International Results CSV 1 h2h://76:227/2018-10-14
42664 Nicaragua 76 Bermuda 180 2019-06-24 4 2 2 0 5 5 2004-05-02 L     2026-06-07 07:03:28.482496 2026-06-07 07:03:28.482496 1   International Results CSV 1 h2h://180:76/2019-06-24
42869 Nicaragua 76 Saint Vincent and the Grenadines 165 2019-09-06 3 1 1 1 5 6 2018-09-08 W     2026-06-07 07:03:28.524583 2026-06-07 07:03:28.524583 1   International Results CSV 1 h2h://76:165/2019-09-06
43042 Nicaragua 76 Dominica 79 2019-10-11 2 2 0 0 3 0 2011-11-11 W     2026-06-07 07:03:28.559643 2026-06-07 07:03:28.559643 1   International Results CSV 1 h2h://76:79/2019-10-11
43101 Nicaragua 76 Dominica 79 2019-10-14 3 3 0 0 6 1 2019-10-11 L     2026-06-07 07:03:28.571447 2026-06-07 07:03:28.571447 1   International Results CSV 1 h2h://79:76/2019-10-14
43148 Nicaragua 76 Cuba 77 2019-11-07 7 3 2 2 14 11 2018-03-25 D     2026-06-07 07:03:28.580811 2026-06-07 07:03:28.580812 1   International Results CSV 1 h2h://76:77/2019-11-07
43152 Nicaragua 76 Cuba 77 2019-11-10 8 3 2 3 14 11 2019-11-07 D     2026-06-07 07:03:28.581598 2026-06-07 07:03:28.581598 1   International Results CSV 1 h2h://76:77/2019-11-10
43224 Nicaragua 76 Saint Vincent and the Grenadines 165 2019-11-15 4 1 1 2 6 7 2019-09-06 D     2026-06-07 07:03:28.595926 2026-06-07 07:03:28.595926 1   International Results CSV 1 h2h://165:76/2019-11-15
43800 Nicaragua 76 Turks and Caicos Islands 255 2021-03-27 0 0 0 0 0 0         2026-06-07 07:03:28.710907 2026-06-07 07:03:28.710907 1   International Results CSV 1 h2h://255:76/2021-03-27
43980 Nicaragua 76 Belize 225 2021-06-04 9 3 4 2 13 18 2017-01-20 W     2026-06-07 07:03:28.746587 2026-06-07 07:03:28.746587 1   International Results CSV 1 h2h://76:225/2021-06-04
44613 Nicaragua 76 Cuba 77 2021-11-10 9 3 3 3 14 12 2019-11-10 L     2026-06-07 07:03:28.874098 2026-06-07 07:03:28.874098 1   International Results CSV 1 h2h://76:77/2021-11-10
44667 Nicaragua 76 Cuba 77 2021-11-13 10 3 4 3 14 15 2021-11-10 L     2026-06-07 07:03:28.884972 2026-06-07 07:03:28.884972 1   International Results CSV 1 h2h://76:77/2021-11-13
44685 Nicaragua 76 Cuba 77 2021-11-14 11 4 4 3 16 15 2021-11-13 W     2026-06-07 07:03:28.888510 2026-06-07 07:03:28.888510 1   International Results CSV 1 h2h://76:77/2021-11-14
44904 Nicaragua 76 Belize 225 2022-01-29 10 4 4 2 16 18 2021-06-04 W     2026-06-07 07:03:28.932576 2026-06-07 07:03:28.932577 1   International Results CSV 1 h2h://76:225/2022-01-29
44917 Nicaragua 76 Belize 225 2022-02-01 11 5 4 2 20 18 2022-01-29 W     2026-06-07 07:03:28.935165 2026-06-07 07:03:28.935166 1   International Results CSV 1 h2h://76:225/2022-02-01
45238 Nicaragua 76 Saint Vincent and the Grenadines 165 2022-06-06 5 1 2 2 6 8 2019-11-15 W     2026-06-07 07:03:29.354746 2026-06-07 07:03:29.354746 1   International Results CSV 1 h2h://165:76/2022-06-06
45320 Nicaragua 76 Bahamas 192 2022-06-10 0 0 0 0 0 0         2026-06-07 07:03:29.370227 2026-06-07 07:03:29.370228 1   International Results CSV 1 h2h://192:76/2022-06-10
45382 Nicaragua 76 Bahamas 192 2022-06-13 1 1 0 0 2 0 2022-06-10 W     2026-06-07 07:03:29.381998 2026-06-07 07:03:29.381998 1   International Results CSV 1 h2h://76:192/2022-06-13
45572 Nicaragua 76 Ghana 124 2022-09-27 0 0 0 0 0 0         2026-06-07 07:03:29.418236 2026-06-07 07:03:29.418236 1   International Results CSV 1 h2h://124:76/2022-09-27
45615 Nicaragua 76 Iran 99 2022-11-10 0 0 0 0 0 0         2026-06-07 07:03:29.426364 2026-06-07 07:03:29.426365 1   International Results CSV 1 h2h://99:76/2022-11-10
45900 Nicaragua 76 Saint Vincent and the Grenadines 165 2023-03-24 6 1 2 3 8 10 2022-06-06 D     2026-06-07 07:03:29.481147 2026-06-07 07:03:29.481147 1   International Results CSV 1 h2h://76:165/2023-03-24
46020 Nicaragua 76 Panama 87 2023-06-10 21 4 17 0 16 62 2017-07-12 W     2026-06-07 07:03:29.503942 2026-06-07 07:03:29.503942 1   International Results CSV 1 h2h://87:76/2023-06-10
46340 Nicaragua 76 Dominican Republic 117 2023-09-08 2 0 2 0 0 4 2017-11-11 W     2026-06-07 07:03:29.565181 2026-06-07 07:03:29.565181 1   International Results CSV 1 h2h://117:76/2023-09-08
46505 Nicaragua 76 Montserrat 237 2023-10-13 0 0 0 0 0 0         2026-06-07 07:03:29.596988 2026-06-07 07:03:29.596989 1   International Results CSV 1 h2h://237:76/2023-10-13
46563 Nicaragua 76 Montserrat 237 2023-10-16 1 1 0 0 3 0 2023-10-13 W     2026-06-07 07:03:29.608157 2026-06-07 07:03:29.608158 1   International Results CSV 1 h2h://76:237/2023-10-16
46770 Nicaragua 76 Dominican Republic 117 2023-11-21 3 1 2 0 2 4 2023-09-08 W     2026-06-07 07:03:29.648325 2026-06-07 07:03:29.648325 1   International Results CSV 1 h2h://76:117/2023-11-21
47144 Nicaragua 76 Cuba 77 2024-03-26 12 5 4 3 18 15 2021-11-14 W     2026-06-07 07:03:29.721199 2026-06-07 07:03:29.721199 1   International Results CSV 1 h2h://76:77/2024-03-26
47197 Nicaragua 76 Montserrat 237 2024-06-05 2 2 0 0 6 0 2023-10-16 W     2026-06-07 07:03:29.731474 2026-06-07 07:03:29.731474 1   International Results CSV 1 h2h://76:237/2024-06-05
47274 Nicaragua 76 Belize 225 2024-06-08 12 5 4 3 21 19 2022-02-01 D     2026-06-07 07:03:29.746212 2026-06-07 07:03:29.746212 1   International Results CSV 1 h2h://225:76/2024-06-08
47522 Nicaragua 76 French Guiana 84 2024-09-06 0 0 0 0 0 0         2026-06-07 07:03:29.794199 2026-06-07 07:03:29.794199 1   International Results CSV 1 h2h://84:76/2024-09-06
47622 Nicaragua 76 Cuba 77 2024-09-10 13 5 5 3 18 16 2024-03-26 W     2026-06-07 07:03:29.813321 2026-06-07 07:03:29.813322 1   International Results CSV 1 h2h://77:76/2024-09-10
47770 Nicaragua 76 French Guiana 84 2024-10-14 1 1 0 0 1 0 2024-09-06 W     2026-06-07 07:03:29.841620 2026-06-07 07:03:29.841620 1   International Results CSV 1 h2h://76:84/2024-10-14
48148 Nicaragua 76 Guadeloupe 81 2025-03-21 1 0 1 0 0 2 2009-07-09 W     2026-06-07 07:03:29.914181 2026-06-07 07:03:29.914181 1   International Results CSV 1 h2h://81:76/2025-03-21
48233 Nicaragua 76 Guadeloupe 81 2025-03-25 2 0 2 0 0 3 2025-03-21 L     2026-06-07 07:03:29.930318 2026-06-07 07:03:29.930318 1   International Results CSV 1 h2h://76:81/2025-03-25
48292 Nicaragua 76 Puerto Rico 97 2025-06-01 4 2 1 1 7 5 2012-06-03 D     2026-06-07 07:03:29.941635 2026-06-07 07:03:29.941635 1   International Results CSV 1 h2h://97:76/2025-06-01
48450 Nicaragua 76 Panama 87 2025-06-10 22 4 18 0 18 65 2023-06-10 W     2026-06-07 07:03:29.971812 2026-06-07 07:03:29.971812 1   International Results CSV 1 h2h://87:76/2025-06-10

Advanced export

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

CSV options:

CREATE TABLE h2h_record (
            h2h_id INTEGER NOT NULL,
            team_a_id INTEGER NOT NULL,
            team_b_id INTEGER NOT NULL,
            date DATE NOT NULL,
            total_matches INTEGER NOT NULL,
            wins_a INTEGER NOT NULL,
            wins_b INTEGER NOT NULL,
            draws INTEGER NOT NULL,
            goals_a INTEGER NOT NULL,
            goals_b INTEGER NOT NULL,
            last_match_date DATE,
            last_result VARCHAR(1),
            last_match_id INTEGER,
            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_h2h_record PRIMARY KEY (h2h_id),
            CONSTRAINT fk_h2h_record_team_a FOREIGN KEY(team_a_id) REFERENCES team (team_id),
            CONSTRAINT fk_h2h_record_team_b FOREIGN KEY(team_b_id) REFERENCES team (team_id),
            CONSTRAINT fk_h2h_record_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
            CONSTRAINT fk_h2h_record_match FOREIGN KEY(last_match_id) REFERENCES match (match_id),
            CONSTRAINT fk_h2h_record_competition FOREIGN KEY(competition_id) REFERENCES competition (competition_id)
        );
Powered by Datasette · Queries took 890.72ms