home / football

h2h_record

205 rows where team_b_id = 209

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: total_matches, wins_a, wins_b, draws, goals_a, goals_b, 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
11847 Belarus 73 Armenia 209 1979-07-21 0 0 0 0 0 0         2026-06-07 07:03:20.511380 2026-06-07 07:03:20.511380 1   International Results CSV 1 h2h://73:209/1979-07-21
18526 Moldova 146 Armenia 209 1992-10-14 0 0 0 0 0 0         2026-06-07 07:03:22.130900 2026-06-07 07:03:22.130901 1   International Results CSV 1 h2h://209:146/1992-10-14
19687 United States 5 Armenia 209 1994-05-15 0 0 0 0 0 0         2026-06-07 07:03:22.362071 2026-06-07 07:03:22.362072 1   International Results CSV 1 h2h://5:209/1994-05-15
19814 Malta 151 Armenia 209 1994-07-16 0 0 0 0 0 0         2026-06-07 07:03:22.387326 2026-06-07 07:03:22.387326 1   International Results CSV 1 h2h://209:151/1994-07-16
19863 Belgium 12 Armenia 209 1994-09-07 0 0 0 0 0 0         2026-06-07 07:03:22.397007 2026-06-07 07:03:22.397007 1   International Results CSV 1 h2h://12:209/1994-09-07
19924 Cyprus 118 Armenia 209 1994-10-08 0 0 0 0 0 0         2026-06-07 07:03:22.409047 2026-06-07 07:03:22.409047 1   International Results CSV 1 h2h://209:118/1994-10-08
20022 Cyprus 118 Armenia 209 1994-11-16 1 0 0 1 0 0 1994-10-08 D     2026-06-07 07:03:22.750216 2026-06-07 07:03:22.750216 1   International Results CSV 1 h2h://118:209/1994-11-16
20261 Spain 41 Armenia 209 1995-04-26 0 0 0 0 0 0         2026-06-07 07:03:22.795777 2026-06-07 07:03:22.795777 1   International Results CSV 1 h2h://209:41/1995-04-26
20365 Spain 41 Armenia 209 1995-06-07 1 1 0 0 2 0 1995-04-26 W     2026-06-07 07:03:22.815565 2026-06-07 07:03:22.815565 1   International Results CSV 1 h2h://41:209/1995-06-07
20501 Denmark 25 Armenia 209 1995-08-16 0 0 0 0 0 0         2026-06-07 07:03:22.841598 2026-06-07 07:03:22.841598 1   International Results CSV 1 h2h://209:25/1995-08-16
20569 Belgium 12 Armenia 209 1995-10-07 1 1 0 0 2 0 1994-09-07 L     2026-06-07 07:03:22.854477 2026-06-07 07:03:22.854477 1   International Results CSV 1 h2h://209:12/1995-10-07
20634 Denmark 25 Armenia 209 1995-11-15 1 1 0 0 2 0 1995-08-16 W     2026-06-07 07:03:22.866959 2026-06-07 07:03:22.866959 1   International Results CSV 1 h2h://25:209/1995-11-15
20794 Morocco 155 Armenia 209 1996-01-17 0 0 0 0 0 0         2026-06-07 07:03:22.897645 2026-06-07 07:03:22.897646 1   International Results CSV 1 h2h://209:155/1996-01-17
21088 France 13 Armenia 209 1996-06-05 0 0 0 0 0 0         2026-06-07 07:03:22.953730 2026-06-07 07:03:22.953731 1   International Results CSV 1 h2h://13:209/1996-06-05
21158 Peru 71 Armenia 209 1996-06-20 0 0 0 0 0 0         2026-06-07 07:03:22.967022 2026-06-07 07:03:22.967022 1   International Results CSV 1 h2h://71:209/1996-06-20
21172 Paraguay 37 Armenia 209 1996-06-25 0 0 0 0 0 0         2026-06-07 07:03:22.969653 2026-06-07 07:03:22.969653 1   International Results CSV 1 h2h://37:209/1996-06-25
21182 Ecuador 89 Armenia 209 1996-06-30 0 0 0 0 0 0         2026-06-07 07:03:22.971545 2026-06-07 07:03:22.971545 1   International Results CSV 1 h2h://89:209/1996-06-30
21269 Portugal 50 Armenia 209 1996-08-31 0 0 0 0 0 0         2026-06-07 07:03:22.988305 2026-06-07 07:03:22.988306 1   International Results CSV 1 h2h://209:50/1996-08-31
21374 Northern Ireland 4 Armenia 209 1996-10-05 0 0 0 0 0 0         2026-06-07 07:03:23.008482 2026-06-07 07:03:23.008482 1   International Results CSV 1 h2h://4:209/1996-10-05
21398 Germany 22 Armenia 209 1996-10-09 0 0 0 0 0 0         2026-06-07 07:03:23.013055 2026-06-07 07:03:23.013055 1   International Results CSV 1 h2h://209:22/1996-10-09
21464 Albania 105 Armenia 209 1996-11-09 0 0 0 0 0 0         2026-06-07 07:03:23.025736 2026-06-07 07:03:23.025737 1   International Results CSV 1 h2h://105:209/1996-11-09
21603 Chile 27 Armenia 209 1997-01-04 0 0 0 0 0 0         2026-06-07 07:03:23.052533 2026-06-07 07:03:23.052533 1   International Results CSV 1 h2h://27:209/1997-01-04
21606 Paraguay 37 Armenia 209 1997-01-06 1 0 1 0 1 2 1996-06-25 L     2026-06-07 07:03:23.053106 2026-06-07 07:03:23.053106 1   International Results CSV 1 h2h://37:209/1997-01-06
21901 Northern Ireland 4 Armenia 209 1997-04-30 1 0 0 1 1 1 1996-10-05 D     2026-06-07 07:03:23.109855 2026-06-07 07:03:23.109855 1   International Results CSV 1 h2h://209:4/1997-04-30
21932 Ukraine 74 Armenia 209 1997-05-07 0 0 0 0 0 0         2026-06-07 07:03:23.115880 2026-06-07 07:03:23.115880 1   International Results CSV 1 h2h://74:209/1997-05-07
22234 Portugal 50 Armenia 209 1997-08-20 1 0 0 1 0 0 1996-08-31 D     2026-06-07 07:03:23.174090 2026-06-07 07:03:23.174090 1   International Results CSV 1 h2h://50:209/1997-08-20
22253 Albania 105 Armenia 209 1997-09-06 1 0 0 1 1 1 1996-11-09 D     2026-06-07 07:03:23.177840 2026-06-07 07:03:23.177840 1   International Results CSV 1 h2h://209:105/1997-09-06
22288 Germany 22 Armenia 209 1997-09-10 1 1 0 0 5 1 1996-10-09 W     2026-06-07 07:03:23.184592 2026-06-07 07:03:23.184593 1   International Results CSV 1 h2h://22:209/1997-09-10
22356 Ukraine 74 Armenia 209 1997-10-11 1 0 0 1 1 1 1997-05-07 D     2026-06-07 07:03:23.197906 2026-06-07 07:03:23.197907 1   International Results CSV 1 h2h://209:74/1997-10-11
22963 Lebanon 96 Armenia 209 1998-08-18 0 0 0 0 0 0         2026-06-07 07:03:23.313905 2026-06-07 07:03:23.313906 1   International Results CSV 1 h2h://209:96/1998-08-18
23103 Iceland 104 Armenia 209 1998-10-10 0 0 0 0 0 0         2026-06-07 07:03:23.340435 2026-06-07 07:03:23.340436 1   International Results CSV 1 h2h://209:104/1998-10-10
23146 Ukraine 74 Armenia 209 1998-10-14 2 1 0 1 3 1 1997-10-11 W     2026-06-07 07:03:23.348561 2026-06-07 07:03:23.348561 1   International Results CSV 1 h2h://74:209/1998-10-14
23201 Estonia 43 Armenia 209 1998-11-21 0 0 0 0 0 0         2026-06-07 07:03:23.359085 2026-06-07 07:03:23.359085 1   International Results CSV 1 h2h://209:43/1998-11-21
23362 Poland 49 Armenia 209 1999-03-03 0 0 0 0 0 0         2026-06-07 07:03:23.389579 2026-06-07 07:03:23.389579 1   International Results CSV 1 h2h://49:209/1999-03-03
23406 Russia 28 Armenia 209 1999-03-27 0 0 0 0 0 0         2026-06-07 07:03:23.397911 2026-06-07 07:03:23.397912 1   International Results CSV 1 h2h://209:28/1999-03-27
23430 France 13 Armenia 209 1999-03-31 1 1 0 0 2 0 1996-06-05 W     2026-06-07 07:03:23.402509 2026-06-07 07:03:23.402509 1   International Results CSV 1 h2h://13:209/1999-03-31
23555 Iceland 104 Armenia 209 1999-06-05 1 0 0 1 0 0 1998-10-10 D     2026-06-07 07:03:23.426217 2026-06-07 07:03:23.426217 1   International Results CSV 1 h2h://104:209/1999-06-05
23589 Ukraine 74 Armenia 209 1999-06-09 3 2 0 1 5 1 1998-10-14 L     2026-06-07 07:03:23.432616 2026-06-07 07:03:23.432616 1   International Results CSV 1 h2h://209:74/1999-06-09
23800 Estonia 43 Armenia 209 1999-08-18 1 0 1 0 1 2 1998-11-21 L     2026-06-07 07:03:23.473430 2026-06-07 07:03:23.473431 1   International Results CSV 1 h2h://43:209/1999-08-18
23840 Russia 28 Armenia 209 1999-09-04 1 1 0 0 3 0 1999-03-27 W     2026-06-07 07:03:23.481674 2026-06-07 07:03:23.481675 1   International Results CSV 1 h2h://28:209/1999-09-04
23850 France 13 Armenia 209 1999-09-08 2 2 0 0 4 0 1999-03-31 L     2026-06-07 07:03:23.483706 2026-06-07 07:03:23.483706 1   International Results CSV 1 h2h://209:13/1999-09-08
24051 Guatemala 48 Armenia 209 2000-01-09 0 0 0 0 0 0         2026-06-07 07:03:23.523915 2026-06-07 07:03:23.523915 1   International Results CSV 1 h2h://48:209/2000-01-09
24106 Moldova 146 Armenia 209 2000-02-02 1 0 0 1 0 0 1992-10-14 D     2026-06-07 07:03:23.534864 2026-06-07 07:03:23.534864 1   International Results CSV 1 h2h://209:146/2000-02-02
24116 Cyprus 118 Armenia 209 2000-02-04 2 1 0 1 2 0 1994-11-16 W     2026-06-07 07:03:23.536852 2026-06-07 07:03:23.536852 1   International Results CSV 1 h2h://118:209/2000-02-04
24839 Norway 24 Armenia 209 2000-09-02 0 0 0 0 0 0         2026-06-07 07:03:23.678743 2026-06-07 07:03:23.678743 1   International Results CSV 1 h2h://24:209/2000-09-02
24898 Ukraine 74 Armenia 209 2000-10-07 4 2 0 2 5 1 1999-06-09 D     2026-06-07 07:03:23.690434 2026-06-07 07:03:23.690434 1   International Results CSV 1 h2h://209:74/2000-10-07
24950 Belarus 73 Armenia 209 2000-10-11 1 1 0 0 3 0 1979-07-21 W     2026-06-07 07:03:23.700705 2026-06-07 07:03:23.700706 1   International Results CSV 1 h2h://73:209/2000-10-11
25305 Wales 3 Armenia 209 2001-03-24 0 0 0 0 0 0         2026-06-07 07:03:24.097200 2026-06-07 07:03:24.097200 1   International Results CSV 1 h2h://209:3/2001-03-24
25366 Poland 49 Armenia 209 2001-03-28 1 1 0 0 1 0 1999-03-03 W     2026-06-07 07:03:24.108723 2026-06-07 07:03:24.108723 1   International Results CSV 1 h2h://49:209/2001-03-28
25596 Belarus 73 Armenia 209 2001-06-02 2 2 0 0 5 1 2000-10-11 L     2026-06-07 07:03:24.152489 2026-06-07 07:03:24.152489 1   International Results CSV 1 h2h://209:73/2001-06-02
25646 Poland 49 Armenia 209 2001-06-06 2 2 0 0 5 0 2001-03-28 L     2026-06-07 07:03:24.162051 2026-06-07 07:03:24.162052 1   International Results CSV 1 h2h://209:49/2001-06-06
25905 Wales 3 Armenia 209 2001-09-01 1 0 0 1 2 2 2001-03-24 D     2026-06-07 07:03:24.211528 2026-06-07 07:03:24.211528 1   International Results CSV 1 h2h://3:209/2001-09-01
25937 Ukraine 74 Armenia 209 2001-09-05 5 3 0 2 8 3 2000-10-07 W     2026-06-07 07:03:24.217661 2026-06-07 07:03:24.217662 1   International Results CSV 1 h2h://74:209/2001-09-05
25966 Norway 24 Armenia 209 2001-10-06 1 0 0 1 0 0 2000-09-02 D     2026-06-07 07:03:24.223161 2026-06-07 07:03:24.223161 1   International Results CSV 1 h2h://209:24/2001-10-06
26609 Ukraine 74 Armenia 209 2002-09-07 6 4 0 2 11 3 2001-09-05 L     2026-06-07 07:03:24.346609 2026-06-07 07:03:24.346609 1   International Results CSV 1 h2h://209:74/2002-09-07
26720 Greece 39 Armenia 209 2002-10-16 0 0 0 0 0 0         2026-06-07 07:03:24.367936 2026-06-07 07:03:24.367936 1   International Results CSV 1 h2h://39:209/2002-10-16
26938 Israel 82 Armenia 209 2003-02-12 0 0 0 0 0 0         2026-06-07 07:03:24.410296 2026-06-07 07:03:24.410296 1   International Results CSV 1 h2h://82:209/2003-02-12
27051 Northern Ireland 4 Armenia 209 2003-03-29 2 0 0 2 1 1 1997-04-30 D     2026-06-07 07:03:24.432133 2026-06-07 07:03:24.432133 1   International Results CSV 1 h2h://209:4/2003-03-29
27122 Spain 41 Armenia 209 2003-04-02 2 2 0 0 3 0 1995-06-07 W     2026-06-07 07:03:24.445743 2026-06-07 07:03:24.445743 1   International Results CSV 1 h2h://41:209/2003-04-02
27230 Ukraine 74 Armenia 209 2003-06-07 7 4 0 3 13 5 2002-09-07 D     2026-06-07 07:03:24.466597 2026-06-07 07:03:24.466598 1   International Results CSV 1 h2h://74:209/2003-06-07
27489 Greece 39 Armenia 209 2003-09-06 1 1 0 0 2 0 2002-10-16 L     2026-06-07 07:03:24.516130 2026-06-07 07:03:24.516130 1   International Results CSV 1 h2h://209:39/2003-09-06
27538 Northern Ireland 4 Armenia 209 2003-09-10 3 0 1 2 1 2 2003-03-29 L     2026-06-07 07:03:24.525465 2026-06-07 07:03:24.525466 1   International Results CSV 1 h2h://4:209/2003-09-10
27596 Spain 41 Armenia 209 2003-10-11 3 3 0 0 6 0 2003-04-02 L     2026-06-07 07:03:24.536540 2026-06-07 07:03:24.536540 1   International Results CSV 1 h2h://209:41/2003-10-11
27936 Hungary 10 Armenia 209 2004-02-18 0 0 0 0 0 0         2026-06-07 07:03:24.601585 2026-06-07 07:03:24.601585 1   International Results CSV 1 h2h://10:209/2004-02-18
28565 Finland 29 Armenia 209 2004-09-08 0 0 0 0 0 0         2026-06-07 07:03:24.721869 2026-06-07 07:03:24.721869 1   International Results CSV 1 h2h://209:29/2004-09-08
28640 Finland 29 Armenia 209 2004-10-09 1 1 0 0 2 0 2004-09-08 W     2026-06-07 07:03:24.736265 2026-06-07 07:03:24.736265 1   International Results CSV 1 h2h://29:209/2004-10-09
28755 Romania 38 Armenia 209 2004-11-17 0 0 0 0 0 0         2026-06-07 07:03:24.758188 2026-06-07 07:03:24.758188 1   International Results CSV 1 h2h://209:38/2004-11-17
29038 Kuwait 174 Armenia 209 2005-03-18 0 0 0 0 0 0         2026-06-07 07:03:24.812314 2026-06-07 07:03:24.812314 1   International Results CSV 1 h2h://174:209/2005-03-18
29116 Netherlands 18 Armenia 209 2005-03-30 0 0 0 0 0 0         2026-06-07 07:03:24.827205 2026-06-07 07:03:24.827206 1   International Results CSV 1 h2h://18:209/2005-03-30
29244 Romania 38 Armenia 209 2005-06-08 1 0 0 1 1 1 2004-11-17 D     2026-06-07 07:03:24.851868 2026-06-07 07:03:24.851868 1   International Results CSV 1 h2h://38:209/2005-06-08
29386 Jordan 175 Armenia 209 2005-08-17 0 0 0 0 0 0         2026-06-07 07:03:24.878922 2026-06-07 07:03:24.878923 1   International Results CSV 1 h2h://175:209/2005-08-17
29418 Netherlands 18 Armenia 209 2005-09-03 1 1 0 0 2 0 2005-03-30 L     2026-06-07 07:03:24.885017 2026-06-07 07:03:24.885018 1   International Results CSV 1 h2h://209:18/2005-09-03
29822 Romania 38 Armenia 209 2006-02-28 2 1 0 1 4 1 2005-06-08 W     2026-06-07 07:03:24.962314 2026-06-07 07:03:24.962314 1   International Results CSV 1 h2h://38:209/2006-02-28
29827 Cyprus 118 Armenia 209 2006-03-01 3 2 0 1 5 2 2000-02-04 W     2026-06-07 07:03:24.963254 2026-06-07 07:03:24.963254 1   International Results CSV 1 h2h://118:209/2006-03-01
30236 Belgium 12 Armenia 209 2006-09-06 2 2 0 0 4 0 1995-10-07 L     2026-06-07 07:03:25.374550 2026-06-07 07:03:25.374551 1   International Results CSV 1 h2h://209:12/2006-09-06
30313 Finland 29 Armenia 209 2006-10-07 2 2 0 0 5 1 2004-10-09 L     2026-06-07 07:03:25.389249 2026-06-07 07:03:25.389249 1   International Results CSV 1 h2h://209:29/2006-10-07
30396 Serbia 122 Armenia 209 2006-10-11 0 0 0 0 0 0         2026-06-07 07:03:25.405019 2026-06-07 07:03:25.405019 1   International Results CSV 1 h2h://122:209/2006-10-11
30439 Finland 29 Armenia 209 2006-11-15 3 2 0 1 5 1 2006-10-07 D     2026-06-07 07:03:25.413342 2026-06-07 07:03:25.413343 1   International Results CSV 1 h2h://29:209/2006-11-15
30576 Panama 87 Armenia 209 2007-01-14 0 0 0 0 0 0         2026-06-07 07:03:25.439226 2026-06-07 07:03:25.439226 1   International Results CSV 1 h2h://87:209/2007-01-14
30771 Poland 49 Armenia 209 2007-03-28 3 2 0 1 6 1 2001-06-06 D     2026-06-07 07:03:25.476885 2026-06-07 07:03:25.476886 1   International Results CSV 1 h2h://49:209/2007-03-28
30887 Poland 49 Armenia 209 2007-06-06 4 3 0 1 7 1 2007-03-28 L     2026-06-07 07:03:25.499080 2026-06-07 07:03:25.499081 1   International Results CSV 1 h2h://209:49/2007-06-06
31117 Portugal 50 Armenia 209 2007-08-22 2 1 0 1 3 1 1997-08-20 L     2026-06-07 07:03:25.543176 2026-06-07 07:03:25.543177 1   International Results CSV 1 h2h://209:50/2007-08-22
31201 Cyprus 118 Armenia 209 2007-09-08 4 3 0 1 7 2 2006-03-01 W     2026-06-07 07:03:25.559183 2026-06-07 07:03:25.559183 1   International Results CSV 1 h2h://118:209/2007-09-08
31269 Malta 151 Armenia 209 2007-09-12 1 0 1 0 0 1 1994-07-16 L     2026-06-07 07:03:25.572272 2026-06-07 07:03:25.572272 1   International Results CSV 1 h2h://151:209/2007-09-12
31302 Serbia 122 Armenia 209 2007-10-13 1 1 0 0 3 0 2006-10-11 L     2026-06-07 07:03:25.578578 2026-06-07 07:03:25.578578 1   International Results CSV 1 h2h://209:122/2007-10-13
31344 Belgium 12 Armenia 209 2007-10-17 3 3 0 0 5 0 2006-09-06 W     2026-06-07 07:03:25.586677 2026-06-07 07:03:25.586678 1   International Results CSV 1 h2h://12:209/2007-10-17
31442 Portugal 50 Armenia 209 2007-11-17 3 1 0 2 4 2 2007-08-22 D     2026-06-07 07:03:25.605600 2026-06-07 07:03:25.605600 1   International Results CSV 1 h2h://50:209/2007-11-17
31620 Malta 151 Armenia 209 2008-02-02 2 0 2 0 0 2 2007-09-12 L     2026-06-07 07:03:25.640103 2026-06-07 07:03:25.640103 1   International Results CSV 1 h2h://151:209/2008-02-02
31626 Belarus 73 Armenia 209 2008-02-04 3 2 0 1 5 1 2001-06-02 D     2026-06-07 07:03:25.641275 2026-06-07 07:03:25.641275 1   International Results CSV 1 h2h://209:73/2008-02-04
31630 Iceland 104 Armenia 209 2008-02-06 2 1 0 1 2 0 1999-06-05 L     2026-06-07 07:03:25.642040 2026-06-07 07:03:25.642040 1   International Results CSV 1 h2h://209:104/2008-02-06
31857 Moldova 146 Armenia 209 2008-05-28 2 0 1 1 1 2 2000-02-02 L     2026-06-07 07:03:25.686193 2026-06-07 07:03:25.686193 1   International Results CSV 1 h2h://146:209/2008-05-28
31890 Greece 39 Armenia 209 2008-06-01 2 2 0 0 3 0 2003-09-06 L     2026-06-07 07:03:25.692627 2026-06-07 07:03:25.692627 1   International Results CSV 1 h2h://209:39/2008-06-01
32268 Turkey 61 Armenia 209 2008-09-06 0 0 0 0 0 0         2026-06-07 07:03:25.766236 2026-06-07 07:03:25.766236 1   International Results CSV 1 h2h://209:61/2008-09-06
32362 Spain 41 Armenia 209 2008-09-10 4 4 0 0 10 0 2003-10-11 W     2026-06-07 07:03:25.784269 2026-06-07 07:03:25.784269 1   International Results CSV 1 h2h://41:209/2008-09-10
32398 Belgium 12 Armenia 209 2008-10-11 4 4 0 0 8 0 2007-10-17 W     2026-06-07 07:03:25.791221 2026-06-07 07:03:25.791221 1   International Results CSV 1 h2h://12:209/2008-10-11
32762 Latvia 54 Armenia 209 2009-02-11 0 0 0 0 0 0         2026-06-07 07:03:25.861572 2026-06-07 07:03:25.861573 1   International Results CSV 1 h2h://54:209/2009-02-11
32811 Estonia 43 Armenia 209 2009-03-28 2 1 1 0 3 2 1999-08-18 L     2026-06-07 07:03:25.871048 2026-06-07 07:03:25.871048 1   International Results CSV 1 h2h://209:43/2009-03-28
32874 Estonia 43 Armenia 209 2009-04-01 3 1 1 1 5 4 2009-03-28 D     2026-06-07 07:03:25.883167 2026-06-07 07:03:25.883168 1   International Results CSV 1 h2h://43:209/2009-04-01
33157 Moldova 146 Armenia 209 2009-08-12 3 0 1 2 3 4 2008-05-28 D     2026-06-07 07:03:25.937249 2026-06-07 07:03:25.937249 1   International Results CSV 1 h2h://209:146/2009-08-12
33277 Belgium 12 Armenia 209 2009-09-09 5 5 0 0 10 0 2008-10-11 L     2026-06-07 07:03:25.960246 2026-06-07 07:03:25.960247 1   International Results CSV 1 h2h://209:12/2009-09-09

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