`backups/inspection-violation-20260507-235846.sql`

154 lines
--
-- PostgreSQL database dump
--

\restrict RWcs8X0aExxyap1Q1T1TouDPlRBlzbKggZa2XOaKcSG0LRfjIgqu6FKEowAYSma

-- Dumped from database version 14.22 (Homebrew)
-- Dumped by pg_dump version 14.22 (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: inspection; Type: TABLE; Schema: public; Owner: stevestudio2
--

CREATE TABLE public.inspection (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    facility_id text NOT NULL,
    serial_number text NOT NULL,
    activity_date date NOT NULL,
    service_code text,
    service_description text,
    score integer,
    grade character(1),
    program_status text,
    employee_id text,
    source_pulled_at timestamp with time zone NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.inspection OWNER TO stevestudio2;

--
-- Name: violation; Type: TABLE; Schema: public; Owner: stevestudio2
--

CREATE TABLE public.violation (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    serial_number text NOT NULL,
    violation_status text,
    violation_code text,
    violation_description text,
    points integer,
    created_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.violation OWNER TO stevestudio2;

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

COPY public.inspection (id, facility_id, serial_number, activity_date, service_code, service_description, score, grade, program_status, employee_id, source_pulled_at, created_at) FROM stdin;
\.


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

COPY public.violation (id, serial_number, violation_status, violation_code, violation_description, points, created_at) FROM stdin;
\.


--
-- Name: inspection inspection_pkey; Type: CONSTRAINT; Schema: public; Owner: stevestudio2
--

ALTER TABLE ONLY public.inspection
    ADD CONSTRAINT inspection_pkey PRIMARY KEY (id);


--
-- Name: inspection inspection_serial_number_key; Type: CONSTRAINT; Schema: public; Owner: stevestudio2
--

ALTER TABLE ONLY public.inspection
    ADD CONSTRAINT inspection_serial_number_key UNIQUE (serial_number);


--
-- Name: violation violation_pkey; Type: CONSTRAINT; Schema: public; Owner: stevestudio2
--

ALTER TABLE ONLY public.violation
    ADD CONSTRAINT violation_pkey PRIMARY KEY (id);


--
-- Name: idx_inspection_date; Type: INDEX; Schema: public; Owner: stevestudio2
--

CREATE INDEX idx_inspection_date ON public.inspection USING btree (activity_date DESC);


--
-- Name: idx_inspection_facility; Type: INDEX; Schema: public; Owner: stevestudio2
--

CREATE INDEX idx_inspection_facility ON public.inspection USING btree (facility_id);


--
-- Name: idx_inspection_grade; Type: INDEX; Schema: public; Owner: stevestudio2
--

CREATE INDEX idx_inspection_grade ON public.inspection USING btree (grade);


--
-- Name: idx_violation_inspection; Type: INDEX; Schema: public; Owner: stevestudio2
--

CREATE INDEX idx_violation_inspection ON public.violation USING btree (serial_number);


--
-- Name: inspection inspection_facility_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stevestudio2
--

ALTER TABLE ONLY public.inspection
    ADD CONSTRAINT inspection_facility_id_fkey FOREIGN KEY (facility_id) REFERENCES public.facility(facility_id) ON DELETE CASCADE;


--
-- Name: violation violation_serial_number_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stevestudio2
--

ALTER TABLE ONLY public.violation
    ADD CONSTRAINT violation_serial_number_fkey FOREIGN KEY (serial_number) REFERENCES public.inspection(serial_number) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--

\unrestrict RWcs8X0aExxyap1Q1T1TouDPlRBlzbKggZa2XOaKcSG0LRfjIgqu6FKEowAYSma