A Comprehensive Database On The FIFA World Cup

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	award_id Award Id	award_name Award Name	shared Shared	player_id Player Id	family_name Family Name	given_name Given Name	team_id Team Id	team_name Team Name	team_code Team Code
1	WC-1930	1930 FIFA World Cup	A-4	Golden Boot		P-04418	Stábile	Guillermo	T-03	Argentina	ARG
2	WC-1930	1930 FIFA World Cup	A-5	Silver Boot		P-00724	Cea	Pedro	T-80	Uruguay	URY
3	WC-1930	1930 FIFA World Cup	A-6	Bronze Boot		P-09215	Patenaude	Bert	T-79	United States	USA
4	WC-1934	1934 FIFA World Cup	A-4	Golden Boot		P-05627	Nejedlý	Oldřich	T-20	Czechoslovakia	CSK
5	WC-1934	1934 FIFA World Cup	A-5	Silver Boot	1	P-03649	Conen	Edmund	T-29	Germany	DEU
6	WC-1934	1934 FIFA World Cup	A-5	Silver Boot	1	P-02250	Schiavio	Angelo	T-39	Italy	ITA
7	WC-1938	1938 FIFA World Cup	A-4	Golden Boot		P-03023	Leônidas	not applicable	T-09	Brazil	BRA
8	WC-1938	1938 FIFA World Cup	A-5	Silver Boot	1	P-08824	Piola	Silvio	T-39	Italy	ITA
9	WC-1938	1938 FIFA World Cup	A-5	Silver Boot	1	P-02366	Sárosi	György	T-34	Hungary	HUN
10	WC-1938	1938 FIFA World Cup	A-5	Silver Boot	1	P-04466	Zsengellér	Gyula	T-34	Hungary	HUN


CREATE TABLE award_winners (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "award_id" VARCHAR,
  "award_name" VARCHAR,
  "shared" BIGINT,
  "player_id" VARCHAR,
  "family_name" VARCHAR,
  "given_name" VARCHAR,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR
);