Vorgaenge

11 rows where laufnr_ges = 198800591

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, siz_nr

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2491 2491 53 182 182 91/38/47G   198800591 198800591
4229 4229 14 84 84     198800591 198800591
5012 5012 2 84 84     198800591 198800591
6964 6964 3 82 82 88/45/03.5G   198800591 198800591
8270 8270 7 82 82 88/45/03.1G   198800591 198800591
10600 10600 7 88 88 89/01/09G   198800591 198800591
12025 12025 8 88 88 89/01/08G   198800591 198800591
18075 18075 5 82 82 88/45/03.3G   198800591 198800591
20288 20288 4 82 82 88/45/03.4G   198800591 198800591
30076 30076 27 85 85 88/49/12G   198800591 198800591
30725 30725 6 82 82 88/45/03.2G   198800591 198800591

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");