OpenClaw
680 lines
93 KiB
Plaintext
680 lines
93 KiB
Plaintext
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
|
|
|