docker-compose : time="2026-04-20T17:16:23+02:00" level=warning 
msg="C:\\Users\\renet\\.openclaw\\workspace\\buchhaltungs-app\\docker-compose.yml: the attribute `version` is 
obsolete, it will be ignored, please remove it to avoid potential confusion"
In Zeile:1 Zeichen:1
+ docker-compose exec -T db pg_dump -U postgres -d buchhaltung > backup ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (time="2026-04-2...tial confusion":String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError
 
--
-- PostgreSQL database dump
--

\restrict QbFsNGLJ1g0UVWkDTi82fkgZRTYWIHMW3dMqopRxdOTRZ8slTWsoVZKCZWSqei1

-- Dumped from database version 16.13
-- Dumped by pg_dump version 16.13

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

CREATE TABLE public.belege (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    date date NOT NULL,
    haendler character varying(255),
    betrag numeric(10,2) NOT NULL,
    mwst_satz numeric(4,2) DEFAULT 19.00,
    kategorie character varying(100),
    status character varying(50) DEFAULT 'neu'::character varying,
    file_path character varying(500),
    ocr_text text,
    created_at timestamp without time zone DEFAULT now(),
    updated_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.belege OWNER TO postgres;

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

CREATE TABLE public.fixe_ausgaben (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    kategorie character varying(100),
    betrag numeric(10,2) NOT NULL,
    intervall character varying(50) DEFAULT 'monatlich'::character varying,
    faelligkeit_tag integer,
    is_active boolean DEFAULT true,
    created_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.fixe_ausgaben OWNER TO postgres;

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

CREATE TABLE public.kostenplanung (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    objekt character varying(100) NOT NULL,
    name character varying(255) NOT NULL,
    kategorie character varying(100) NOT NULL,
    monate numeric(10,2)[] DEFAULT ARRAY[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],
    jahr integer DEFAULT EXTRACT(year FROM CURRENT_DATE),
    created_at timestamp without time zone DEFAULT now(),
    updated_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.kostenplanung OWNER TO postgres;

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

CREATE TABLE public.kredit_buchungen (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    kredit_id uuid,
    datum date NOT NULL,
    rate_betrag numeric(10,2) NOT NULL,
    zinsen numeric(10,2) DEFAULT 0,
    tilgung numeric(10,2) NOT NULL,
    restschuld_nach numeric(12,2) NOT NULL,
    created_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.kredit_buchungen OWNER TO postgres;

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

CREATE TABLE public.kredit_zahlungen (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    kredit_id uuid,
    betrag numeric(10,2) NOT NULL,
    datum date NOT NULL,
    typ character varying(50) DEFAULT 'monatsrate'::character varying NOT NULL,
    notiz text,
    created_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.kredit_zahlungen OWNER TO postgres;

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

CREATE TABLE public.kredite (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    kreditgeber character varying(255),
    person character varying(100),
    ursprungsschuld numeric(12,2) NOT NULL,
    restschuld numeric(12,2) NOT NULL,
    monatsrate numeric(10,2) NOT NULL,
    zinssatz numeric(5,2) DEFAULT 4.00,
    start_datum date NOT NULL,
    end_datum date,
    laufzeit_monate integer,
    faelligkeit_tag integer DEFAULT 1,
    status character varying(50) DEFAULT 'aktiv'::character varying,
    notizen text,
    created_at timestamp without time zone DEFAULT now(),
    updated_at timestamp without time zone DEFAULT now(),
    richtung character varying(50) DEFAULT 'ausgehend'::character varying
);


ALTER TABLE public.kredite OWNER TO postgres;

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

CREATE TABLE public.nebenkosten (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    jahr integer NOT NULL,
    wohnung character varying(100),
    mieter character varying(255),
    kaltmiete numeric(10,2),
    nebenkosten numeric(10,2),
    heizkosten numeric(10,2),
    wasser numeric(10,2),
    muell numeric(10,2),
    versicherung numeric(10,2),
    sonstiges numeric(10,2),
    created_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.nebenkosten OWNER TO postgres;

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

CREATE TABLE public.rechnungen (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    rechnung_nr character varying(50) NOT NULL,
    kunde character varying(255) NOT NULL,
    kunde_email character varying(255),
    kunde_adresse text,
    leistung text NOT NULL,
    betrag numeric(10,2) NOT NULL,
    ust_satz numeric(4,2) DEFAULT 19.00,
    datum date NOT NULL,
    faelligkeit date,
    status character varying(50) DEFAULT 'offen'::character varying,
    pdf_path character varying(500),
    created_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.rechnungen OWNER TO postgres;

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

CREATE TABLE public.stunden (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    datum date NOT NULL,
    kunde character varying(255) NOT NULL,
    beschreibung text,
    stunden numeric(10,2) NOT NULL,
    stundensatz numeric(10,2) NOT NULL,
    betrag numeric(10,2) NOT NULL,
    status character varying(50) DEFAULT 'offen'::character varying,
    created_at timestamp without time zone DEFAULT now()
);


ALTER TABLE public.stunden OWNER TO postgres;

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

CREATE TABLE public.users (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    username character varying(100) NOT NULL,
    password_hash character varying(255) NOT NULL,
    pin character varying(10),
    role character varying(50) DEFAULT 'user'::character varying,
    is_active boolean DEFAULT true,
    created_at timestamp without time zone DEFAULT now(),
    last_login timestamp without time zone
);


ALTER TABLE public.users OWNER TO postgres;

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

COPY public.belege (id, date, haendler, betrag, mwst_satz, kategorie, status, file_path, ocr_text, created_at, updated_at) FROM stdin;
\.


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

COPY public.fixe_ausgaben (id, name, kategorie, betrag, intervall, faelligkeit_tag, is_active, created_at) FROM stdin;
\.


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

COPY public.kostenplanung (id, objekt, name, kategorie, monate, jahr, created_at, updated_at) FROM stdin;
\.


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

COPY public.kredit_buchungen (id, kredit_id, datum, rate_betrag, zinsen, tilgung, restschuld_nach, created_at) FROM stdin;
43bc1001-c148-4f44-a5fa-391c675ce6e0	d7922be9-4de9-442e-a0e6-a9545faccc37	2018-01-01	0.00	0.00	0.00	34036.98	2026-04-20 13:47:08.123535
a1fb3e84-1094-4ccb-8a84-5bb4eaf2a783	d7922be9-4de9-442e-a0e6-a9545faccc37	2013-01-09	0.00	0.00	300.00	34336.98	2026-04-20 13:47:08.123535
7bb2768a-9080-4432-8dff-58c525a99b95	d7922be9-4de9-442e-a0e6-a9545faccc37	2013-01-29	0.00	0.00	500.00	34836.98	2026-04-20 13:47:08.123535
9731d799-9c68-413e-938b-08366f02f9d7	d7922be9-4de9-442e-a0e6-a9545faccc37	2013-03-13	0.00	0.00	1500.00	36336.98	2026-04-20 13:47:08.123535
f01f615c-eece-4a37-963f-41a2f7ee4e9b	d7922be9-4de9-442e-a0e6-a9545faccc37	2013-04-04	0.00	0.00	1000.00	37336.98	2026-04-20 13:47:08.123535
290a82bf-a6d0-4a1a-9f1f-b70702319c16	d7922be9-4de9-442e-a0e6-a9545faccc37	2018-01-01	0.00	0.00	25.00	37361.98	2026-04-20 13:47:08.123535
e85d8c44-fcd6-4366-8352-905784fee8b8	d7922be9-4de9-442e-a0e6-a9545faccc37	2018-01-01	7.00	0.00	7.00	37354.98	2026-04-20 13:47:08.123535
49d3ac7c-adb1-4181-a94c-3808f77deda9	d7922be9-4de9-442e-a0e6-a9545faccc37	2018-01-01	0.00	0.00	9.00	37363.98	2026-04-20 13:47:08.123535
78e3f307-58c9-4b24-a191-6e6e775229f9	d7922be9-4de9-442e-a0e6-a9545faccc37	2018-01-01	0.00	0.00	12.99	37376.97	2026-04-20 13:47:08.123535
4dbcaba6-bf75-4c99-a434-ac3e4a47310a	d7922be9-4de9-442e-a0e6-a9545faccc37	2018-01-01	0.00	0.00	120.00	37496.97	2026-04-20 13:47:08.123535
6be58485-1f84-472d-a52c-a7abec2e4dbe	d7922be9-4de9-442e-a0e6-a9545faccc37	2018-01-01	48.00	0.00	48.00	37448.97	2026-04-20 13:47:08.123535
0f79c20f-da0d-45e4-b8e9-6b819df9144d	d7922be9-4de9-442e-a0e6-a9545faccc37	2019-01-01	218.23	0.00	218.23	37230.74	2026-04-20 13:47:08.123535
e29fe4be-6d54-4db8-8fdf-93c36000ce65	d7922be9-4de9-442e-a0e6-a9545faccc37	2020-01-01	237.01	0.00	237.01	36993.73	2026-04-20 13:47:08.123535
fbc20121-23ad-47be-a9e0-9328b50ea4f9	d7922be9-4de9-442e-a0e6-a9545faccc37	2020-01-01	55.75	0.00	55.75	36937.98	2026-04-20 13:47:08.123535
53c30309-445e-44f9-a799-c3381b35b2a1	d7922be9-4de9-442e-a0e6-a9545faccc37	2020-01-01	566.89	0.00	566.89	36371.09	2026-04-20 13:47:08.123535
763a7ea5-fb2b-4de3-83ab-926bc3f2d762	d7922be9-4de9-442e-a0e6-a9545faccc37	2020-08-01	259.00	0.00	259.00	36112.09	2026-04-20 13:47:08.123535
305fee78-1cf4-4e72-9b4f-ae4b465c19f5	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-05-11	350.00	0.00	350.00	35762.09	2026-04-20 13:47:08.123535
48bb6079-6b10-45b6-9ffb-df618d83067d	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-05-17	500.00	0.00	500.00	35262.09	2026-04-20 13:47:08.123535
9e04e83a-98e0-45cc-a11f-e748ca3ca70a	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-06-09	350.00	0.00	350.00	34912.09	2026-04-20 13:47:08.123535
05af7338-cdbe-4af8-876c-bb0aaf8de316	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-07-07	350.00	0.00	350.00	34562.09	2026-04-20 13:47:08.123535
1d33dad7-64cc-4e4a-be1f-487fe5681b7b	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-08-01	350.00	0.00	350.00	34212.09	2026-04-20 13:47:08.123535
ce2bf4f2-1c47-4720-b898-5bc79a171a93	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-09-01	350.00	0.00	350.00	33862.09	2026-04-20 13:47:08.123535
8163e30a-2dbb-45b1-9f44-2692b75ec5db	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-10-01	350.00	0.00	350.00	33512.09	2026-04-20 13:47:08.123535
4b783dbb-f907-41b3-a62b-cc16d59d26ea	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-11-01	350.00	0.00	350.00	33162.09	2026-04-20 13:47:08.123535
1bf6595c-b6e4-4629-a670-3be2679c4a64	d7922be9-4de9-442e-a0e6-a9545faccc37	2021-12-01	350.00	0.00	350.00	32812.09	2026-04-20 13:47:08.123535
84db1813-9842-4baf-aca7-7f5b1c1f8d2a	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-01-01	350.00	0.00	350.00	32462.09	2026-04-20 13:47:08.123535
615011f9-3410-416e-8f21-48cf68857abe	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-02-01	350.00	0.00	350.00	32112.09	2026-04-20 13:47:08.123535
4673e09d-f492-4a4b-ae75-be6f9a6cbd85	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-03-01	350.00	0.00	350.00	31762.09	2026-04-20 13:47:08.123535
d7097374-f7d1-4128-a693-d8b96411261e	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-04-01	350.00	0.00	350.00	31412.09	2026-04-20 13:47:08.123535
42b5edec-c7ab-4c57-9a20-9ab0bb73000c	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-05-01	350.00	0.00	350.00	31062.09	2026-04-20 13:47:08.123535
17725531-f04a-401c-ba6d-3881515cefef	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-06-01	350.00	0.00	350.00	30712.09	2026-04-20 13:47:08.123535
060d5840-3397-42cb-bda7-970413d66ab4	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-07-01	350.00	0.00	350.00	30362.09	2026-04-20 13:47:08.123535
fc3f8cbf-f1e7-4602-ab2a-f9f9266735ca	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-08-01	350.00	0.00	350.00	30012.09	2026-04-20 13:47:08.123535
f797451d-3c91-4635-a920-5180587517ca	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-09-01	350.00	0.00	350.00	29662.09	2026-04-20 13:47:08.123535
2e3cb306-a858-4400-8c1d-20953966eeaa	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-10-01	350.00	0.00	350.00	29312.09	2026-04-20 13:47:08.123535
cf351c06-3777-4049-8d24-6f685d7f3823	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-11-01	350.00	0.00	350.00	28962.09	2026-04-20 13:47:08.123535
ac0ae440-ce25-4d03-8429-abd511071d4a	d7922be9-4de9-442e-a0e6-a9545faccc37	2022-12-01	350.00	0.00	350.00	28612.09	2026-04-20 13:47:08.123535
e099dee9-bd43-4f0f-b916-9b50e87a8710	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-01-01	350.00	0.00	350.00	28262.09	2026-04-20 13:47:08.123535
f90acfe7-b630-458c-aaa3-e06b929b6bc4	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-02-01	350.00	0.00	350.00	27912.09	2026-04-20 13:47:08.123535
ba0d84de-9e56-4fde-8caa-d91c38379b81	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-03-01	350.00	0.00	350.00	27562.09	2026-04-20 13:47:08.123535
ea50adce-ba28-44a6-87cc-708616b6b4bf	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-04-01	350.00	0.00	350.00	27212.09	2026-04-20 13:47:08.123535
74cf104f-572a-4d59-bc8d-0b39e64905f8	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-05-01	350.00	0.00	350.00	26862.09	2026-04-20 13:47:08.123535
f742c05a-e276-44cd-9b87-d230f4216b42	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-06-01	350.00	0.00	350.00	26512.09	2026-04-20 13:47:08.123535
ec8a0702-cab8-41b4-b643-6b88ba4ff44d	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-07-01	350.00	0.00	350.00	26162.09	2026-04-20 13:47:08.123535
38fb8bb1-d5ba-40e8-b09a-ab39d3df88cf	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-08-01	350.00	0.00	350.00	25812.09	2026-04-20 13:47:08.123535
963c2c1d-19e0-4fee-a7a5-584a02ff8d0b	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-09-01	350.00	0.00	350.00	25462.09	2026-04-20 13:47:08.123535
9341516d-cb5e-477a-9ba9-aaa528c187c8	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-10-01	350.00	0.00	350.00	25112.09	2026-04-20 13:47:08.123535
593a32b2-6c4c-49d5-89ab-67277e4f4f92	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-11-01	350.00	0.00	350.00	24762.09	2026-04-20 13:47:08.123535
6ba2b7d2-f513-46c6-b058-905a61998fc7	d7922be9-4de9-442e-a0e6-a9545faccc37	2023-12-01	350.00	0.00	350.00	24412.09	2026-04-20 13:47:08.123535
11db7f39-4ef6-4e28-b99d-d760e34f04d7	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-01-01	350.00	0.00	350.00	24062.09	2026-04-20 13:47:08.123535
7b166fb9-9790-4c79-b68e-05fde908d207	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-02-01	350.00	0.00	350.00	23712.09	2026-04-20 13:47:08.123535
ec5577e0-0700-44eb-aa92-0d286779786b	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-03-01	350.00	0.00	350.00	23362.09	2026-04-20 13:47:08.123535
f19a96b9-3fe2-4011-94c4-fe6bbe300128	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-04-01	350.00	0.00	350.00	23012.09	2026-04-20 13:47:08.123535
420dd96b-e213-4e7f-ba50-0c34fb9b9691	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-05-01	350.00	0.00	350.00	22662.09	2026-04-20 13:47:08.123535
957b02df-1bb5-4198-8278-b2147bd1f425	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-06-01	350.00	0.00	350.00	22312.09	2026-04-20 13:47:08.123535
072b406c-cad2-463f-ad0b-09affb406657	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-07-01	350.00	0.00	350.00	21962.09	2026-04-20 13:47:08.123535
884b6436-c3d5-412b-a4f0-b708b1eef2ab	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-08-01	350.00	0.00	350.00	21612.09	2026-04-20 13:47:08.123535
828af89a-20fc-49b7-8701-7f658fe44d5a	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-09-01	350.00	0.00	350.00	21262.09	2026-04-20 13:47:08.123535
73063e0a-7261-4d55-a917-65c7fa9a8b24	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-10-01	350.00	0.00	350.00	20912.09	2026-04-20 13:47:08.123535
0b910ead-5491-4226-a2da-0e5aae8d5832	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-11-01	350.00	0.00	350.00	20562.09	2026-04-20 13:47:08.123535
76cfd4b3-b7bb-434d-81ec-7af7cfe3849e	d7922be9-4de9-442e-a0e6-a9545faccc37	2024-12-01	350.00	0.00	350.00	20212.09	2026-04-20 13:47:08.123535
56c9b080-cdd3-4cea-a219-15de7589ae25	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-01-01	350.00	0.00	350.00	19862.09	2026-04-20 13:47:08.123535
4f9f66ca-7289-4fa1-9d3e-b2f6754c701b	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-02-01	350.00	0.00	350.00	19512.09	2026-04-20 13:47:08.123535
3656c644-5d99-4448-8767-8fa5a3ff5780	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-03-01	350.00	0.00	350.00	19162.09	2026-04-20 13:47:08.123535
7edc9640-8561-4834-8db4-eb2bd8ec1015	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-04-01	350.00	0.00	350.00	18812.09	2026-04-20 13:47:08.123535
db24771c-9edc-4ddd-a8e8-a268adb0f12f	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-05-01	350.00	0.00	350.00	18462.09	2026-04-20 13:47:08.123535
3d1dd219-8cbc-4723-a62e-ffc5642c3f2e	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-06-01	350.00	0.00	350.00	18112.09	2026-04-20 13:47:08.123535
61ebab31-1772-4eb3-bc4f-51251724fa88	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-07-01	350.00	0.00	350.00	17762.09	2026-04-20 13:47:08.123535
05b83939-3c3e-4bf2-ba6a-b7f2359948f6	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-08-01	350.00	0.00	350.00	17412.09	2026-04-20 13:47:08.123535
604e4ded-bdce-4f04-9641-3428556a9b14	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-09-01	350.00	0.00	350.00	17062.09	2026-04-20 13:47:08.123535
26b1ac60-b7ec-488a-9e40-0f8136b20042	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-10-01	350.00	0.00	350.00	16712.09	2026-04-20 13:47:08.123535
dffbc2a3-10b1-4128-b080-3691970d4a70	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-11-01	350.00	0.00	350.00	16362.09	2026-04-20 13:47:08.123535
b23b73b7-7d48-4c3b-8f84-6393e132afa2	d7922be9-4de9-442e-a0e6-a9545faccc37	2025-12-01	350.00	0.00	350.00	16012.09	2026-04-20 13:47:08.123535
42e7d18b-765f-42ed-a7d8-2fd7aee2a60c	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-01-01	350.00	0.00	350.00	15662.09	2026-04-20 13:47:08.123535
30b92143-971d-4091-89c1-b6b728e1f75a	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-02-01	350.00	0.00	350.00	15312.09	2026-04-20 13:47:08.123535
ac86b50b-165d-4a59-bf8d-cca4bcc21db5	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-03-01	350.00	0.00	350.00	14962.09	2026-04-20 13:47:08.123535
8c8e6f0a-a7ed-43c4-89dd-dfe6131d4e02	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-04-01	350.00	0.00	350.00	14612.09	2026-04-20 13:47:08.123535
e8c46f0d-af7f-4b5c-9603-38ba0a4cfe72	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-05-01	350.00	0.00	350.00	14262.09	2026-04-20 13:47:08.123535
94e2df0f-69bb-4cc1-b9a5-8436d09d6784	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-06-01	350.00	0.00	350.00	13912.09	2026-04-20 13:47:08.123535
4f823263-ed23-4191-83a6-72c811357d45	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-07-01	350.00	0.00	350.00	13562.09	2026-04-20 13:47:08.123535
302ce4c6-e992-43e0-af08-e8d622f3c95d	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-08-01	350.00	0.00	350.00	13212.09	2026-04-20 13:47:08.123535
04a83165-f9de-4dca-b7ab-2ebd06b7c0f5	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-09-01	350.00	0.00	350.00	12862.09	2026-04-20 13:47:08.123535
1e907ac1-df58-4b9c-be3d-08562baf8ae5	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-10-01	350.00	0.00	350.00	12512.09	2026-04-20 13:47:08.123535
b26c5e10-02f9-4ae3-84ce-fcc7f6079fec	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-11-01	350.00	0.00	350.00	12162.09	2026-04-20 13:47:08.123535
7b0c14c3-3164-4e71-a6f3-30044f49bfd8	d7922be9-4de9-442e-a0e6-a9545faccc37	2026-12-01	350.00	0.00	350.00	11812.09	2026-04-20 13:47:08.123535
dbe40c64-5305-4797-8ffe-f02c2ed02a41	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-01-01	350.00	0.00	350.00	11462.09	2026-04-20 13:47:08.123535
98c7a6b5-0d5d-4c89-86bc-7f5f2ad527f4	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-02-01	350.00	0.00	350.00	11112.09	2026-04-20 13:47:08.123535
c6dfc0cf-5b5e-4b21-8a4c-595c42b76b5c	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-03-01	350.00	0.00	350.00	10762.09	2026-04-20 13:47:08.123535
26092098-f74d-4b58-999a-899bf29756b4	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-04-01	350.00	0.00	350.00	10412.09	2026-04-20 13:47:08.123535
6995127d-02c6-45ef-a664-aeab0426844c	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-05-01	350.00	0.00	350.00	10062.09	2026-04-20 13:47:08.123535
c2606ae8-ad3c-4255-b1b2-3f2dc916c104	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-06-01	350.00	0.00	350.00	9712.09	2026-04-20 13:47:08.123535
ac71fff0-f0ab-40ae-8c3c-e5400a918be8	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-07-01	350.00	0.00	350.00	9362.09	2026-04-20 13:47:08.123535
4f271b42-36ff-49ce-b0e7-1c8d4537224d	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-08-01	350.00	0.00	350.00	9012.09	2026-04-20 13:47:08.123535
39f3e139-de46-4846-94c3-9286611866dc	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-09-01	350.00	0.00	350.00	8662.09	2026-04-20 13:47:08.123535
e23d25ba-0edd-498b-a4e2-e23f91e5d572	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-10-01	350.00	0.00	350.00	8312.09	2026-04-20 13:47:08.123535
8d3ece5e-642f-4dfa-9bbd-e333a2d7cf0b	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-11-01	350.00	0.00	350.00	7962.09	2026-04-20 13:47:08.123535
78bcb27a-3da9-4584-8840-91e195512e5a	d7922be9-4de9-442e-a0e6-a9545faccc37	2027-12-01	350.00	0.00	350.00	7612.09	2026-04-20 13:47:08.123535
a0788272-4325-44c6-8161-6e5133b6dde2	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-01-01	350.00	0.00	350.00	7262.09	2026-04-20 13:47:08.123535
600dbb30-2e5f-456f-b20c-eb5e3ee3379a	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-02-01	350.00	0.00	350.00	6912.09	2026-04-20 13:47:08.123535
38c2e627-de30-4400-978d-442f13ac2c61	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-03-01	350.00	0.00	350.00	6562.09	2026-04-20 13:47:08.123535
f4b3f4cc-1d94-4158-81d7-23ee1495ffb3	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-04-01	350.00	0.00	350.00	6212.09	2026-04-20 13:47:08.123535
9287868d-ee56-4d11-9ed7-fe8ed1a5d897	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-05-01	350.00	0.00	350.00	5862.09	2026-04-20 13:47:08.123535
0a0df005-bc83-4cc9-98b7-5a39e5fcc75a	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-06-01	350.00	0.00	350.00	5512.09	2026-04-20 13:47:08.123535
996bcd1b-0a1c-406d-b1ca-b79775abeb18	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-07-01	350.00	0.00	350.00	5162.09	2026-04-20 13:47:08.123535
8c824caa-7d01-4096-bf5e-56f08d03b57b	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-08-01	350.00	0.00	350.00	4812.09	2026-04-20 13:47:08.123535
7f07b695-c4e4-4f1b-9c2d-ddfba344c89e	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-09-01	350.00	0.00	350.00	4462.09	2026-04-20 13:47:08.123535
2587eefc-25fb-4985-ba37-92adafbf6c89	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-10-01	350.00	0.00	350.00	4112.09	2026-04-20 13:47:08.123535
1d7b1fab-5e0e-4cc0-937a-d3dc2e5a43be	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-11-01	350.00	0.00	350.00	3762.09	2026-04-20 13:47:08.123535
d6618506-cf2d-40b4-90d1-3169492b5ade	d7922be9-4de9-442e-a0e6-a9545faccc37	2028-12-01	350.00	0.00	350.00	3412.09	2026-04-20 13:47:08.123535
f2df416a-45e1-4d6a-9061-7768ae57cbda	3c957cd3-e583-4596-a122-1253dd8956ef	2023-07-01	0.00	0.00	0.00	7000.00	2026-04-20 13:47:08.123535
03aaac39-be87-4459-b8b5-097913acf48b	3c957cd3-e583-4596-a122-1253dd8956ef	2024-04-01	500.00	0.00	500.00	6500.00	2026-04-20 13:47:08.123535
c5cd477a-c6ee-41a1-8278-6effe7d17f26	3c957cd3-e583-4596-a122-1253dd8956ef	2024-05-01	500.00	0.00	500.00	6000.00	2026-04-20 13:47:08.123535
737ddc9d-c295-4a6a-b381-4ff4e03c9910	3c957cd3-e583-4596-a122-1253dd8956ef	2024-06-01	150.00	0.00	150.00	5850.00	2026-04-20 13:47:08.123535
aab1980c-a123-4fed-b07d-b1aad2b0b537	3c957cd3-e583-4596-a122-1253dd8956ef	2024-06-01	0.00	0.00	-90.00	5760.00	2026-04-20 13:47:08.123535
13409252-3d7b-430a-9977-573abe61aa3a	3c957cd3-e583-4596-a122-1253dd8956ef	2024-07-01	450.00	0.00	450.00	5310.00	2026-04-20 13:47:08.123535
40c36545-65d0-4a13-bca7-c5a5b1ef7f83	3c957cd3-e583-4596-a122-1253dd8956ef	2024-07-01	0.00	0.00	-45.00	5265.00	2026-04-20 13:47:08.123535
b6b9da94-d3c2-439f-99f7-19e30b63abf4	3c957cd3-e583-4596-a122-1253dd8956ef	2024-08-01	500.00	0.00	500.00	4765.00	2026-04-20 13:47:08.123535
f73fc3b1-fda0-4e6a-92c6-5f3de1366774	3c957cd3-e583-4596-a122-1253dd8956ef	2024-09-01	300.00	0.00	300.00	4465.00	2026-04-20 13:47:08.123535
1b188f52-7095-43d4-bcb2-1253c8419eec	3c957cd3-e583-4596-a122-1253dd8956ef	2024-10-01	300.00	0.00	300.00	4165.00	2026-04-20 13:47:08.123535
8c803f0d-7252-400f-bfb1-5e4e20118be9	3c957cd3-e583-4596-a122-1253dd8956ef	2024-10-01	0.00	0.00	-110.00	4055.00	2026-04-20 13:47:08.123535
a492a983-6916-4755-9773-e9693f7624e5	3c957cd3-e583-4596-a122-1253dd8956ef	2025-02-01	200.00	0.00	200.00	3855.00	2026-04-20 13:47:08.123535
8d856a25-c532-467f-8cad-36cf71fe4444	3c957cd3-e583-4596-a122-1253dd8956ef	2025-06-01	500.00	0.00	500.00	3355.00	2026-04-20 13:47:08.123535
4714424d-165c-43fa-877a-24b35bc6f0d8	3c957cd3-e583-4596-a122-1253dd8956ef	2025-06-01	0.00	0.00	-260.00	3095.00	2026-04-20 13:47:08.123535
\.


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

COPY public.kredit_zahlungen (id, kredit_id, betrag, datum, typ, notiz, created_at) FROM stdin;
f49c212c-843b-4d10-91ec-0edc6d3ebdc3	d7922be9-4de9-442e-a0e6-a9545faccc37	9.00	2018-01-01	auslage	Autolampen	2026-04-20 13:32:34.118508
428035cf-684e-4a34-a487-231da6f2506d	d7922be9-4de9-442e-a0e6-a9545faccc37	12.99	2018-01-01	auslage	Sp??lkasten	2026-04-20 13:32:34.118508
893b257b-e5ca-4355-a40b-bbce4011582b	d7922be9-4de9-442e-a0e6-a9545faccc37	120.00	2018-01-01	auslage	Telefon	2026-04-20 13:32:34.118508
384ceffe-248f-4a3d-969c-801cc9c4b41b	d7922be9-4de9-442e-a0e6-a9545faccc37	300.00	2013-01-09	auslage	Sofa	2026-04-20 13:30:48.268962
54f0be45-5d7e-48c4-844a-10fc2172dd88	d7922be9-4de9-442e-a0e6-a9545faccc37	500.00	2013-01-29	auslage	Auslage	2026-04-20 13:30:48.268962
d9eb6a7b-55de-42ed-99a7-6744e0706248	d7922be9-4de9-442e-a0e6-a9545faccc37	1500.00	2013-03-13	auslage	Auslage	2026-04-20 13:30:48.268962
1d9a9881-e192-4fa5-a554-e6d1c50641c4	d7922be9-4de9-442e-a0e6-a9545faccc37	48.00	2018-01-01	monatsrate	Autobezug	2026-04-20 13:32:34.118508
ced17f2c-0735-48c6-90ac-10c8f966370f	d7922be9-4de9-442e-a0e6-a9545faccc37	1000.00	2013-04-04	auslage	Auslage	2026-04-20 13:30:48.268962
b2300007-bf0d-4f91-86c7-779fee884d99	d7922be9-4de9-442e-a0e6-a9545faccc37	25.00	2018-01-01	auslage	Schuhe	2026-04-20 13:32:34.118508
3b435318-4150-4df3-9fbe-c0ae7efa5c13	d7922be9-4de9-442e-a0e6-a9545faccc37	7.00	2018-01-01	monatsrate	Schuhe	2026-04-20 13:32:34.118508
f7182b6b-6c04-4c9f-977c-ee52c04140fe	d7922be9-4de9-442e-a0e6-a9545faccc37	218.23	2019-01-01	monatsrate	Nebenkosten 2019	2026-04-20 13:32:34.118508
36742e35-a49d-4272-9ebc-3b9b95c24367	d7922be9-4de9-442e-a0e6-a9545faccc37	259.00	2020-08-01	monatsrate	Miete 08.2020	2026-04-20 13:32:34.118508
b7f0a117-db34-44ee-8237-6d2931bad314	d7922be9-4de9-442e-a0e6-a9545faccc37	55.75	2020-01-01	monatsrate	Bestellung Kabelscheune	2026-04-20 13:32:34.118508
b7472288-1c95-4ce2-b550-c2e5d655f23b	d7922be9-4de9-442e-a0e6-a9545faccc37	237.01	2020-01-01	monatsrate	Bestellung Voltking	2026-04-20 13:32:34.118508
ee9af369-ad94-4377-a86b-7462e17033a2	d7922be9-4de9-442e-a0e6-a9545faccc37	566.89	2020-01-01	monatsrate	Bestellung Kluxen	2026-04-20 13:32:34.118508
3b9ff67f-5ee5-4b92-8d2b-4b816ba67f2b	d7922be9-4de9-442e-a0e6-a9545faccc37	500.00	2021-05-17	monatsrate	??berweisung	2026-04-20 13:32:34.118508
66560a29-f7bc-4c32-b0a7-7862e9e3eb98	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-05-11	monatsrate	??berweisung	2026-04-20 13:32:34.118508
7fd097b0-14d2-4dcf-992c-57a15cc3150a	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-06-09	monatsrate	??berweisung	2026-04-20 13:32:34.118508
9f518029-d930-484d-bf9a-bbcc9ac73d0d	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-07-07	monatsrate	??berweisung	2026-04-20 13:32:34.118508
8eb8946b-0aaa-45ab-b40f-37f3df673f87	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-08-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
0db3d0d7-8c7d-44f4-ab7f-b2fa7fc2e2cd	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-09-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
78561e0c-609f-462f-a835-b57cca630672	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-10-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
bcfa2aaf-5876-4190-b662-5953574127c4	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-11-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
1a29983f-9e17-467e-bc70-b56b1053541f	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2021-12-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
c44fa280-6d5e-420d-a115-321677b26dc2	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-01-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
d626766f-8d6f-4019-9710-905dccb552a5	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-02-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
b9f8c99e-9369-4df7-8381-eb997dd759d4	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-03-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
ba12d353-03f8-4d7c-9e66-cc03fbae448b	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-04-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
17a5ce47-109a-499b-85c0-9a3ce8876493	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-05-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
70d45484-4a85-4890-9671-94cc93f819a6	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-06-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
a4d99646-efef-4fc5-8fa5-0a07e64cd8a8	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-07-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
2f8d8b92-531f-4ca3-833e-b464d39b64b8	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-08-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
773056a6-553d-410e-9c8f-a8d4247ecfb4	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-09-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
f7e26c35-0029-4fee-bec4-740f3196e3fa	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-10-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
11657de2-1c62-42d6-91dc-5d3d97cc6e91	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-11-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
55c927af-22de-4081-85a8-297fd33aba56	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2022-12-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
bf9a94ac-a5bc-4d4b-8591-fcfe66de20bc	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-01-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
a04e2ede-b0d8-4115-b952-60e806b2349c	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-02-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
e9c4cf2a-9bf4-498b-bad1-c6c94cf80f46	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-03-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
5636f756-1c43-41d8-a0ff-f23582077cd3	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-04-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
da166ec7-0e3a-494a-9d23-6a47d0e3beba	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-05-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
e0b65de3-24de-4027-96d6-5e651c606189	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-06-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
79316f94-7372-4a0c-a387-22f75ddf1ac8	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-07-01	monatsrate	Monatsrate	2026-04-20 13:32:34.118508
b394f754-519e-40b6-b010-f27837fbe599	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-08-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
990e32b6-9fe2-467b-9b01-616e4468744a	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-09-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
0877fc17-7e13-4377-8a0f-c785c4e09fc3	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-10-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
84ddfb14-d13e-41c1-9181-1eaea9a1735a	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-11-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
c2c6f0d7-6d5d-4b42-85b2-66c1e28101e8	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2023-12-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
24c3a0c0-4ccd-4d0e-947d-c265eb52d163	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-01-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
7b30dcaf-65d1-43cd-9bce-84652d6e04ae	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-02-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
1a66b499-a435-4f6d-b5fe-f00421b7631c	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-03-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
fbcf64e8-0b52-4c8e-a39a-f512fe6cd3ad	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-04-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
3805ea9e-407c-4bd8-83f4-a2c574e46370	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-05-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
80df3128-32fb-48d1-b265-4ac012ae6a22	3c957cd3-e583-4596-a122-1253dd8956ef	500.00	2024-04-01	zahlung	\N	2026-04-20 08:02:02.769132
a9b003d5-a2fa-406a-8a2b-78c799f51b98	3c957cd3-e583-4596-a122-1253dd8956ef	500.00	2024-05-01	zahlung	\N	2026-04-20 08:02:02.774871
2325d60d-515b-4f70-8607-b3916b155c01	3c957cd3-e583-4596-a122-1253dd8956ef	150.00	2024-06-01	zahlung	\N	2026-04-20 08:02:02.779427
9abf4b35-7074-4e5f-af8f-3275174e0fd7	3c957cd3-e583-4596-a122-1253dd8956ef	-90.00	2024-06-01	auslage	\N	2026-04-20 08:02:02.784168
dd712859-9084-4b04-bcd8-c5d55a89f957	3c957cd3-e583-4596-a122-1253dd8956ef	450.00	2024-07-01	zahlung	\N	2026-04-20 08:02:02.789145
52c6ab3a-b478-48c2-b272-8a0988d8c2dc	3c957cd3-e583-4596-a122-1253dd8956ef	-45.00	2024-07-01	auslage	\N	2026-04-20 08:02:02.794218
61689b39-6271-4287-b92c-23f480d2d5c3	3c957cd3-e583-4596-a122-1253dd8956ef	500.00	2024-08-01	zahlung	\N	2026-04-20 08:02:02.799185
08f6b346-78bb-47f0-be07-ac6f839a437d	3c957cd3-e583-4596-a122-1253dd8956ef	300.00	2024-09-01	zahlung	\N	2026-04-20 08:02:02.804207
d6adf5ba-ea7a-4a5c-8193-5a12b7243814	3c957cd3-e583-4596-a122-1253dd8956ef	300.00	2024-10-01	zahlung	\N	2026-04-20 08:02:02.810605
fe1677fa-2d71-4f71-9f65-3c290dce2de3	3c957cd3-e583-4596-a122-1253dd8956ef	-110.00	2024-10-01	auslage	\N	2026-04-20 08:02:02.815514
84ecb188-399c-4b38-bf24-65ecc0ef2b2f	3c957cd3-e583-4596-a122-1253dd8956ef	200.00	2025-02-01	zahlung	\N	2026-04-20 08:02:02.820325
0608f9f2-bd06-459d-a3ac-5b3fc86aadb4	3c957cd3-e583-4596-a122-1253dd8956ef	500.00	2025-06-01	zahlung	\N	2026-04-20 08:02:02.824961
ab33a8b9-069d-4bb7-adba-26086e60f6ef	3c957cd3-e583-4596-a122-1253dd8956ef	-260.00	2025-06-01	auslage	\N	2026-04-20 08:02:02.830072
3bf7f1bb-1561-49b5-89fd-b97c4ac40a34	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-06-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
16f9be26-9c77-4023-b5cc-d4a0c903b0a7	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-07-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
f5d61a0b-98c8-4048-9086-d61f94d05ff2	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-08-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
887815e2-c6fd-4b12-a6b4-42096b8e691e	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-09-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
e047dec9-5d62-4b20-9bf1-45374ec28c10	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-10-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
466adf18-f2ea-4648-beba-e81ced0f24da	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-11-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
94bf066b-7a65-4315-8f1b-1edf5b30ca2e	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2024-12-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
abb41799-102d-467c-b1cd-7e505886a774	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-01-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
81fc52d0-9c47-4d1f-a6b1-2f0c7800b528	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-02-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
272b79cf-72eb-494a-b089-e437e56baa8e	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-03-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
279371f4-5047-4ce4-a1fb-ecd400d79630	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-04-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
cc6b8fea-44a6-414e-aa18-266aeee216e4	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-05-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
0065acfa-457d-4d2c-9fd0-1c6d5f76a0a5	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-06-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
56a1ef26-96d7-4f48-a685-0c5926aea6d8	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-07-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
6d6439c3-fc22-4f66-a4ab-a266ee2d1842	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-08-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
704058f3-b0d3-497c-8dea-373faf0fa4d2	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-09-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
ef6b2a7b-08e7-4220-a903-eb94f336d3e6	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-10-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
7636693c-7255-403a-88e4-3c33e2f0f2ec	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-11-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
00a64241-8f9f-4a1b-8682-b81629f1b3f2	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2025-12-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
64ccb3e6-925d-470d-99bc-62720f7394e4	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-01-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
74f99601-06ed-42f6-995b-7c44dcb0ec19	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-02-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
2514255a-a07f-4ab7-a030-fd7e01c95c89	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-03-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
049d30fb-4e1e-4591-80fb-0b8328e3ce83	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-04-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
35f215cb-ad2d-419b-9da5-d66ae2bac327	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-05-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
9f2e2d50-c614-4936-a3ad-dee57ec1f190	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-06-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
e4cc2b8d-2a31-45fb-ae83-caa84500d1ca	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-07-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
2ea3b13e-ee2d-42fe-abfe-d99420ffea59	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-08-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
f0560dd2-aafa-4e41-8ce7-e0ddd46e4443	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-09-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
6734db67-0308-41f6-a224-af5cb931cf0a	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-10-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
f99c35b0-2c06-4c5f-a9d4-33c48a0c15b5	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-11-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
df4be6e4-9f88-4786-a87d-674c8f61270f	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2026-12-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
c9e131f5-f508-494c-9011-b5593667d9ad	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-01-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
3c9b7dc5-6411-4c68-b3d9-2b52bafabe85	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-02-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
48090620-892c-40ec-8215-91fd89d43116	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-03-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
ecff860f-3eb4-4138-a7bc-19e600f99569	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-04-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
971ea355-44b3-41e3-8a42-1f55fd8f5171	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-05-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
be5d0be1-c7a3-420b-bb55-3e631a6cdd69	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-06-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
c930f775-eed2-4b35-86ae-6e4ef77a8af3	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-07-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
90b1a2a1-a87f-4638-95f7-aed7b9207794	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-08-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
bc79acd3-164a-4a13-a2c4-18ed49934a31	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-09-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
d7ebc81b-ff1d-4e25-aba4-6a500cbbf6d8	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-10-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
c90c0d77-0f00-458e-b254-b4485f52a8f3	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-11-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
896a9d5c-9e90-4749-8d8e-68b4b7ecaf03	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2027-12-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
9ca5bf4c-dd6d-477c-b5b8-8915b4c0d5d8	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-01-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
aad7a6a5-df97-49d4-a831-e618d0e0ff3f	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-02-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
b0a5769e-1554-4692-8482-26aa74001588	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-03-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
6abf61ed-0a22-4304-8058-03db08c8ee07	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-04-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
00ae93ff-a2d4-4e20-a651-b80d1ae10d6f	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-05-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
6996b7dd-5692-488c-91fb-42bda8229679	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-06-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
55e30416-8ffb-46f8-a141-694a75fd52f4	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-07-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
77286ab0-bcb2-47d3-a943-5f4a1a6d41d7	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-08-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
1ba90cee-fcf7-42c4-a055-8b742dfcec3b	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-09-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
5bf4169c-61cc-4f9c-8bb0-063cf7756e32	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-10-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
6f468e89-8b21-4ab3-8a42-5f8b49961e81	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-11-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
020ee9b6-faa1-49fb-a0f8-c4db9cbbd844	d7922be9-4de9-442e-a0e6-a9545faccc37	350.00	2028-12-01	monatsrate	Monatsrate	2026-04-20 13:42:00.874307
\.


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

COPY public.kredite (id, name, kreditgeber, person, ursprungsschuld, restschuld, monatsrate, zinssatz, start_datum, end_datum, laufzeit_monate, faelligkeit_tag, status, notizen, created_at, updated_at, richtung) FROM stdin;
d7922be9-4de9-442e-a0e6-a9545faccc37	Kerstin Schulden	Kerstin	Kerstin	34036.98	3412.09	350.00	0.00	2018-01-01	\N	\N	1	aktiv	Importiert aus Excel - Start 01.01.2018, 0% Zinsen, Startbetrag 34.036,98 EUR	2026-04-20 13:30:48.262826	2026-04-20 13:30:48.262826	ausgehend
3c957cd3-e583-4596-a122-1253dd8956ef	Niki Schulden	Niki	Niki	7000.00	3095.00	0.00	10.00	2023-07-01	\N	\N	\N	aktiv	Importiert aus Excel (Schulden Niki.xlsx)	2026-04-20 08:02:02.750773	2026-04-20 12:27:30.254046	eingehend
\.


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

COPY public.nebenkosten (id, jahr, wohnung, mieter, kaltmiete, nebenkosten, heizkosten, wasser, muell, versicherung, sonstiges, created_at) FROM stdin;
\.


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

COPY public.rechnungen (id, rechnung_nr, kunde, kunde_email, kunde_adresse, leistung, betrag, ust_satz, datum, faelligkeit, status, pdf_path, created_at) FROM stdin;
\.


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

COPY public.stunden (id, datum, kunde, beschreibung, stunden, stundensatz, betrag, status, created_at) FROM stdin;
\.


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

COPY public.users (id, username, password_hash, pin, role, is_active, created_at, last_login) FROM stdin;
78552c19-5456-4e3a-b3c0-3534943bd1a8	admin	$2a$11$bfAf51mhJvrh7Vo4zkVNsumKNgsP/slgvG7Rt1sNRySnQ1f8Ea4e2	\N	admin	t	2026-04-11 08:09:02.367391	2026-04-20 13:29:56.046151
\.


--
-- Name: belege belege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.belege
    ADD CONSTRAINT belege_pkey PRIMARY KEY (id);


--
-- Name: fixe_ausgaben fixe_ausgaben_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fixe_ausgaben
    ADD CONSTRAINT fixe_ausgaben_pkey PRIMARY KEY (id);


--
-- Name: kostenplanung kostenplanung_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kostenplanung
    ADD CONSTRAINT kostenplanung_pkey PRIMARY KEY (id);


--
-- Name: kredit_buchungen kredit_buchungen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kredit_buchungen
    ADD CONSTRAINT kredit_buchungen_pkey PRIMARY KEY (id);


--
-- Name: kredit_zahlungen kredit_zahlungen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kredit_zahlungen
    ADD CONSTRAINT kredit_zahlungen_pkey PRIMARY KEY (id);


--
-- Name: kredite kredite_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kredite
    ADD CONSTRAINT kredite_pkey PRIMARY KEY (id);


--
-- Name: nebenkosten nebenkosten_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.nebenkosten
    ADD CONSTRAINT nebenkosten_pkey PRIMARY KEY (id);


--
-- Name: rechnungen rechnungen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rechnungen
    ADD CONSTRAINT rechnungen_pkey PRIMARY KEY (id);


--
-- Name: rechnungen rechnungen_rechnung_nr_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rechnungen
    ADD CONSTRAINT rechnungen_rechnung_nr_key UNIQUE (rechnung_nr);


--
-- Name: stunden stunden_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stunden
    ADD CONSTRAINT stunden_pkey PRIMARY KEY (id);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: users users_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_username_key UNIQUE (username);


--
-- Name: kredit_buchungen kredit_buchungen_kredit_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kredit_buchungen
    ADD CONSTRAINT kredit_buchungen_kredit_id_fkey FOREIGN KEY (kredit_id) REFERENCES public.kredite(id) ON DELETE CASCADE;


--
-- Name: kredit_zahlungen kredit_zahlungen_kredit_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kredit_zahlungen
    ADD CONSTRAINT kredit_zahlungen_kredit_id_fkey FOREIGN KEY (kredit_id) REFERENCES public.kredite(id) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--

\unrestrict QbFsNGLJ1g0UVWkDTi82fkgZRTYWIHMW3dMqopRxdOTRZ8slTWsoVZKCZWSqei1