A Comprehensive Database On The FIFA World Cup

key_id Key Id	confederation_id Confederation Id	confederation_name Confederation Name	confederation_code Confederation Code	confederation_wikipedia_link Confederation Wikipedia Link
1	CF-1	Asian Football Confederation	AFC	https://en.wikipedia.org/wiki/Asian_Football_Confederation
2	CF-2	Confederation of African Football	CAF	https://en.wikipedia.org/wiki/Confederation_of_African_Football
3	CF-3	Confederation of North, Central American and Caribbean Association Football	CONCACAF	https://en.wikipedia.org/wiki/CONCACAF
4	CF-4	South American Football Confederation	CONMEBOL	https://en.wikipedia.org/wiki/CONMEBOL
5	CF-5	Oceania Football Confederation	OFC	https://en.wikipedia.org/wiki/Oceania_Football_Confederation
6	CF-6	Union of European Football Associations	UEFA	https://en.wikipedia.org/wiki/UEFA


CREATE TABLE confederations (
  "key_id" BIGINT,
  "confederation_id" VARCHAR,
  "confederation_name" VARCHAR,
  "confederation_code" VARCHAR,
  "confederation_wikipedia_link" VARCHAR
);