home / football

h2h_record

1,007 rows where team_a_id = 341

✎ 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
50297 Juventus 341 Cremonese 801 1995-08-27 0 0 0 0 0 0         2026-06-11 10:24:41.204482 2026-06-11 10:24:41.204482     International Results CSV 1 h2h://341:801/1995-08-27
50379 Juventus 341 Vicenza 1305 1995-09-10 0 0 0 0 0 0         2026-06-11 10:24:41.205164 2026-06-11 10:24:41.205165     International Results CSV 1 h2h://1305:341/1995-09-10
50419 Juventus 341 Vicenza 1305 1995-09-17 1 1 0 0 4 0 1995-09-10 W     2026-06-11 10:24:41.205424 2026-06-11 10:24:41.205424     International Results CSV 1 h2h://341:1305/1995-09-17
50442 Juventus 341 Cagliari 784 1995-09-24 0 0 0 0 0 0         2026-06-11 10:24:41.205606 2026-06-11 10:24:41.205606     International Results CSV 1 h2h://784:341/1995-09-24
50483 Juventus 341 Napoli 794 1995-10-01 0 0 0 0 0 0         2026-06-11 10:24:41.205878 2026-06-11 10:24:41.205878     International Results CSV 1 h2h://341:794/1995-10-01
50543 Juventus 341 Milan 792 1995-10-15 0 0 0 0 0 0         2026-06-11 10:24:41.206451 2026-06-11 10:24:41.206451     International Results CSV 1 h2h://792:341/1995-10-15
50597 Juventus 341 Padova 1306 1995-10-22 0 0 0 0 0 0         2026-06-11 10:24:41.206842 2026-06-11 10:24:41.206842     International Results CSV 1 h2h://341:1306/1995-10-22
50625 Juventus 341 Lazio 790 1995-10-29 0 0 0 0 0 0         2026-06-11 10:24:41.207067 2026-06-11 10:24:41.207067     International Results CSV 1 h2h://790:341/1995-10-29
50663 Juventus 341 Udinese 798 1995-11-05 0 0 0 0 0 0         2026-06-11 10:24:41.207355 2026-06-11 10:24:41.207355     International Results CSV 1 h2h://798:341/1995-11-05
50723 Juventus 341 Fiorentina 787 1995-11-19 0 0 0 0 0 0         2026-06-11 10:24:41.208031 2026-06-11 10:24:41.208032     International Results CSV 1 h2h://341:787/1995-11-19
50765 Juventus 341 Parma 795 1995-11-26 0 0 0 0 0 0         2026-06-11 10:24:41.208428 2026-06-11 10:24:41.208428     International Results CSV 1 h2h://795:341/1995-11-26
50809 Juventus 341 Torino 797 1995-12-03 0 0 0 0 0 0         2026-06-11 10:24:41.208902 2026-06-11 10:24:41.208902     International Results CSV 1 h2h://341:797/1995-12-03
50850 Juventus 341 Sampdoria 803 1995-12-10 0 0 0 0 0 0         2026-06-11 10:24:41.209358 2026-06-11 10:24:41.209358     International Results CSV 1 h2h://803:341/1995-12-10
50888 Juventus 341 Inter 1304 1995-12-17 0 0 0 0 0 0         2026-06-11 10:24:41.209697 2026-06-11 10:24:41.209698     International Results CSV 1 h2h://341:1304/1995-12-17
50908 Juventus 341 Roma 796 1995-12-23 0 0 0 0 0 0         2026-06-11 10:24:41.209878 2026-06-11 10:24:41.209878     International Results CSV 1 h2h://341:796/1995-12-23
50963 Juventus 341 Atalanta 782 1996-01-07 0 0 0 0 0 0         2026-06-11 10:24:41.210347 2026-06-11 10:24:41.210347     International Results CSV 1 h2h://782:341/1996-01-07
50993 Juventus 341 Aris 911 1996-01-14 0 0 0 0 0 0         2026-06-11 10:24:41.210635 2026-06-11 10:24:41.210635     International Results CSV 1 h2h://341:911/1996-01-14
51022 Juventus 341 Cremonese 801 1996-01-21 1 1 0 0 4 1 1995-08-27 L     2026-06-11 10:24:41.210926 2026-06-11 10:24:41.210926     International Results CSV 1 h2h://801:341/1996-01-21
51068 Juventus 341 Vicenza 1305 1996-01-28 2 2 0 0 5 0 1995-09-17 W     2026-06-11 10:24:41.211346 2026-06-11 10:24:41.211346     International Results CSV 1 h2h://341:1305/1996-01-28
51103 Juventus 341 Vicenza 1305 1996-02-04 3 3 0 0 7 0 1996-01-28 L     2026-06-11 10:24:41.211678 2026-06-11 10:24:41.211678     International Results CSV 1 h2h://1305:341/1996-02-04
51121 Juventus 341 Cagliari 784 1996-02-11 1 0 0 1 0 0 1995-09-24 D     2026-06-11 10:24:41.211879 2026-06-11 10:24:41.211879     International Results CSV 1 h2h://341:784/1996-02-11
51153 Juventus 341 Napoli 794 1996-02-18 1 0 0 1 1 1 1995-10-01 D     2026-06-11 10:24:41.212167 2026-06-11 10:24:41.212167     International Results CSV 1 h2h://794:341/1996-02-18
51190 Juventus 341 Milan 792 1996-02-25 1 0 1 0 1 2 1995-10-15 L     2026-06-11 10:24:41.212508 2026-06-11 10:24:41.212508     International Results CSV 1 h2h://341:792/1996-02-25
51223 Juventus 341 Padova 1306 1996-03-02 1 1 0 0 3 1 1995-10-22 L     2026-06-11 10:24:41.212781 2026-06-11 10:24:41.212781     International Results CSV 1 h2h://1306:341/1996-03-02
51266 Juventus 341 Lazio 790 1996-03-10 1 0 1 0 0 4 1995-10-29 L     2026-06-11 10:24:41.213153 2026-06-11 10:24:41.213153     International Results CSV 1 h2h://341:790/1996-03-10
51340 Juventus 341 Fiorentina 787 1996-03-24 1 1 0 0 1 0 1995-11-19 L     2026-06-11 10:24:41.213793 2026-06-11 10:24:41.213793     International Results CSV 1 h2h://787:341/1996-03-24
51388 Juventus 341 Parma 795 1996-03-31 1 0 0 1 1 1 1995-11-26 D     2026-06-11 10:24:41.214303 2026-06-11 10:24:41.214303     International Results CSV 1 h2h://341:795/1996-03-31
51418 Juventus 341 Torino 797 1996-04-06 1 1 0 0 5 0 1995-12-03 L     2026-06-11 10:24:41.214522 2026-06-11 10:24:41.214522     International Results CSV 1 h2h://797:341/1996-04-06
51463 Juventus 341 Udinese 798 1996-04-10 1 0 1 0 0 1 1995-11-05 L     2026-06-11 10:24:41.214882 2026-06-11 10:24:41.214882     International Results CSV 1 h2h://341:798/1996-04-10
51497 Juventus 341 Sampdoria 803 1996-04-14 1 0 1 0 0 2 1995-12-10 L     2026-06-11 10:24:41.215133 2026-06-11 10:24:41.215133     International Results CSV 1 h2h://341:803/1996-04-14
51547 Juventus 341 Inter 1304 1996-04-21 1 1 0 0 1 0 1995-12-17 L     2026-06-11 10:24:41.215544 2026-06-11 10:24:41.215544     International Results CSV 1 h2h://1304:341/1996-04-21
51574 Juventus 341 Roma 796 1996-04-28 1 0 1 0 0 2 1995-12-23 W     2026-06-11 10:24:41.215938 2026-06-11 10:24:41.215938     International Results CSV 1 h2h://796:341/1996-04-28
51622 Juventus 341 Atalanta 782 1996-05-05 1 1 0 0 1 0 1996-01-07 W     2026-06-11 10:24:41.216359 2026-06-11 10:24:41.216359     International Results CSV 1 h2h://341:782/1996-05-05
51654 Juventus 341 Aris 911 1996-05-12 1 0 0 1 1 1 1996-01-14 D     2026-06-11 10:24:41.216686 2026-06-11 10:24:41.216687     International Results CSV 1 h2h://911:341/1996-05-12
51822 Juventus 341 Reggiana 1307 1996-09-08 0 0 0 0 0 0         2026-06-11 10:24:41.219800 2026-06-11 10:24:41.219800     International Results CSV 1 h2h://1307:341/1996-09-08
51847 Juventus 341 Cagliari 784 1996-09-15 2 1 0 1 4 1 1996-02-11 W     2026-06-11 10:24:41.220093 2026-06-11 10:24:41.220093     International Results CSV 1 h2h://341:784/1996-09-15
51926 Juventus 341 Fiorentina 787 1996-09-29 2 2 0 0 2 0 1996-03-24 W     2026-06-11 10:24:41.220860 2026-06-11 10:24:41.220860     International Results CSV 1 h2h://341:787/1996-09-29
52002 Juventus 341 Vicenza 1305 1996-10-13 4 3 1 0 8 2 1996-02-04 W     2026-06-11 10:24:41.221713 2026-06-11 10:24:41.221713     International Results CSV 1 h2h://1305:341/1996-10-13
52037 Juventus 341 Inter 1304 1996-10-20 2 2 0 0 3 1 1996-04-21 W     2026-06-11 10:24:41.222021 2026-06-11 10:24:41.222021     International Results CSV 1 h2h://341:1304/1996-10-20
52077 Juventus 341 Roma 796 1996-10-27 2 0 1 1 2 4 1996-04-28 D     2026-06-11 10:24:41.222410 2026-06-11 10:24:41.222410     International Results CSV 1 h2h://796:341/1996-10-27
52113 Juventus 341 Napoli 794 1996-11-03 2 1 0 1 2 1 1996-02-18 W     2026-06-11 10:24:41.222730 2026-06-11 10:24:41.222730     International Results CSV 1 h2h://341:794/1996-11-03
52165 Juventus 341 Milan 792 1996-11-17 2 0 1 1 2 3 1996-02-25 D     2026-06-11 10:24:41.223430 2026-06-11 10:24:41.223430     International Results CSV 1 h2h://341:792/1996-11-17
52242 Juventus 341 Bologna 783 1996-12-01 0 0 0 0 0 0         2026-06-11 10:24:41.224180 2026-06-11 10:24:41.224180     International Results CSV 1 h2h://341:783/1996-12-01
52285 Juventus 341 Sampdoria 803 1996-12-08 2 0 2 0 0 5 1996-04-14 W     2026-06-11 10:24:41.224566 2026-06-11 10:24:41.224566     International Results CSV 1 h2h://803:341/1996-12-08
52300 Juventus 341 Udinese 798 1996-12-11 2 1 1 0 2 2 1996-04-10 L     2026-06-11 10:24:41.224720 2026-06-11 10:24:41.224720     International Results CSV 1 h2h://798:341/1996-12-11
52305 Juventus 341 Verona 800 1996-12-15 0 0 0 0 0 0         2026-06-11 10:24:41.224933 2026-06-11 10:24:41.224933     International Results CSV 1 h2h://341:800/1996-12-15
52342 Juventus 341 Vicenza 1305 1996-12-22 5 3 2 0 9 4 1996-10-13 W     2026-06-11 10:24:41.225294 2026-06-11 10:24:41.225294     International Results CSV 1 h2h://1305:341/1996-12-22
52379 Juventus 341 Parma 795 1997-01-05 2 1 0 1 2 1 1996-03-31 L     2026-06-11 10:24:41.225624 2026-06-11 10:24:41.225624     International Results CSV 1 h2h://795:341/1997-01-05
52405 Juventus 341 Atalanta 782 1997-01-12 2 2 0 0 2 0 1996-05-05 W     2026-06-11 10:24:41.225955 2026-06-11 10:24:41.225955     International Results CSV 1 h2h://341:782/1997-01-12
52433 Juventus 341 Lazio 790 1997-01-19 2 1 1 0 4 6 1996-03-10 L     2026-06-11 10:24:41.226209 2026-06-11 10:24:41.226209     International Results CSV 1 h2h://790:341/1997-01-19
52466 Juventus 341 Reggiana 1307 1997-01-26 1 0 0 1 1 1 1996-09-08 D     2026-06-11 10:24:41.226566 2026-06-11 10:24:41.226567     International Results CSV 1 h2h://341:1307/1997-01-26
52492 Juventus 341 Cagliari 784 1997-02-02 3 2 0 1 6 2 1996-09-15 L     2026-06-11 10:24:41.226790 2026-06-11 10:24:41.226790     International Results CSV 1 h2h://784:341/1997-02-02
52587 Juventus 341 Fiorentina 787 1997-02-23 3 3 0 0 3 0 1996-09-29 L     2026-06-11 10:24:41.227862 2026-06-11 10:24:41.227863     International Results CSV 1 h2h://787:341/1997-02-23
52639 Juventus 341 Vicenza 1305 1997-03-02 6 3 2 1 10 5 1996-12-22 D     2026-06-11 10:24:41.228368 2026-06-11 10:24:41.228368     International Results CSV 1 h2h://341:1305/1997-03-02
52681 Juventus 341 Inter 1304 1997-03-09 3 3 0 0 5 1 1996-10-20 L     2026-06-11 10:24:41.228730 2026-06-11 10:24:41.228730     International Results CSV 1 h2h://1304:341/1997-03-09
52722 Juventus 341 Roma 796 1997-03-16 3 0 1 2 3 5 1996-10-27 D     2026-06-11 10:24:41.229140 2026-06-11 10:24:41.229140     International Results CSV 1 h2h://341:796/1997-03-16
52765 Juventus 341 Napoli 794 1997-03-23 3 1 0 2 3 2 1996-11-03 D     2026-06-11 10:24:41.229547 2026-06-11 10:24:41.229547     International Results CSV 1 h2h://794:341/1997-03-23
52823 Juventus 341 Milan 792 1997-04-06 3 0 1 2 2 3 1996-11-17 D     2026-06-11 10:24:41.230409 2026-06-11 10:24:41.230409     International Results CSV 1 h2h://792:341/1997-04-06
52867 Juventus 341 Udinese 798 1997-04-13 3 2 1 0 6 3 1996-12-11 W     2026-06-11 10:24:41.230857 2026-06-11 10:24:41.230857     International Results CSV 1 h2h://341:798/1997-04-13
52919 Juventus 341 Bologna 783 1997-04-20 1 1 0 0 1 0 1996-12-01 L     2026-06-11 10:24:41.231363 2026-06-11 10:24:41.231363     International Results CSV 1 h2h://783:341/1997-04-20
52977 Juventus 341 Sampdoria 803 1997-05-04 3 1 2 0 1 5 1996-12-08 W     2026-06-11 10:24:41.232183 2026-06-11 10:24:41.232184     International Results CSV 1 h2h://341:803/1997-05-04
53016 Juventus 341 Verona 800 1997-05-11 1 1 0 0 3 2 1996-12-15 L     2026-06-11 10:24:41.232547 2026-06-11 10:24:41.232547     International Results CSV 1 h2h://800:341/1997-05-11
53045 Juventus 341 Vicenza 1305 1997-05-15 7 4 2 1 12 5 1997-03-02 W     2026-06-11 10:24:41.232790 2026-06-11 10:24:41.232790     International Results CSV 1 h2h://341:1305/1997-05-15
53058 Juventus 341 Parma 795 1997-05-18 3 1 1 1 2 2 1997-01-05 L     2026-06-11 10:24:41.232921 2026-06-11 10:24:41.232921     International Results CSV 1 h2h://341:795/1997-05-18
53076 Juventus 341 Atalanta 782 1997-05-23 3 2 0 1 2 0 1997-01-12 D     2026-06-11 10:24:41.233099 2026-06-11 10:24:41.233099     International Results CSV 1 h2h://782:341/1997-05-23
53117 Juventus 341 Lazio 790 1997-06-01 3 2 1 0 6 6 1997-01-19 W     2026-06-11 10:24:41.233554 2026-06-11 10:24:41.233554     International Results CSV 1 h2h://341:790/1997-06-01
53250 Juventus 341 Lecce 791 1997-08-31 0 0 0 0 0 0         2026-06-11 10:24:41.236187 2026-06-11 10:24:41.236187     International Results CSV 1 h2h://341:791/1997-08-31
53303 Juventus 341 Roma 796 1997-09-14 4 1 1 2 6 5 1997-03-16 L     2026-06-11 10:24:41.236949 2026-06-11 10:24:41.236949     International Results CSV 1 h2h://796:341/1997-09-14
53338 Juventus 341 Brescia 1308 1997-09-21 0 0 0 0 0 0         2026-06-11 10:24:41.237260 2026-06-11 10:24:41.237260     International Results CSV 1 h2h://341:1308/1997-09-21
53359 Juventus 341 Sampdoria 803 1997-09-27 4 1 2 1 1 5 1997-05-04 D     2026-06-11 10:24:41.237496 2026-06-11 10:24:41.237496     International Results CSV 1 h2h://803:341/1997-09-27
53410 Juventus 341 Fiorentina 787 1997-10-05 4 3 0 1 4 1 1997-02-23 D     2026-06-11 10:24:41.238006 2026-06-11 10:24:41.238007     International Results CSV 1 h2h://341:787/1997-10-05
53472 Juventus 341 Aris 911 1997-10-19 2 0 0 2 3 3 1996-05-12 D     2026-06-11 10:24:41.238867 2026-06-11 10:24:41.238867     International Results CSV 1 h2h://911:341/1997-10-19
53523 Juventus 341 Udinese 798 1997-11-01 4 2 2 0 6 6 1997-04-13 L     2026-06-11 10:24:41.239369 2026-06-11 10:24:41.239369     International Results CSV 1 h2h://341:798/1997-11-01
53574 Juventus 341 Napoli 794 1997-11-09 4 1 0 3 3 2 1997-03-23 D     2026-06-11 10:24:41.239833 2026-06-11 10:24:41.239833     International Results CSV 1 h2h://794:341/1997-11-09
53642 Juventus 341 Parma 795 1997-11-23 4 1 1 2 3 3 1997-05-18 D     2026-06-11 10:24:41.240491 2026-06-11 10:24:41.240491     International Results CSV 1 h2h://341:795/1997-11-23
53680 Juventus 341 Milan 792 1997-11-30 4 1 1 2 8 4 1997-04-06 L     2026-06-11 10:24:41.240843 2026-06-11 10:24:41.240843     International Results CSV 1 h2h://792:341/1997-11-30
53701 Juventus 341 Lazio 790 1997-12-06 4 2 1 1 8 8 1997-06-01 D     2026-06-11 10:24:41.241073 2026-06-11 10:24:41.241073     International Results CSV 1 h2h://341:790/1997-12-06
53768 Juventus 341 Vicenza 1305 1997-12-14 8 5 2 1 16 6 1997-05-15 L     2026-06-11 10:24:41.241653 2026-06-11 10:24:41.241653     International Results CSV 1 h2h://1305:341/1997-12-14
53802 Juventus 341 Empoli 786 1997-12-21 0 0 0 0 0 0         2026-06-11 10:24:41.242007 2026-06-11 10:24:41.242008     International Results CSV 1 h2h://341:786/1997-12-21
53856 Juventus 341 Inter 1304 1998-01-04 4 3 0 1 5 1 1997-03-09 D     2026-06-11 10:24:41.242522 2026-06-11 10:24:41.242522     International Results CSV 1 h2h://1304:341/1998-01-04
53884 Juventus 341 Vicenza 1305 1998-01-11 9 5 2 2 17 7 1997-12-14 D     2026-06-11 10:24:41.242795 2026-06-11 10:24:41.242796     International Results CSV 1 h2h://341:1305/1998-01-11
53901 Juventus 341 Bologna 783 1998-01-18 2 2 0 0 2 0 1997-04-20 L     2026-06-11 10:24:41.242955 2026-06-11 10:24:41.242955     International Results CSV 1 h2h://783:341/1998-01-18
53921 Juventus 341 Atalanta 782 1998-01-25 4 2 0 2 3 1 1997-05-23 D     2026-06-11 10:24:41.243160 2026-06-11 10:24:41.243160     International Results CSV 1 h2h://341:782/1998-01-25
53960 Juventus 341 Lecce 791 1998-02-01 1 1 0 0 2 0 1997-08-31 L     2026-06-11 10:24:41.243585 2026-06-11 10:24:41.243585     International Results CSV 1 h2h://791:341/1998-02-01
53996 Juventus 341 Roma 796 1998-02-08 5 1 1 3 6 5 1997-09-14 D     2026-06-11 10:24:41.243998 2026-06-11 10:24:41.243998     International Results CSV 1 h2h://341:796/1998-02-08
54017 Juventus 341 Brescia 1308 1998-02-11 1 1 0 0 4 0 1997-09-21 L     2026-06-11 10:24:41.244247 2026-06-11 10:24:41.244247     International Results CSV 1 h2h://1308:341/1998-02-11
54040 Juventus 341 Sampdoria 803 1998-02-15 5 1 2 2 2 6 1997-09-27 D     2026-06-11 10:24:41.244493 2026-06-11 10:24:41.244493     International Results CSV 1 h2h://341:803/1998-02-15
54067 Juventus 341 Fiorentina 787 1998-02-22 5 4 0 1 6 2 1997-10-05 L     2026-06-11 10:24:41.244809 2026-06-11 10:24:41.244809     International Results CSV 1 h2h://787:341/1998-02-22
54091 Juventus 341 Aris 911 1998-02-28 3 1 0 2 8 3 1997-10-19 W     2026-06-11 10:24:41.245045 2026-06-11 10:24:41.245046     International Results CSV 1 h2h://341:911/1998-02-28
54141 Juventus 341 Udinese 798 1998-03-08 5 3 2 0 10 7 1997-11-01 L     2026-06-11 10:24:41.245556 2026-06-11 10:24:41.245556     International Results CSV 1 h2h://798:341/1998-03-08
54166 Juventus 341 Napoli 794 1998-03-14 5 2 0 3 5 3 1997-11-09 W     2026-06-11 10:24:41.245790 2026-06-11 10:24:41.245790     International Results CSV 1 h2h://341:794/1998-03-14
54212 Juventus 341 Parma 795 1998-03-22 5 1 1 3 5 5 1997-11-23 D     2026-06-11 10:24:41.246212 2026-06-11 10:24:41.246212     International Results CSV 1 h2h://795:341/1998-03-22
54232 Juventus 341 Milan 792 1998-03-28 5 1 1 3 9 5 1997-11-30 D     2026-06-11 10:24:41.246494 2026-06-11 10:24:41.246495     International Results CSV 1 h2h://341:792/1998-03-28
54286 Juventus 341 Lazio 790 1998-04-05 5 3 1 1 10 9 1997-12-06 L     2026-06-11 10:24:41.246978 2026-06-11 10:24:41.246978     International Results CSV 1 h2h://790:341/1998-04-05
54326 Juventus 341 Vicenza 1305 1998-04-11 10 6 2 2 19 7 1998-01-11 W     2026-06-11 10:24:41.847214 2026-06-11 10:24:41.847214     International Results CSV 1 h2h://341:1305/1998-04-11
54369 Juventus 341 Empoli 786 1998-04-19 1 1 0 0 5 2 1997-12-21 L     2026-06-11 10:24:41.856748 2026-06-11 10:24:41.856748     International Results CSV 1 h2h://786:341/1998-04-19
54418 Juventus 341 Inter 1304 1998-04-26 5 3 1 1 5 2 1998-01-04 L     2026-06-11 10:24:41.869579 2026-06-11 10:24:41.869579     International Results CSV 1 h2h://341:1304/1998-04-26
54466 Juventus 341 Vicenza 1305 1998-05-03 11 7 2 2 21 7 1998-04-11 L     2026-06-11 10:24:41.878887 2026-06-11 10:24:41.878888     International Results CSV 1 h2h://1305:341/1998-05-03
54487 Juventus 341 Bologna 783 1998-05-10 3 3 0 0 5 1 1998-01-18 W     2026-06-11 10:24:41.883922 2026-06-11 10:24:41.883923     International Results CSV 1 h2h://341:783/1998-05-10
54518 Juventus 341 Atalanta 782 1998-05-16 5 3 0 2 6 2 1998-01-25 L     2026-06-11 10:24:41.890681 2026-06-11 10:24:41.890682     International Results CSV 1 h2h://782:341/1998-05-16

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