-- -- 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: - -- CREATE TABLE public.galaxy ( galaxy_id integer NOT NULL, name character varying(255) NOT NULL, galaxy_type_id integer, distance_from_earth numeric NOT NULL, has_dark_matter boolean, diameter_light_years integer ); -- -- Name: galaxy_galaxy_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.galaxy_galaxy_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: galaxy_galaxy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.galaxy_galaxy_id_seq OWNED BY public.galaxy.galaxy_id; -- -- Name: galaxy_type; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.galaxy_type ( galaxy_type_id integer NOT NULL, name character varying(255) NOT NULL, description text NOT NULL ); -- -- Name: galaxy_type_galaxy_type_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.galaxy_type_galaxy_type_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: galaxy_type_galaxy_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.galaxy_type_galaxy_type_id_seq OWNED BY public.galaxy_type.galaxy_type_id; -- -- Name: moon; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.moon ( moon_id integer NOT NULL, name character varying(255) NOT NULL, planet_id integer NOT NULL, has_atmosphere boolean, diameter_km numeric, discovery_year integer ); -- -- Name: moon_moon_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.moon_moon_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: moon_moon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.moon_moon_id_seq OWNED BY public.moon.moon_id; -- -- Name: planet; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.planet ( planet_id integer NOT NULL, name character varying(255) NOT NULL, star_id integer NOT NULL, has_rings boolean, orbital_period_days numeric, moons_count integer ); -- -- Name: planet_planet_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.planet_planet_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: planet_planet_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.planet_planet_id_seq OWNED BY public.planet.planet_id; -- -- Name: star; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.star ( star_id integer NOT NULL, name character varying(255) NOT NULL, galaxy_id integer NOT NULL, mass_solar_masses numeric, is_variable boolean, age_million_years integer ); -- -- Name: star_star_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.star_star_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: star_star_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.star_star_id_seq OWNED BY public.star.star_id; -- -- Name: galaxy galaxy_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.galaxy ALTER COLUMN galaxy_id SET DEFAULT nextval('public.galaxy_galaxy_id_seq'::regclass); -- -- Name: galaxy_type galaxy_type_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.galaxy_type ALTER COLUMN galaxy_type_id SET DEFAULT nextval('public.galaxy_type_galaxy_type_id_seq'::regclass); -- -- Name: moon moon_id; Type: DEFAULT; Schema: public; Owner: - -- 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: - -- ALTER TABLE ONLY public.planet ALTER COLUMN planet_id SET DEFAULT nextval('public.planet_planet_id_seq'::regclass); -- -- Name: star star_id; Type: DEFAULT; Schema: public; Owner: - -- 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: - -- COPY public.galaxy (galaxy_id, name, galaxy_type_id, distance_from_earth, has_dark_matter, diameter_light_years) FROM stdin; 1 Milky Way 1 0 t 105700 2 Andromeda 1 2537000 t 220000 3 Triangulum 1 2723000 t 60000 4 Whirlpool 1 23160000 t 76000 5 Cartwheel 3 500000000 t 150000 6 Sombrero 4 29350000 t 50000 \. -- -- Data for Name: galaxy_type; Type: TABLE DATA; Schema: public; Owner: - -- COPY public.galaxy_type (galaxy_type_id, name, description) FROM stdin; 1 Spiral A galaxy with a flat, rotating disk containing stars, gas and dust, and a central concentration of stars 2 Elliptical A galaxy with an ellipsoidal shape and a smooth, nearly featureless brightness profile 3 Irregular A galaxy that does not have a distinct regular shape 4 Lenticular A galaxy intermediate between elliptical and spiral galaxies \. -- -- Data for Name: moon; Type: TABLE DATA; Schema: public; Owner: - -- COPY public.moon (moon_id, name, planet_id, has_atmosphere, diameter_km, discovery_year) FROM stdin; 1 The Moon 3 f 3474.8 \N 2 Phobos 4 f 22.2 1877 3 Deimos 4 f 12.4 1877 4 Io 5 f 3643.2 1610 5 Europa 5 f 3121.6 1610 6 Ganymede 5 t 5268.2 1610 7 Callisto 5 f 4820.6 1610 8 Amalthea 5 f 167 1892 9 Titan 6 t 5149.5 1655 10 Rhea 6 f 1527 1672 11 Iapetus 6 f 1469 1671 12 Dione 6 f 1123 1684 13 Tethys 6 f 1062 1684 14 Enceladus 6 f 504 1789 15 Titania 7 f 1578 1787 16 Oberon 7 f 1523 1787 17 Umbriel 7 f 1169 1851 18 Ariel 7 f 1158 1851 19 Miranda 7 f 471 1948 20 Triton 8 t 2706.8 1846 21 Nereid 8 f 340 1949 \. -- -- Data for Name: planet; Type: TABLE DATA; Schema: public; Owner: - -- COPY public.planet (planet_id, name, star_id, has_rings, orbital_period_days, moons_count) FROM stdin; 1 Mercury 1 f 88 0 2 Venus 1 f 224.7 0 3 Earth 1 f 365.25 1 4 Mars 1 f 687 2 5 Jupiter 1 t 4331 4 6 Saturn 1 t 10747 5 7 Uranus 1 t 30589 3 8 Neptune 1 t 59800 2 9 Proxima b 6 f 11.2 0 10 Sirius Ab 2 f 300 0 11 Rigel b 4 f 500 0 12 Centauri Bb 5 f 3.2 0 \. -- -- Data for Name: star; Type: TABLE DATA; Schema: public; Owner: - -- COPY public.star (star_id, name, galaxy_id, mass_solar_masses, is_variable, age_million_years) FROM stdin; 1 Sun 1 1.0 f 4600 2 Sirius 1 2.02 f 242 3 Betelgeuse 1 16.5 t 10 4 Rigel 1 21 t 8 5 Alpha Centauri A 1 1.1 f 4850 6 Proxima Centauri 1 0.12 t 4850 \. -- -- Name: galaxy_galaxy_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('public.galaxy_galaxy_id_seq', 6, true); -- -- Name: galaxy_type_galaxy_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('public.galaxy_type_galaxy_type_id_seq', 4, true); -- -- Name: moon_moon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('public.moon_moon_id_seq', 21, true); -- -- Name: planet_planet_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('public.planet_planet_id_seq', 12, true); -- -- Name: star_star_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('public.star_star_id_seq', 6, true); -- -- Name: galaxy galaxy_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.galaxy ADD CONSTRAINT galaxy_name_key UNIQUE (name); -- -- Name: galaxy galaxy_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.galaxy ADD CONSTRAINT galaxy_pkey PRIMARY KEY (galaxy_id); -- -- Name: galaxy_type galaxy_type_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.galaxy_type ADD CONSTRAINT galaxy_type_name_key UNIQUE (name); -- -- Name: galaxy_type galaxy_type_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.galaxy_type ADD CONSTRAINT galaxy_type_pkey PRIMARY KEY (galaxy_type_id); -- -- Name: moon moon_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.moon ADD CONSTRAINT moon_name_key UNIQUE (name); -- -- Name: moon moon_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.moon ADD CONSTRAINT moon_pkey PRIMARY KEY (moon_id); -- -- Name: planet planet_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.planet ADD CONSTRAINT planet_name_key UNIQUE (name); -- -- Name: planet planet_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.planet ADD CONSTRAINT planet_pkey PRIMARY KEY (planet_id); -- -- Name: star star_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.star ADD CONSTRAINT star_name_key UNIQUE (name); -- -- Name: star star_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.star ADD CONSTRAINT star_pkey PRIMARY KEY (star_id); -- -- Name: galaxy galaxy_galaxy_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.galaxy ADD CONSTRAINT galaxy_galaxy_type_id_fkey FOREIGN KEY (galaxy_type_id) REFERENCES public.galaxy_type(galaxy_type_id); -- -- Name: moon moon_planet_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- 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: - -- 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: - -- ALTER TABLE ONLY public.star ADD CONSTRAINT star_galaxy_id_fkey FOREIGN KEY (galaxy_id) REFERENCES public.galaxy(galaxy_id); -- -- PostgreSQL database dump complete --