A Comprehensive Database On The FIFA World Cup

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	referee_id Referee Id	family_name Family Name	given_name Given Name	country_name Country Name	confederation_id Confederation Id	confederation_name Confederation Name	confederation_code Confederation Code
1	WC-1930	1930 FIFA World Cup	R-031	Balvay	Thomas	France	CF-6	Union of European Football Associations	UEFA
2	WC-1930	1930 FIFA World Cup	R-070	Christophe	Henri	Belgium	CF-6	Union of European Football Associations	UEFA
3	WC-1930	1930 FIFA World Cup	R-092	de Almeida Rêgo	Gilberto	Brazil	CF-4	South American Football Confederation	CONMEBOL
4	WC-1930	1930 FIFA World Cup	R-182	Langenus	John	Belgium	CF-6	Union of European Football Associations	UEFA
5	WC-1930	1930 FIFA World Cup	R-195	Lombardi	Domingo	Uruguay	CF-4	South American Football Confederation	CONMEBOL
6	WC-1930	1930 FIFA World Cup	R-204	Macías	José	Argentina	CF-4	South American Football Confederation	CONMEBOL
7	WC-1930	1930 FIFA World Cup	R-222	Mateucci	Francisco	Uruguay	CF-4	South American Football Confederation	CONMEBOL
8	WC-1930	1930 FIFA World Cup	R-303	Saucedo	Ulises	Bolivia	CF-4	South American Football Confederation	CONMEBOL
9	WC-1930	1930 FIFA World Cup	R-333	Tejada	Aníbal	Uruguay	CF-4	South American Football Confederation	CONMEBOL
10	WC-1930	1930 FIFA World Cup	R-347	Vallarino	Ricardo	Uruguay	CF-4	South American Football Confederation	CONMEBOL


CREATE TABLE referee_appointments (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "referee_id" VARCHAR,
  "family_name" VARCHAR,
  "given_name" VARCHAR,
  "country_name" VARCHAR,
  "confederation_id" VARCHAR,
  "confederation_name" VARCHAR,
  "confederation_code" VARCHAR
);