backupdb.bak

--
-- PostgreSQL database dump
--

-- Dumped from database version 14.5
-- Dumped by pg_dump version 14.5 (Homebrew)

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: fibonacci; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.fibonacci (
    id integer NOT NULL,
    number bigint NOT NULL
);


--
-- Name: TABLE fibonacci; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE public.fibonacci IS 'This is a test table to demonstrate the process of request to response.';


--
-- Name: fibonacci_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

ALTER TABLE public.fibonacci ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME public.fibonacci_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: group; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public."group" (
    name character varying,
    location character varying,
    classification character varying,
    group_uid uuid DEFAULT gen_random_uuid() NOT NULL
);


--
-- Name: metric; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.metric (
    metric_uid uuid DEFAULT gen_random_uuid() NOT NULL,
    source_uid uuid NOT NULL,
    data_type character varying NOT NULL,
    units character varying,
    name character varying NOT NULL,
    "asc" boolean DEFAULT true
);


--
-- Name: source; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.source (
    source_uid uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying,
    group_uid uuid NOT NULL,
    tz_info character varying
);


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

COPY public.fibonacci (id, number) FROM stdin;
830	0
831	1
832	1
833	2
834	3
835	5
836	8
837	13
838	21
839	34
840	55
841	89
\.


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

COPY public."group" (name, location, classification, group_uid) FROM stdin;
\.


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

COPY public.metric (metric_uid, source_uid, data_type, units, name, "asc") FROM stdin;
\.


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

COPY public.source (source_uid, name, group_uid, tz_info) FROM stdin;
\.


--
-- Name: fibonacci_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.fibonacci_id_seq', 841, true);


--
-- Name: fibonacci fibonacci_pk; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.fibonacci
    ADD CONSTRAINT fibonacci_pk PRIMARY KEY (id);


--
-- Name: group group_pk; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."group"
    ADD CONSTRAINT group_pk PRIMARY KEY (group_uid);


--
-- Name: metric metric_pk; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.metric
    ADD CONSTRAINT metric_pk PRIMARY KEY (metric_uid);


--
-- Name: source source_pk; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.source
    ADD CONSTRAINT source_pk PRIMARY KEY (source_uid);


--
-- Name: fibonacci_id_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX fibonacci_id_idx ON public.fibonacci USING btree (id);


--
-- Name: metric metric_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.metric
    ADD CONSTRAINT metric_fk FOREIGN KEY (source_uid) REFERENCES public.source(source_uid);


--
-- Name: source source_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.source
    ADD CONSTRAINT source_fk FOREIGN KEY (group_uid) REFERENCES public."group"(group_uid);


--
-- PostgreSQL database dump complete
--