universe.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4)
-- Dumped by pg_dump version 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4)

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(20) NOT NULL,
    count numeric,
    text text,
    is_delete boolean,
    age integer
);


ALTER TABLE public.galaxy OWNER TO freecodecamp;

--
-- Name: moon; Type: TABLE; Schema: public; Owner: freecodecamp
--

CREATE TABLE public.moon (
    moon_id integer NOT NULL,
    name character varying(20) NOT NULL,
    count numeric,
    text text,
    is_delete boolean,
    age integer,
    planet_id integer
);


ALTER TABLE public.moon OWNER TO freecodecamp;

--
-- Name: planet; Type: TABLE; Schema: public; Owner: freecodecamp
--

CREATE TABLE public.planet (
    planet_id integer NOT NULL,
    name character varying(20) NOT NULL,
    count numeric,
    text text,
    is_delete boolean,
    star_id integer
);


ALTER TABLE public.planet OWNER TO freecodecamp;

--
-- Name: star; Type: TABLE; Schema: public; Owner: freecodecamp
--

CREATE TABLE public.star (
    star_id integer NOT NULL,
    name character varying(20) NOT NULL,
    count numeric,
    text text,
    is_delete boolean,
    galaxy_id integer
);


ALTER TABLE public.star OWNER TO freecodecamp;

--
-- Name: text; Type: TABLE; Schema: public; Owner: freecodecamp
--

CREATE TABLE public.text (
    text_id integer NOT NULL,
    name character varying(20) NOT NULL,
    is_delete boolean
);


ALTER TABLE public.text OWNER TO freecodecamp;

--
-- Name: text_text_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
--

CREATE SEQUENCE public.text_text_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.text_text_id_seq OWNER TO freecodecamp;

--
-- Name: text_text_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
--

ALTER SEQUENCE public.text_text_id_seq OWNED BY public.text.text_id;


--
-- Name: text text_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.text ALTER COLUMN text_id SET DEFAULT nextval('public.text_text_id_seq'::regclass);


--
-- Data for Name: galaxy; Type: TABLE DATA; Schema: public; Owner: freecodecamp
--

COPY public.galaxy (galaxy_id, name, count, text, is_delete, age) FROM stdin;
2	NNN2	15	hello	f	2
1	CCC1	\N	Hi	f	22
3	GGG3	\N	uni	f	113
4	GGG4	\N	uni	f	113
5	GGG5	\N	uni	f	113
6	GGG6	\N	uni	f	113
\.


--
-- Data for Name: moon; Type: TABLE DATA; Schema: public; Owner: freecodecamp
--

COPY public.moon (moon_id, name, count, text, is_delete, age, planet_id) FROM stdin;
1	moon1	22	uni	f	22	1
2	moon2	22	uni	f	22	2
3	moon3	22	uni	f	22	3
4	moon4	22	uni	f	22	4
5	moon5	22	uni	f	22	5
6	moon6	22	uni	f	22	6
7	moon7	22	uni	f	22	7
8	moon8	22	uni	f	22	8
9	moon9	22	uni	f	22	9
10	moon10	22	uni	f	22	10
11	moon11	22	uni	f	22	1
12	moon12	22	uni	f	22	2
13	moon13	22	uni	f	22	3
14	moon14	22	uni	f	22	4
15	moon15	22	uni	f	22	5
16	moon16	22	uni	f	22	6
17	moon17	22	uni	f	22	7
18	moon18	22	uni	f	22	8
19	moon19	22	uni	f	22	9
20	moon20	22	uni	f	22	10
\.


--
-- Data for Name: planet; Type: TABLE DATA; Schema: public; Owner: freecodecamp
--

COPY public.planet (planet_id, name, count, text, is_delete, star_id) FROM stdin;
1	planet1	\N	uni	f	1
2	planet2	\N	uni	f	2
3	planet3	\N	uni	f	3
4	planet4	\N	uni	f	4
5	planet5	\N	uni	f	5
6	planet6	\N	uni	f	6
7	planet7	\N	uni	f	1
8	planet8	\N	uni	f	2
9	planet9	\N	uni	f	3
10	planet10	\N	uni	f	4
11	planet11	\N	uni	f	5
12	planet12	\N	uni	f	6
\.


--
-- Data for Name: star; Type: TABLE DATA; Schema: public; Owner: freecodecamp
--

COPY public.star (star_id, name, count, text, is_delete, galaxy_id) FROM stdin;
1	star1	\N	uni	f	1
2	star2	\N	uni	f	2
3	star3	\N	uni	f	3
4	star4	\N	uni	f	4
5	star5	\N	uni	f	5
6	star6	\N	uni	f	6
\.


--
-- Data for Name: text; Type: TABLE DATA; Schema: public; Owner: freecodecamp
--

COPY public.text (text_id, name, is_delete) FROM stdin;
1	aaa	f
2	jjj	f
3	qqq	f
4	kkk	f
\.


--
-- Name: text_text_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
--

SELECT pg_catalog.setval('public.text_text_id_seq', 4, true);


--
-- 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_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.moon
    ADD CONSTRAINT moon_pkey PRIMARY KEY (moon_id);


--
-- Name: planet planet_name_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.planet
    ADD CONSTRAINT planet_name_key UNIQUE (name);


--
-- Name: planet plant_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.planet
    ADD CONSTRAINT plant_pkey PRIMARY KEY (planet_id);


--
-- Name: star star_name_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.star
    ADD CONSTRAINT star_name_key UNIQUE (name);


--
-- Name: star star_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.star
    ADD CONSTRAINT star_pkey PRIMARY KEY (star_id);


--
-- Name: text text_name_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.text
    ADD CONSTRAINT text_name_key UNIQUE (name);


--
-- Name: text text_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.text
    ADD CONSTRAINT text_pkey PRIMARY KEY (text_id);


--
-- Name: moon uni_moon_name; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.moon
    ADD CONSTRAINT uni_moon_name UNIQUE (name);


--
-- Name: galaxy uni_name; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.galaxy
    ADD CONSTRAINT uni_name UNIQUE (name);


--
-- Name: star fk_galax_id; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.star
    ADD CONSTRAINT fk_galax_id FOREIGN KEY (galaxy_id) REFERENCES public.galaxy(galaxy_id);


--
-- Name: moon fk_planet_id; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.moon
    ADD CONSTRAINT fk_planet_id FOREIGN KEY (planet_id) REFERENCES public.planet(planet_id);


--
-- Name: planet fk_star_id; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
--

ALTER TABLE ONLY public.planet
    ADD CONSTRAINT fk_star_id FOREIGN KEY (star_id) REFERENCES public.star(star_id);


--
-- PostgreSQL database dump complete
--