Can't pass foreign key step (star to galaxy) Databases

Backend Development
1

Here is my star table information. It looks to me like I have setup a foreign key from star table to galaxy table. However, I can’t pass the test "Each star should have a foreign key that references one row in galaxy table.

Any thoughts?

Gerry

±---------
-----------±----------------------±----------±---------±--------------------------------------+
| Column | Type | Collation | Nullable | Default |
±--------------------±----------------------±----------±---------±--------------------------------------+
| star_id | integer | | not null | nextval(‘star_star_id_seq’::regclass) |
| name | character varying(40) | | | |
| distance_from_earth | integer | | | |
| diameter | integer | | | |
| gravity_pull | numeric | | | |
| is_spherical | boolean | | | |
| has_life | boolean | | | |
| galaxy_id | integer | | | |
±--------------------±----------------------±----------±---------±--------------------------------------+
Indexes:
“star_pkey” PRIMARY KEY, btree (star_id)
“star_galaxy_id_key” UNIQUE CONSTRAINT, btree (galaxy_id)
Foreign-key constraints:
“star_galaxy_id_fkey” FOREIGN KEY (galaxy_id) REFERENCES galaxy(galaxy_id)

2

If I’m looking at the test correctly, I think you need to have at least one row in the stars table with a foreign key to a galaxy, and that all the rows in the stars table need to have it. That may be what you are missing. If that doesn’t work, can you share a dump of your database using the command in the instructions, and I will take a look.

3

so do I, I can’t pass that command even i’m trying over and over.

4

I haven’t actually created any rows in any tables yet

5

You need to put data in those tables, including the relevant foreign keys to the correct tables before the check marks get passed successfully.

1 Like