--
-- PostgreSQL database dump
--

\restrict oWU4oQLZZLYBXwhz8XbAIVJzH2bHVuRyvGB3O6MgFqwQ6jyawqC2IkO1YgeBAQW

-- Dumped from database version 16.10
-- Dumped by pg_dump version 16.10

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

CREATE TABLE public.checklist_dam (
    checklist_id bigint NOT NULL,
    dam_id bigint NOT NULL
);


ALTER TABLE public.checklist_dam OWNER TO postgres;

--
-- Name: checklists; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.checklists (
    id bigint NOT NULL,
    created_at timestamp(6) without time zone,
    name character varying(255) NOT NULL
);


ALTER TABLE public.checklists OWNER TO postgres;

--
-- Name: checklists_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


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

INSERT INTO public.checklist_dam VALUES (1, 4);
INSERT INTO public.checklist_dam VALUES (2, 3);
INSERT INTO public.checklist_dam VALUES (3, 2);


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

INSERT INTO public.checklists VALUES (1, '2025-12-21 15:45:10.071749', 'Checklist 01');
INSERT INTO public.checklists VALUES (2, '2025-12-22 09:52:53.265492', 'Checklist 01');
INSERT INTO public.checklists VALUES (3, '2025-12-22 15:14:16.356343', 'TESTEEEE');


--
-- Name: checklists_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.checklists_id_seq', 3, true);


--
-- Name: checklist_dam checklist_dam_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.checklist_dam
    ADD CONSTRAINT checklist_dam_pkey PRIMARY KEY (checklist_id, dam_id);


--
-- Name: checklists checklists_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.checklists
    ADD CONSTRAINT checklists_pkey PRIMARY KEY (id);


--
-- Name: idx_checklist_created_at; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_checklist_created_at ON public.checklists USING btree (created_at);


--
-- Name: idx_checklist_name; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_checklist_name ON public.checklists USING btree (name);


--
-- Name: checklist_dam fk43rom8q80db2jn3ck2g1m4e8d; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.checklist_dam
    ADD CONSTRAINT fk43rom8q80db2jn3ck2g1m4e8d FOREIGN KEY (dam_id) REFERENCES public.dam(id);


--
-- Name: checklist_dam fkfytsig8waln14352kfj5k5c07; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.checklist_dam
    ADD CONSTRAINT fkfytsig8waln14352kfj5k5c07 FOREIGN KEY (checklist_id) REFERENCES public.checklists(id);


--
-- PostgreSQL database dump complete
--

\unrestrict oWU4oQLZZLYBXwhz8XbAIVJzH2bHVuRyvGB3O6MgFqwQ6jyawqC2IkO1YgeBAQW

