Celestial database doesn't pass the test

Backend Development
1

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

2

Hi @diego-lan

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

Happy coding

3

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
4

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
5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.