World Cup Database - Build a World Cup Database

Backend Development
1

Tell us what’s happening:
hey I need help i don’t know that to do everything it’s passing but
Your games table should have a game_id column that is a type of SERIAL and is the primary key, a year column of type INT , and a round column of type VARCHAR
AND
All of your columns should have the NOT NULL constraint
are not passing and create the code for it and everything its “NOT NULL” too so I don’t understand why its not working please help
Describe your issue in detail here.

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.5 Safari/605.1.15

Challenge: World Cup Database - Build a World Cup Database

Link to the challenge:

2

can you provide us a list of your schema? (using /l and /d commands?)

3

yes its in GitHub already its the PSQL and BASH fils
and thank you for attending my help

4

or you need some different info?

5

If you could capture the current state of the database and tables, that would be great (I think your sql file doesn’t show in one shot the results of those two /l and /d for each table )

6

Screen Shot 2022-09-30 at 1.48.50 PM
Screen Shot 2022-09-30 at 1.48.50 PM970×535 83.6 KB

Screen Shot 2022-09-30 at 1.50.05 PM
Screen Shot 2022-09-30 at 1.50.05 PM1062×161 21.4 KB

this one its suppose to fix the Your games table should have a game_id column that is a type of SERIAL and is the primary key, a year column of type INT , and a round column of type VARCHAR

7

ok so for this one, do you see a game_id anywhere? (I just see a games_id)

8

and the All of your columns should have the NOT NULL constraint too

9

too how I fixe what I suppose to put?

10

Screen Shot 2022-09-30 at 2.04.24 PM
its not this one?

11

I am not sure what you are planning. For eg. Do you want to drop the whole table and recreate it from scratch? Or do you just want to altar it (column by column)?

12

I think alter it could be batter because all commands are done already all thing its pass only this 2 things dint pass as you can see

Screen Shot 2022-09-30 at 2.11.34 PM
Screen Shot 2022-09-30 at 2.11.34 PM1165×647 89.2 KB

13

That sounds like a plan. Do you know how to altar a column in psql? (I just google the command each time myself)

14

yes by ALTER TABLE and ADD COLUMN

15

sorry or ALTER TABLE and ALTER COLUMN

16

Ok, do you want to try and let me know if you need more help?

19

its show ing same message Your “games” table should have the correct “game_id”, “year”, and “round” columns

sorry to ask. if you did the game_id column how would you make the line code for it ?

20

Honestly I would just google the command.

What command did you try?

21

I TRY It 3 of this

ALTER TABLE === ALTER COLUMN ====SET NOT NULL;

ALTER TABLE ==== ADD COLUMN

ALTER TABLE ===ALTER COLUMN ===DROP NOT NULL;

22

Try googling this: “psql rename column”

And see what you get. Just try to fix one thing at a time.