home / football

h2h_record

493 rows where team_a_id = 796

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: wins_b, draws, 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
50298 Roma 796 Sampdoria 803 1995-08-27 0 0 0 0 0 0         2026-06-11 10:24:41.204488 2026-06-11 10:24:41.204488     International Results CSV 1 h2h://803:796/1995-08-27
50443 Roma 796 Cremonese 801 1995-09-24 0 0 0 0 0 0         2026-06-11 10:24:41.205612 2026-06-11 10:24:41.205612     International Results CSV 1 h2h://801:796/1995-09-24
50546 Roma 796 Torino 797 1995-10-15 0 0 0 0 0 0         2026-06-11 10:24:41.206469 2026-06-11 10:24:41.206469     International Results CSV 1 h2h://797:796/1995-10-15
50674 Roma 796 Padova 1306 1995-11-05 0 0 0 0 0 0         2026-06-11 10:24:41.207423 2026-06-11 10:24:41.207423     International Results CSV 1 h2h://796:1306/1995-11-05
50737 Roma 796 Vicenza 1305 1995-11-19 0 0 0 0 0 0         2026-06-11 10:24:41.208121 2026-06-11 10:24:41.208121     International Results CSV 1 h2h://1305:796/1995-11-19
50766 Roma 796 Aris 911 1995-11-26 0 0 0 0 0 0         2026-06-11 10:24:41.208434 2026-06-11 10:24:41.208434     International Results CSV 1 h2h://796:911/1995-11-26
50812 Roma 796 Udinese 798 1995-12-03 0 0 0 0 0 0         2026-06-11 10:24:41.208921 2026-06-11 10:24:41.208921     International Results CSV 1 h2h://798:796/1995-12-03
50859 Roma 796 Vicenza 1305 1995-12-10 1 0 1 0 0 1 1995-11-19 L     2026-06-11 10:24:41.209416 2026-06-11 10:24:41.209416     International Results CSV 1 h2h://796:1305/1995-12-10
51006 Roma 796 Inter 1304 1996-01-14 0 0 0 0 0 0         2026-06-11 10:24:41.210717 2026-06-11 10:24:41.210717     International Results CSV 1 h2h://1304:796/1996-01-14
51025 Roma 796 Sampdoria 803 1996-01-21 1 0 0 1 1 1 1995-08-27 D     2026-06-11 10:24:41.210947 2026-06-11 10:24:41.210948     International Results CSV 1 h2h://796:803/1996-01-21
51122 Roma 796 Cremonese 801 1996-02-11 1 1 0 0 1 0 1995-09-24 W     2026-06-11 10:24:41.211885 2026-06-11 10:24:41.211885     International Results CSV 1 h2h://796:801/1996-02-11
51191 Roma 796 Torino 797 1996-02-25 1 0 0 1 2 2 1995-10-15 D     2026-06-11 10:24:41.212515 2026-06-11 10:24:41.212516     International Results CSV 1 h2h://796:797/1996-02-25
51353 Roma 796 Vicenza 1305 1996-03-24 2 0 1 1 1 2 1995-12-10 D     2026-06-11 10:24:41.213891 2026-06-11 10:24:41.213891     International Results CSV 1 h2h://796:1305/1996-03-24
51387 Roma 796 Aris 911 1996-03-31 1 1 0 0 2 1 1995-11-26 L     2026-06-11 10:24:41.214295 2026-06-11 10:24:41.214295     International Results CSV 1 h2h://911:796/1996-03-31
51416 Roma 796 Udinese 798 1996-04-06 1 0 0 1 1 1 1995-12-03 D     2026-06-11 10:24:41.214508 2026-06-11 10:24:41.214508     International Results CSV 1 h2h://796:798/1996-04-06
51471 Roma 796 Padova 1306 1996-04-10 1 1 0 0 2 0 1995-11-05 L     2026-06-11 10:24:41.214938 2026-06-11 10:24:41.214938     International Results CSV 1 h2h://1306:796/1996-04-10
51509 Roma 796 Vicenza 1305 1996-04-14 3 1 1 1 3 3 1996-03-24 L     2026-06-11 10:24:41.215221 2026-06-11 10:24:41.215221     International Results CSV 1 h2h://1305:796/1996-04-14
51668 Roma 796 Inter 1304 1996-05-12 1 0 1 0 0 2 1996-01-14 L     2026-06-11 10:24:41.216786 2026-06-11 10:24:41.216786     International Results CSV 1 h2h://796:1304/1996-05-12
51823 Roma 796 Vicenza 1305 1996-09-08 4 1 2 1 4 5 1996-04-14 L     2026-06-11 10:24:41.219808 2026-06-11 10:24:41.219808     International Results CSV 1 h2h://796:1305/1996-09-08
51863 Roma 796 Vicenza 1305 1996-09-15 5 2 2 1 7 6 1996-09-08 L     2026-06-11 10:24:41.220210 2026-06-11 10:24:41.220210     International Results CSV 1 h2h://1305:796/1996-09-15
51894 Roma 796 Sampdoria 803 1996-09-22 2 1 0 1 4 2 1996-01-21 W     2026-06-11 10:24:41.220540 2026-06-11 10:24:41.220541     International Results CSV 1 h2h://796:803/1996-09-22
51941 Roma 796 Reggiana 1307 1996-09-29 0 0 0 0 0 0         2026-06-11 10:24:41.220966 2026-06-11 10:24:41.220966     International Results CSV 1 h2h://1307:796/1996-09-29
52033 Roma 796 Verona 800 1996-10-20 0 0 0 0 0 0         2026-06-11 10:24:41.221992 2026-06-11 10:24:41.221992     International Results CSV 1 h2h://800:796/1996-10-20
52388 Roma 796 Inter 1304 1997-01-05 2 1 1 0 1 2 1996-05-12 L     2026-06-11 10:24:41.225688 2026-06-11 10:24:41.225688     International Results CSV 1 h2h://1304:796/1997-01-05
52435 Roma 796 Udinese 798 1997-01-19 2 1 0 1 3 2 1996-04-06 L     2026-06-11 10:24:41.226222 2026-06-11 10:24:41.226223     International Results CSV 1 h2h://798:796/1997-01-19
52467 Roma 796 Vicenza 1305 1997-01-26 6 3 2 1 9 6 1996-09-15 L     2026-06-11 10:24:41.226574 2026-06-11 10:24:41.226574     International Results CSV 1 h2h://1305:796/1997-01-26
52506 Roma 796 Vicenza 1305 1997-02-02 7 3 2 2 9 6 1997-01-26 D     2026-06-11 10:24:41.226900 2026-06-11 10:24:41.226900     International Results CSV 1 h2h://796:1305/1997-02-02
52535 Roma 796 Sampdoria 803 1997-02-16 3 1 1 1 5 6 1996-09-22 W     2026-06-11 10:24:41.227296 2026-06-11 10:24:41.227297     International Results CSV 1 h2h://803:796/1997-02-16
52600 Roma 796 Reggiana 1307 1997-02-23 1 0 0 1 1 1 1996-09-29 D     2026-06-11 10:24:41.227957 2026-06-11 10:24:41.227957     International Results CSV 1 h2h://796:1307/1997-02-23
52673 Roma 796 Verona 800 1997-03-09 1 0 1 0 1 2 1996-10-20 L     2026-06-11 10:24:41.228672 2026-06-11 10:24:41.228672     International Results CSV 1 h2h://796:800/1997-03-09
53074 Roma 796 Inter 1304 1997-05-18 3 1 2 0 2 5 1997-01-05 L     2026-06-11 10:24:41.233040 2026-06-11 10:24:41.233040     International Results CSV 1 h2h://796:1304/1997-05-18
53119 Roma 796 Udinese 798 1997-06-01 3 1 1 1 3 3 1997-01-19 L     2026-06-11 10:24:41.233570 2026-06-11 10:24:41.233570     International Results CSV 1 h2h://796:798/1997-06-01
53571 Roma 796 Aris 911 1997-11-09 2 2 0 0 4 2 1996-03-31 L     2026-06-11 10:24:41.239811 2026-06-11 10:24:41.239811     International Results CSV 1 h2h://911:796/1997-11-09
53653 Roma 796 Vicenza 1305 1997-11-23 8 4 2 2 11 6 1997-02-02 W     2026-06-11 10:24:41.240571 2026-06-11 10:24:41.240571     International Results CSV 1 h2h://796:1305/1997-11-23
53766 Roma 796 Inter 1304 1997-12-14 4 1 2 1 3 6 1997-05-18 D     2026-06-11 10:24:41.241639 2026-06-11 10:24:41.241639     International Results CSV 1 h2h://1304:796/1997-12-14
53815 Roma 796 Brescia 1308 1997-12-21 0 0 0 0 0 0         2026-06-11 10:24:41.242105 2026-06-11 10:24:41.242105     International Results CSV 1 h2h://1308:796/1997-12-21
53847 Roma 796 Udinese 798 1998-01-04 4 1 2 1 3 6 1997-06-01 L     2026-06-11 10:24:41.242451 2026-06-11 10:24:41.242452     International Results CSV 1 h2h://796:798/1998-01-04
53912 Roma 796 Vicenza 1305 1998-01-18 9 4 2 3 13 8 1997-11-23 D     2026-06-11 10:24:41.243039 2026-06-11 10:24:41.243039     International Results CSV 1 h2h://796:1305/1998-01-18
53924 Roma 796 Sampdoria 803 1998-01-25 4 2 1 1 7 7 1997-02-16 L     2026-06-11 10:24:41.243183 2026-06-11 10:24:41.243183     International Results CSV 1 h2h://803:796/1998-01-25
54187 Roma 796 Aris 911 1998-03-15 3 3 0 0 7 3 1997-11-09 W     2026-06-11 10:24:41.245961 2026-06-11 10:24:41.245961     International Results CSV 1 h2h://796:911/1998-03-15
54222 Roma 796 Vicenza 1305 1998-03-22 10 4 2 4 14 9 1998-01-18 D     2026-06-11 10:24:41.246292 2026-06-11 10:24:41.246292     International Results CSV 1 h2h://1305:796/1998-03-22
54327 Roma 796 Inter 1304 1998-04-11 5 1 3 1 3 9 1997-12-14 L     2026-06-11 10:24:41.847407 2026-06-11 10:24:41.847407     International Results CSV 1 h2h://796:1304/1998-04-11
54383 Roma 796 Brescia 1308 1998-04-19 1 0 0 1 1 1 1997-12-21 D     2026-06-11 10:24:41.859283 2026-06-11 10:24:41.859283     International Results CSV 1 h2h://796:1308/1998-04-19
54408 Roma 796 Udinese 798 1998-04-26 5 1 3 1 4 8 1998-01-04 W     2026-06-11 10:24:41.867781 2026-06-11 10:24:41.867781     International Results CSV 1 h2h://798:796/1998-04-26
54508 Roma 796 Vicenza 1305 1998-05-10 11 4 2 5 15 10 1998-03-22 D     2026-06-11 10:24:41.887649 2026-06-11 10:24:41.887649     International Results CSV 1 h2h://1305:796/1998-05-10
54522 Roma 796 Sampdoria 803 1998-05-16 5 2 1 2 8 8 1998-01-25 D     2026-06-11 10:24:41.891399 2026-06-11 10:24:41.891399     International Results CSV 1 h2h://796:803/1998-05-16
54657 Roma 796 Salernitana 802 1998-09-12 0 0 0 0 0 0         2026-06-11 10:24:41.970612 2026-06-11 10:24:41.970613     International Results CSV 1 h2h://796:802/1998-09-12
54754 Roma 796 Venezia 799 1998-09-26 0 0 0 0 0 0         2026-06-11 10:24:41.991963 2026-06-11 10:24:41.991963     International Results CSV 1 h2h://796:799/1998-09-26
54814 Roma 796 Sampdoria 803 1998-10-04 6 3 1 2 10 8 1998-05-16 L     2026-06-11 10:24:42.007614 2026-06-11 10:24:42.007615     International Results CSV 1 h2h://803:796/1998-10-04
54940 Roma 796 Udinese 798 1998-10-31 6 1 4 1 6 12 1998-04-26 L     2026-06-11 10:24:42.041198 2026-06-11 10:24:42.041198     International Results CSV 1 h2h://796:798/1998-10-31
55098 Roma 796 Aris 911 1998-11-21 4 4 0 0 9 4 1998-03-15 W     2026-06-11 10:24:42.076982 2026-06-11 10:24:42.076983     International Results CSV 1 h2h://796:911/1998-11-21
55320 Roma 796 Inter 1304 1998-12-20 6 1 4 1 4 11 1998-04-11 W     2026-06-11 10:24:42.128125 2026-06-11 10:24:42.128125     International Results CSV 1 h2h://1304:796/1998-12-20
55361 Roma 796 Vicenza 1305 1999-01-06 12 4 2 6 18 13 1998-05-10 D     2026-06-11 10:24:42.136772 2026-06-11 10:24:42.136773     International Results CSV 1 h2h://796:1305/1999-01-06
55426 Roma 796 Vicenza 1305 1999-01-17 13 4 2 7 20 15 1999-01-06 D     2026-06-11 10:24:42.149560 2026-06-11 10:24:42.149561     International Results CSV 1 h2h://796:1305/1999-01-17
55437 Roma 796 Salernitana 802 1999-01-24 1 1 0 0 3 1 1998-09-12 L     2026-06-11 10:24:42.154563 2026-06-11 10:24:42.154564     International Results CSV 1 h2h://802:796/1999-01-24
55515 Roma 796 Venezia 799 1999-02-07 1 1 0 0 2 0 1998-09-26 L     2026-06-11 10:24:42.171373 2026-06-11 10:24:42.171373     International Results CSV 1 h2h://799:796/1999-02-07
55544 Roma 796 Sampdoria 803 1999-02-14 7 3 2 2 11 10 1998-10-04 L     2026-06-11 10:24:42.179915 2026-06-11 10:24:42.179915     International Results CSV 1 h2h://796:803/1999-02-14
55666 Roma 796 Udinese 798 1999-03-07 7 2 4 1 10 12 1998-10-31 L     2026-06-11 10:24:42.208755 2026-06-11 10:24:42.208755     International Results CSV 1 h2h://798:796/1999-03-07
55787 Roma 796 Aris 911 1999-04-03 5 4 0 1 10 5 1998-11-21 D     2026-06-11 10:24:42.244638 2026-06-11 10:24:42.244639     International Results CSV 1 h2h://911:796/1999-04-03
56019 Roma 796 Inter 1304 1999-05-03 7 1 5 1 5 15 1998-12-20 L     2026-06-11 10:24:42.295062 2026-06-11 10:24:42.295063     International Results CSV 1 h2h://796:1304/1999-05-03
56076 Roma 796 Vicenza 1305 1999-05-09 14 5 2 7 23 15 1999-01-17 L     2026-06-11 10:24:42.307771 2026-06-11 10:24:42.307772     International Results CSV 1 h2h://1305:796/1999-05-09
56157 Roma 796 Vicenza 1305 1999-05-23 15 5 3 7 23 17 1999-05-09 W     2026-06-11 10:24:42.323696 2026-06-11 10:24:42.323696     International Results CSV 1 h2h://1305:796/1999-05-23
56357 Roma 796 Vicenza 1305 1999-08-29 16 6 3 7 27 18 1999-05-23 L     2026-06-11 10:24:42.412384 2026-06-11 10:24:42.412384     International Results CSV 1 h2h://1305:796/1999-08-29
56407 Roma 796 Inter 1304 1999-09-12 8 1 6 1 9 20 1999-05-03 L     2026-06-11 10:24:42.431806 2026-06-11 10:24:42.431807     International Results CSV 1 h2h://796:1304/1999-09-12
56444 Roma 796 Venezia 799 1999-09-19 2 1 1 0 3 3 1999-02-07 W     2026-06-11 10:24:42.440203 2026-06-11 10:24:42.440204     International Results CSV 1 h2h://799:796/1999-09-19
56654 Roma 796 Torino 797 1999-10-24 2 1 0 1 3 2 1996-02-25 L     2026-06-11 10:24:42.489059 2026-06-11 10:24:42.489060     International Results CSV 1 h2h://797:796/1999-10-24
56756 Roma 796 Reggiana 1307 1999-11-07 2 0 0 2 3 3 1997-02-23 D     2026-06-11 10:24:42.510323 2026-06-11 10:24:42.510323     International Results CSV 1 h2h://1307:796/1999-11-07
56844 Roma 796 Udinese 798 1999-11-28 8 2 5 1 11 14 1999-03-07 W     2026-06-11 10:24:42.536514 2026-06-11 10:24:42.536514     International Results CSV 1 h2h://798:796/1999-11-28
57050 Roma 796 Aris 911 2000-01-06 6 5 0 1 14 6 1999-04-03 W     2026-06-11 10:24:42.579066 2026-06-11 10:24:42.579066     International Results CSV 1 h2h://796:911/2000-01-06
57109 Roma 796 Verona 800 2000-01-16 2 1 1 0 5 5 1997-03-09 W     2026-06-11 10:24:42.591753 2026-06-11 10:24:42.591753     International Results CSV 1 h2h://796:800/2000-01-16
57133 Roma 796 Vicenza 1305 2000-01-22 17 6 3 8 28 19 1999-08-29 D     2026-06-11 10:24:42.597475 2026-06-11 10:24:42.597475     International Results CSV 1 h2h://796:1305/2000-01-22
57181 Roma 796 Inter 1304 2000-01-30 9 1 6 2 9 20 1999-09-12 D     2026-06-11 10:24:42.611411 2026-06-11 10:24:42.611411     International Results CSV 1 h2h://1304:796/2000-01-30
57225 Roma 796 Venezia 799 2000-02-06 3 2 1 0 6 4 1999-09-19 W     2026-06-11 10:24:42.625331 2026-06-11 10:24:42.625331     International Results CSV 1 h2h://796:799/2000-02-06
57398 Roma 796 Torino 797 2000-03-05 3 1 0 2 4 3 1999-10-24 D     2026-06-11 10:24:42.676026 2026-06-11 10:24:42.676027     International Results CSV 1 h2h://796:797/2000-03-05
57495 Roma 796 Reggiana 1307 2000-03-19 3 1 0 2 7 3 1999-11-07 W     2026-06-11 10:24:42.698681 2026-06-11 10:24:42.698681     International Results CSV 1 h2h://796:1307/2000-03-19
57569 Roma 796 Udinese 798 2000-04-02 9 3 5 1 13 14 1999-11-28 W     2026-06-11 10:24:42.721716 2026-06-11 10:24:42.721717     International Results CSV 1 h2h://796:798/2000-04-02
57758 Roma 796 Aris 911 2000-04-30 7 6 0 1 17 7 2000-01-06 L     2026-06-11 10:24:42.778887 2026-06-11 10:24:42.778888     International Results CSV 1 h2h://911:796/2000-04-30
57849 Roma 796 Verona 800 2000-05-14 3 2 1 0 8 6 2000-01-16 L     2026-06-11 10:24:42.800850 2026-06-11 10:24:42.800850     International Results CSV 1 h2h://800:796/2000-05-14
58175 Roma 796 Vicenza 1305 2000-10-22 18 7 3 8 30 20 2000-01-22 W     2026-06-11 10:24:42.947356 2026-06-11 10:24:42.947356     International Results CSV 1 h2h://796:1305/2000-10-22
58222 Roma 796 Inter 1304 2000-11-01 10 1 7 2 10 22 2000-01-30 W     2026-06-11 10:24:42.959505 2026-06-11 10:24:42.959506     International Results CSV 1 h2h://1304:796/2000-11-01
58258 Roma 796 Brescia 1308 2000-11-05 2 1 0 1 6 1 1998-04-19 L     2026-06-11 10:24:42.966348 2026-06-11 10:24:42.966348     International Results CSV 1 h2h://1308:796/2000-11-05
58298 Roma 796 Reggiana 1307 2000-11-12 4 1 1 2 7 5 2000-03-19 L     2026-06-11 10:24:42.975869 2026-06-11 10:24:42.975869     International Results CSV 1 h2h://796:1307/2000-11-12
58328 Roma 796 Verona 800 2000-11-19 4 2 1 1 10 8 2000-05-14 D     2026-06-11 10:24:42.988026 2026-06-11 10:24:42.988026     International Results CSV 1 h2h://800:796/2000-11-19
58452 Roma 796 Udinese 798 2000-12-10 10 3 5 2 14 15 2000-04-02 D     2026-06-11 10:24:43.013664 2026-06-11 10:24:43.013665     International Results CSV 1 h2h://796:798/2000-12-10
58610 Roma 796 Aris 911 2001-01-14 8 6 0 2 17 7 2000-04-30 D     2026-06-11 10:24:43.048453 2026-06-11 10:24:43.048454     International Results CSV 1 h2h://796:911/2001-01-14
58819 Roma 796 Vicenza 1305 2001-02-25 19 8 3 8 33 21 2000-10-22 L     2026-06-11 10:24:43.106198 2026-06-11 10:24:43.106198     International Results CSV 1 h2h://1305:796/2001-02-25
58856 Roma 796 Inter 1304 2001-03-04 11 1 8 2 10 24 2000-11-01 L     2026-06-11 10:24:43.119179 2026-06-11 10:24:43.119179     International Results CSV 1 h2h://796:1304/2001-03-04
58878 Roma 796 Brescia 1308 2001-03-11 3 2 0 1 10 3 2000-11-05 W     2026-06-11 10:24:43.127040 2026-06-11 10:24:43.127040     International Results CSV 1 h2h://796:1308/2001-03-11
58914 Roma 796 Reggiana 1307 2001-03-18 5 2 1 2 9 6 2000-11-12 L     2026-06-11 10:24:43.135174 2026-06-11 10:24:43.135174     International Results CSV 1 h2h://1307:796/2001-03-18
58938 Roma 796 Verona 800 2001-04-01 5 3 1 1 14 9 2000-11-19 W     2026-06-11 10:24:43.153946 2026-06-11 10:24:43.153947     International Results CSV 1 h2h://796:800/2001-04-01
59051 Roma 796 Udinese 798 2001-04-22 11 4 5 2 16 16 2000-12-10 L     2026-06-11 10:24:43.186020 2026-06-11 10:24:43.186020     International Results CSV 1 h2h://798:796/2001-04-22
59188 Roma 796 Aris 911 2001-05-20 9 6 0 3 18 8 2001-01-14 D     2026-06-11 10:24:43.230815 2026-06-11 10:24:43.230815     International Results CSV 1 h2h://911:796/2001-05-20
59338 Roma 796 Verona 800 2001-08-26 6 4 1 1 17 10 2001-04-01 L     2026-06-11 10:24:43.716583 2026-06-11 10:24:43.716583     International Results CSV 1 h2h://800:796/2001-08-26
59363 Roma 796 Udinese 798 2001-09-08 12 5 5 2 19 17 2001-04-22 W     2026-06-11 10:24:43.732818 2026-06-11 10:24:43.732819     International Results CSV 1 h2h://796:798/2001-09-08
59422 Roma 796 Vicenza 1305 2001-09-16 20 9 3 8 35 21 2001-02-25 L     2026-06-11 10:24:43.744935 2026-06-11 10:24:43.744935     International Results CSV 1 h2h://1305:796/2001-09-16
59706 Roma 796 Inter 1304 2001-11-17 12 2 8 2 13 26 2001-03-04 W     2026-06-11 10:24:43.817598 2026-06-11 10:24:43.817598     International Results CSV 1 h2h://796:1304/2001-11-17
59793 Roma 796 Venezia 799 2001-12-02 4 3 1 0 11 4 2000-02-06 W     2026-06-11 10:24:43.834481 2026-06-11 10:24:43.834482     International Results CSV 1 h2h://796:799/2001-12-02
59888 Roma 796 Brescia 1308 2001-12-19 4 3 0 1 13 4 2001-03-11 W     2026-06-11 10:24:43.856007 2026-06-11 10:24:43.856007     International Results CSV 1 h2h://796:1308/2001-12-19
59969 Roma 796 Torino 797 2002-01-06 4 2 0 2 5 3 2000-03-05 W     2026-06-11 10:24:43.875586 2026-06-11 10:24:43.875586     International Results CSV 1 h2h://796:797/2002-01-06
60003 Roma 796 Verona 800 2002-01-13 7 4 1 2 18 11 2001-08-26 D     2026-06-11 10:24:43.884944 2026-06-11 10:24:43.884945     International Results CSV 1 h2h://796:800/2002-01-13

Next page

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 974.65ms