This project has the SQL commands for creating the Worldcup database based on FreeCodeCamp's relational database project. It also contains a bash script for inserting data from the CSV file into the database.
---
title: WorldCup Database
---
erDiagram
games }|--|{ teams : contains
games{
SERIAL game_id PK
VARCHAR(100) round
INT YEAR
INT winner_id FK
INT opponent_id FK
INT winner_goals
INT opponent_goals
}
teams{
SERIAL team_id PK
VARCHAR(100) name
}