Tell us what’s happening:
Can’t get “At least two columns per table should not accept NULL values” test to pass. Everything else passes.
Your code so far
–
– PostgreSQL database dump
– Dumped from database version 12.9 (Ubuntu 12.9-2.pgdg20.04+1)
– Dumped by pg_dump version 12.9 (Ubuntu 12.9-2.pgdg20.04+1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = ‘UTF8’;
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config(‘search_path’, ‘’, false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
DROP DATABASE universe;
– Name: universe; Type: DATABASE; Schema: -; Owner: freecodecamp
CREATE DATABASE universe WITH TEMPLATE = template0 ENCODING = ‘UTF8’ LC_COLLATE = ‘C.UTF-8’ LC_CTYPE = ‘C.UTF-8’;
ALTER DATABASE universe OWNER TO freecodecamp;
\connect universe
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = ‘UTF8’;
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config(‘search_path’, ‘’, false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = ‘’;
SET default_table_access_method = heap;
–
– Name: galaxy; Type: TABLE; Schema: public; Owner: freecodecamp
CREATE TABLE public.galaxy (
galaxy_id integer NOT NULL,
name character varying(30) NOT NULL,
age integer NOT NULL,
smell_funny boolean,
visited text
);
ALTER TABLE public.galaxy OWNER TO freecodecamp;
–
– Name: galaxy_galaxy_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
CREATE SEQUENCE public.galaxy_galaxy_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.galaxy_galaxy_id_seq OWNER TO freecodecamp;
–
– Name: galaxy_galaxy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
ALTER SEQUENCE public.galaxy_galaxy_id_seq OWNED BY public.galaxy.galaxy_id;
–
– Name: moon; Type: TABLE; Schema: public; Owner: freecodecamp
CREATE TABLE public.moon (
moon_id integer NOT NULL,
name character varying(30),
planet_id integer,
age integer,
smell_funny boolean,
visited text
);
ALTER TABLE public.moon OWNER TO freecodecamp;
–
– Name: moon_moon_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
CREATE SEQUENCE public.moon_moon_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.moon_moon_id_seq OWNER TO freecodecamp;
–
– Name: moon_moon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
ALTER SEQUENCE public.moon_moon_id_seq OWNED BY public.moon.moon_id;
–
– Name: species; Type: TABLE; Schema: public; Owner: freecodecamp
CREATE TABLE public.species (
species_id integer NOT NULL,
description text NOT NULL,
alien_visitors numeric,
name character varying(30) NOT NULL
);
ALTER TABLE public.species OWNER TO freecodecamp;
–
– Name: more_info_more_info_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
CREATE SEQUENCE public.more_info_more_info_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.more_info_more_info_id_seq OWNER TO freecodecamp;
–
– Name: more_info_more_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
ALTER SEQUENCE public.more_info_more_info_id_seq OWNED BY public.species.species_id;
–
– Name: planet; Type: TABLE; Schema: public; Owner: freecodecamp
CREATE TABLE public.planet (
planet_id integer NOT NULL,
name character varying(30) NOT NULL,
star_id integer,
age integer NOT NULL,
smell_funny boolean,
visited text
);
ALTER TABLE public.planet OWNER TO freecodecamp;
–
– Name: planet_planet_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
CREATE SEQUENCE public.planet_planet_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.planet_planet_id_seq OWNER TO freecodecamp;
–
– Name: planet_planet_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
ALTER SEQUENCE public.planet_planet_id_seq OWNED BY public.planet.planet_id;
–
– Name: star; Type: TABLE; Schema: public; Owner: freecodecamp
CREATE TABLE public.star (
star_id integer NOT NULL,
name character varying(30) NOT NULL,
galaxy_id integer NOT NULL,
age integer,
smell_funny boolean
);
ALTER TABLE public.star OWNER TO freecodecamp;
–
– Name: star_star_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
CREATE SEQUENCE public.star_star_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.star_star_id_seq OWNER TO freecodecamp;
–
– Name: star_star_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
ALTER SEQUENCE public.star_star_id_seq OWNED BY public.star.star_id;
–
– Name: galaxy galaxy_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.galaxy ALTER COLUMN galaxy_id SET DEFAULT nextval(‘public.galaxy_galaxy_id_seq’::regclass);
–
– Name: moon moon_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.moon ALTER COLUMN moon_id SET DEFAULT nextval(‘public.moon_moon_id_seq’::regclass);
–
– Name: planet planet_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.planet ALTER COLUMN planet_id SET DEFAULT nextval(‘public.planet_planet_id_seq’::regclass);
–
– Name: species species_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.species ALTER COLUMN species_id SET DEFAULT nextval(‘public.more_info_more_info_id_seq’::regclass);
–
– Name: star star_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.star ALTER COLUMN star_id SET DEFAULT nextval(‘public.star_star_id_seq’::regclass);
–
– Data for Name: galaxy; Type: TABLE DATA; Schema: public; Owner: freecodecamp
INSERT INTO public.galaxy VALUES (1, ‘Milky Way’, 13, NULL, NULL);
INSERT INTO public.galaxy VALUES (2, ‘Andromeda’, 10, NULL, NULL);
INSERT INTO public.galaxy VALUES (3, ‘Messier 32’, 0, NULL, NULL);
INSERT INTO public.galaxy VALUES (4, ‘Barnard’, 1, NULL, NULL);
INSERT INTO public.galaxy VALUES (5, ‘Triangulum’, 2, NULL, NULL);
INSERT INTO public.galaxy VALUES (6, ‘Circinus’, 3, NULL, NULL);
INSERT INTO public.galaxy VALUES (7, ‘Wal-Mart’, 30, true, ‘No’);
–
– Data for Name: moon; Type: TABLE DATA; Schema: public; Owner: freecodecamp
INSERT INTO public.moon VALUES (1, ‘Luna’, 1, 100, NULL, NULL);
INSERT INTO public.moon VALUES (2, ‘Phobos’, 3, 100, NULL, NULL);
INSERT INTO public.moon VALUES (3, ‘Deimos’, 3, 150, NULL, NULL);
INSERT INTO public.moon VALUES (4, ‘Io’, 6, 200, NULL, NULL);
INSERT INTO public.moon VALUES (5, ‘Europa’, 6, 250, NULL, NULL);
INSERT INTO public.moon VALUES (6, ‘Ganymede’, 6, 300, NULL, NULL);
INSERT INTO public.moon VALUES (7, ‘Callisto’, 6, 300, NULL, NULL);
INSERT INTO public.moon VALUES (8, ‘Titan’, 7, 50000, NULL, NULL);
INSERT INTO public.moon VALUES (9, ‘Mimas’, 7, 40000, NULL, NULL);
INSERT INTO public.moon VALUES (10, ‘Tethys’, 7, 46000, NULL, NULL);
INSERT INTO public.moon VALUES (11, ‘Cordelia’, 8, 5000, NULL, NULL);
INSERT INTO public.moon VALUES (12, ‘Ophelia’, 8, 5000, NULL, NULL);
INSERT INTO public.moon VALUES (13, ‘Bianca’, 8, 5000, NULL, NULL);
INSERT INTO public.moon VALUES (14, ‘Cressida’, 8, 5000, NULL, NULL);
INSERT INTO public.moon VALUES (15, ‘Desdemona’, 8, 5000, NULL, NULL);
INSERT INTO public.moon VALUES (16, ‘Juliet’, 8, 5000, NULL, NULL);
INSERT INTO public.moon VALUES (17, ‘Portia’, 8, 5000, NULL, NULL);
INSERT INTO public.moon VALUES (18, ‘Triton’, 9, 3, NULL, NULL);
INSERT INTO public.moon VALUES (19, ‘Nereid’, 9, 4, NULL, NULL);
INSERT INTO public.moon VALUES (20, ‘Halimede’, 9, 6, NULL, NULL);
INSERT INTO public.moon VALUES (21, ‘Sao’, 9, 65, NULL, NULL);
–
– Data for Name: planet; Type: TABLE DATA; Schema: public; Owner: freecodecamp
INSERT INTO public.planet VALUES (1, ‘Earth’, 1, 600, NULL, NULL);
INSERT INTO public.planet VALUES (2, ‘Venus’, 1, 500, NULL, NULL);
INSERT INTO public.planet VALUES (3, ‘Mars’, 1, 700, NULL, NULL);
INSERT INTO public.planet VALUES (4, ‘Kepler-186f’, 3, 550, NULL, NULL);
INSERT INTO public.planet VALUES (5, ‘Mercury’, 1, 400, NULL, NULL);
INSERT INTO public.planet VALUES (6, ‘Jupiter’, 1, 800, NULL, NULL);
INSERT INTO public.planet VALUES (7, ‘Saturn’, 1, 900, NULL, NULL);
INSERT INTO public.planet VALUES (8, ‘Uranus’, 1, 1000, NULL, NULL);
INSERT INTO public.planet VALUES (9, ‘Neptune’, 1, 1100, NULL, NULL);
INSERT INTO public.planet VALUES (10, ‘Qo’‘noS’, 2, 30, NULL, NULL);
INSERT INTO public.planet VALUES (11, ‘Bajor’, 3, 40, NULL, NULL);
INSERT INTO public.planet VALUES (12, ‘Cerberus’, 4, 40, NULL, NULL);
–
– Data for Name: species; Type: TABLE DATA; Schema: public; Owner: freecodecamp
INSERT INTO public.species VALUES (1, ‘People’, 0, ‘Human’);
INSERT INTO public.species VALUES (2, ‘Animal’, 0, ‘Rabbit’);
INSERT INTO public.species VALUES (3, ‘Animal’, 0, ‘Elephant’);
–
– Data for Name: star; Type: TABLE DATA; Schema: public; Owner: freecodecamp
INSERT INTO public.star VALUES (1, ‘Sun’, 1, 4, NULL);
INSERT INTO public.star VALUES (2, ‘Proxima Centauri’, 1, 3, NULL);
INSERT INTO public.star VALUES (4, ‘Wolf 359’, 1, 13, NULL);
INSERT INTO public.star VALUES (5, ‘Var 83’, 5, 15, NULL);
INSERT INTO public.star VALUES (6, ‘WASP-56’, 5, 11, NULL);
INSERT INTO public.star VALUES (3, ‘Kepler-186’, 1, 9, NULL);
–
– Name: galaxy_galaxy_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
SELECT pg_catalog.setval(‘public.galaxy_galaxy_id_seq’, 7, true);
–
– Name: moon_moon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
SELECT pg_catalog.setval(‘public.moon_moon_id_seq’, 21, true);
–
– Name: more_info_more_info_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
SELECT pg_catalog.setval(‘public.more_info_more_info_id_seq’, 3, true);
–
– Name: planet_planet_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
SELECT pg_catalog.setval(‘public.planet_planet_id_seq’, 12, true);
–
– Name: star_star_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
SELECT pg_catalog.setval(‘public.star_star_id_seq’, 6, true);
–
– Name: galaxy galaxy_galaxy_id_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.galaxy
ADD CONSTRAINT galaxy_galaxy_id_key UNIQUE (galaxy_id);
–
– Name: galaxy galaxy_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.galaxy
ADD CONSTRAINT galaxy_pkey PRIMARY KEY (galaxy_id);
–
– Name: moon moon_moon_id_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.moon
ADD CONSTRAINT moon_moon_id_key UNIQUE (moon_id);
–
– Name: moon moon_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.moon
ADD CONSTRAINT moon_pkey PRIMARY KEY (moon_id);
–
– Name: species more_info_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.species
ADD CONSTRAINT more_info_pkey PRIMARY KEY (species_id);
–
– Name: planet planet_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.planet
ADD CONSTRAINT planet_pkey PRIMARY KEY (planet_id);
–
– Name: planet planet_planet_id_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.planet
ADD CONSTRAINT planet_planet_id_key UNIQUE (planet_id);
–
– Name: species species_species_id_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.species
ADD CONSTRAINT species_species_id_key UNIQUE (species_id);
–
– Name: star star_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.star
ADD CONSTRAINT star_pkey PRIMARY KEY (star_id);
–
– Name: star star_star_id_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.star
ADD CONSTRAINT star_star_id_key UNIQUE (star_id);
–
– Name: moon moon_planet_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.moon
ADD CONSTRAINT moon_planet_id_fkey FOREIGN KEY (planet_id) REFERENCES public.planet(planet_id);
–
– Name: planet planet_star_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.planet
ADD CONSTRAINT planet_star_id_fkey FOREIGN KEY (star_id) REFERENCES public.star(star_id);
–
– Name: star star_galaxy_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
ALTER TABLE ONLY public.star
ADD CONSTRAINT star_galaxy_id_fkey FOREIGN KEY (galaxy_id) REFERENCES public.galaxy(galaxy_id);
–
– PostgreSQL database dump complete
Your browser information:
Challenge Information:
Celestial Bodies Database - Build a Celestial Bodies Database