Celestial database doesn't pass the test

Tell us what’s happening:

Hi. I’m doing the Celestial Bodies Database project. It doesn’t pass the test due to:
_Each table should have at least three rows (the lowest number of rows is 6, as another checkmark requires).
_Each primary key column should follow the naming convention (every single one does follow the convention).
_Each foreign key column should have the same name as the column it is referencing (each one has it).
Has anybody an idea why it still did not pass the test?

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36

Challenge Information:

Learn Relational Databases by Building a Mario Database - Build a Mario Database

Hi @diego-lan

Please post screen shots of your tables using SELECT * FROM <table>;

Happy coding

I had to rebuild some tables when I came back to the project. Despite doing the same as I did yesterday, everything’s ok except for the last two checkmarks:
_ Each primary key column should follow the naming convention table_name_id
_Each foreign key column should have the same name as the column it is referencing
It doesn’t allow me to attach screenshots of \d and SELECT * of every table. So I guess I need to save and Reset it until it works.
Thanks for your help @Teller

1 Like

an other thing you can do here is to create the database dump and share that. Or you can share a snapshot of your workspace

1 Like