Vorgaenge

12 rows where siz_nr = 345

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
5080 5080 12 345 345 96/11/31iG UEB an RR 199203540 199203540
8382 8382 9 345 345 96/11/31eG UEB an RR 199203536 199203536
9425 9425 11 345 345 96/11/29G ZUS 199203235 199203235
10303 10303 1 345 345 96/11/30G ERL 199202837 199202837
10694 10694 4 345 345 96/11/31fG UEB an RR 199203538 199203538
19450 19450 3 345 345 96/11/31gG UEB an RR 199203537 199203537
22539 22539 6 345 345 96/11/31bG UEB an RR 199203533 199203533
24087 24087 7 345 345 96/11/31cG UEB an RR 199203534 199203534
24095 24095 5 345 345 96/11/31hG UEB an RR 199203539 199203539
26922 26922 2 345 345 96/11/29Ga ZUS 199203236 199203236
27559 27559 10 345 345 96/11/31aG UEB an RR 199203531 199203531
28334 28334 8 345 345 96/11/31dG UEB an RR 199203535 199203535

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Vorgaenge" (
            "nummer" INTEGER,
            "siz_nr" INTEGER,
            "beschlnr" TEXT,
            "Vermerk" TEXT,
            "laufnr_ges" INTEGER,
            FOREIGN KEY ("laufnr_ges") REFERENCES "Geschaefte"("laufnr_ges") ON DELETE CASCADE,
            FOREIGN KEY ("siz_nr") REFERENCES "Sitzungen"("siz_nr") ON DELETE CASCADE
        );
CREATE INDEX idx_Vorgaenge_vermerk ON "Vorgaenge" ("Vermerk");
CREATE INDEX idx_Vorgaenge_siz_nr ON "Vorgaenge" ("siz_nr");
CREATE INDEX idx_Vorgaenge_laufnr_ges ON "Vorgaenge" ("laufnr_ges");