A Comprehensive Database On The FIFA World Cup

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	team_id Team Id	team_name Team Name	team_code Team Code	manager_id Manager Id	family_name Family Name	given_name Given Name	country_name Country Name
1	WC-1930	1930 FIFA World Cup	T-54	Peru	PER	M-041	Bru	Francisco	Spain
2	WC-1930	1930 FIFA World Cup	T-28	France	FRA	M-054	Caudron	Raoul	France
3	WC-1930	1930 FIFA World Cup	T-09	Brazil	BRA	M-067	de Carvalho Rodrigues	Píndaro	Brazil
4	WC-1930	1930 FIFA World Cup	T-53	Paraguay	PRY	M-079	Durand Laguna	José	Argentina
5	WC-1930	1930 FIFA World Cup	T-06	Belgium	BEL	M-099	Goetinck	Hector	Belgium
6	WC-1930	1930 FIFA World Cup	T-44	Mexico	MEX	M-175	Luque de Serrallonga	Juan	Mexico
7	WC-1930	1930 FIFA World Cup	T-79	United States	USA	M-200	Millar	Robert	Scotland
8	WC-1930	1930 FIFA World Cup	T-03	Argentina	ARG	M-222	Olazar	Francisco	Argentina
9	WC-1930	1930 FIFA World Cup	T-13	Chile	CHL	M-228	Orth	György	Hungary
10	WC-1930	1930 FIFA World Cup	T-58	Romania	ROU	M-260	Rădulescu	Costel	Romania


CREATE TABLE manager_appointments (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR,
  "manager_id" VARCHAR,
  "family_name" VARCHAR,
  "given_name" VARCHAR,
  "country_name" VARCHAR
);