Celestial Bodies Database Not listing complete

Backend Development
1

Hi, I’m creating the foreign keys necessary for the challenge but its not counting as completed in the task list.

Code so far

CREATE DATABASE universe();
\c universe

CREATE TABLE galaxy(
galaxy_id SERIAL PRIMARY KEY,
name VARCHAR(30) NOT NULL,
g_noNull NUMERIC NOT NULL,
galaxy_types TEXT,
is_bool BOOLEAN,
n_planets INT,
n_stars INT UNIQUE,
);

CREATE TABLE star(
star_id SERIAL PRIMARY KEY,
name VARCHAR(30) NOT NULL,
s_noNull NUMERIC NOT NULL,
is_bool BOOLEAN,
n_planets TEXT UNIQUE,
n_stars INT,
CONSTRAINT fk_g_stars FOREIGN KEY(n_stars) REFERENCES galaxy(n_stars));

CREATE TABLE planet(planet_id SERIAL PRIMARY KEY, name VARCHAR(30) NOT NULL, p_noNull NUMERIC NOT NULL, is_bool BOOLEAN, n_moons INT UNIQUE, n_planets TEXT, CONSTRAINT fk_n_planets FOREIGN KEY(n_planets) REFERENCES star(n_planets));

CREATE TABLE moon(moon_id SERIAL PRIMARY KEY, name VARCHAR(30) NOT NULL, m_noNull NUMERIC NOT NULL, is_bool BOOLEAN, n_moons INT, color TEXT UNIQUE, CONSTRAINT fk_n_moons FOREIGN KEY(n_moons) REFERENCES planet(n_moons));

CREATE TABLE fifth(fifth_id SERIAL PRIMARY KEY, name VARCHAR(30) NOT NULL, col2 BOOLEAN NOT NULL, rcol TEXT, rcol2 TEXT);

Challenge Information:

Celestial Bodies Database - Build a Celestial Bodies Database