Skip to content

Latest commit

 

History

History
24 lines (22 loc) · 553 Bytes

File metadata and controls

24 lines (22 loc) · 553 Bytes

worldcup_database_using_bash_n_psql

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
}
Loading