Celestial bodies foreign keys not being accepted

ThabaniM · February 2, 2023, 9:44am

All the foreign key tasks on the checklist are not being accepted here is one example. What did i do wrong? I made galaxy id the foreign key to star or is it supposed to be the other way around.

+--------------------+-----------------------+-----------+----------+---------------------------------------+
|       Column       |         Type          | Collation | Nullable |                Default                |
+--------------------+-----------------------+-----------+----------+---------------------------------------+
| star_id            | integer               |           | not null | nextval('star_star_id_seq'::regclass) |
| name               | character varying(30) |           | not null |                                       |
| type               | character varying(20) |           |          |                                       |
| asterism           | character varying(20) |           |          |                                       |
| constellation      | character varying(20) |           |          |                                       |
| apparent_magnitude | integer               |           |          |                                       |
| color              | character varying(20) |           |          |                                       |
| galaxy_id          | integer               |           |          |                                       |
+--------------------+-----------------------+-----------+----------+---------------------------------------+
Indexes:
    "star_pkey" PRIMARY KEY, btree (star_id)
    "star_name_key" UNIQUE CONSTRAINT, btree (name)
Foreign-key constraints:
    "star_galaxy_id_fkey" FOREIGN KEY (galaxy_id) REFERENCES galaxy(galaxy_id)
Referenced by:
    TABLE "planet" CONSTRAINT "planet_star_id_fkey" FOREIGN KEY (star_id) REFERENCES star(star_id)```

hbar1st · February 2, 2023, 10:46am

If the schema you showed belongs to the star table then the star_id column should not be a foreign key at all.
Instead the galaxy_id should be the foreign key and it should like to the primary key of the same name in the galaxy table.

ThabaniM · February 2, 2023, 11:37am

yes, galaxy_id is the foreign key of this star table and it’s the primary key of the galaxy table

hbar1st · February 2, 2023, 11:48am

Please share the schemas of all the tables you created. Also make sure your foreign keys are all set to not null.

(And add 3 rows to each table)

ThabaniM · February 4, 2023, 4:12pm

Ok here you go

hbar1st · February 4, 2023, 4:40pm

Make sure all the foreign keys are not null (star_id in planet table seems to be missing that).

Also the test will not pass without some data added to the tables. So make sure you have data in each table.

Also can you clarify which specific test(s) is failing? (All the foreign key ones or a one in particular?)

ThabaniM · February 5, 2023, 9:28am

ok i have corrected that. Yeah, i was expecting all the foreign key tests to pass by now but I don’t have any rows of data yet in any table.

hbar1st · February 5, 2023, 9:31am

The test requires that you have the rows filled in the tables.