A Comprehensive Database On The FIFA World Cup

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	position Position	team_id Team Id	team_name Team Name	team_code Team Code
1	WC-1930	1930 FIFA World Cup	1	T-80	Uruguay	URY
2	WC-1930	1930 FIFA World Cup	2	T-03	Argentina	ARG
3	WC-1930	1930 FIFA World Cup	3	T-79	United States	USA
4	WC-1930	1930 FIFA World Cup	4	T-83	Yugoslavia	YUG
5	WC-1934	1934 FIFA World Cup	1	T-39	Italy	ITA
6	WC-1934	1934 FIFA World Cup	2	T-20	Czechoslovakia	CSK
7	WC-1934	1934 FIFA World Cup	3	T-29	Germany	DEU
8	WC-1934	1934 FIFA World Cup	4	T-05	Austria	AUT
9	WC-1938	1938 FIFA World Cup	1	T-39	Italy	ITA
10	WC-1938	1938 FIFA World Cup	2	T-34	Hungary	HUN


CREATE TABLE tournament_standings (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "position" BIGINT,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR
);