Vorgaenge

14 rows where siz_nr = 242

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
4220 4220 4 242 242 93/16/30.06G   199202762 199202762
4595 4595 6 242 242 93/16/31G   199201808 199201808
7278 7278 9 242 242 93/16/31Gd   199201807 199201807
9356 9356 2 242 242 93/16/33G   198400419 198400419
13219 13219 13 242 242 93/16/33Gc   198000088 198000088
13363 13363 11 242 242 93/16/33Gb   198802696 198802696
16633 16633 14 242 242 93/16/32G ZUS 199201801 199201801
20085 20085 3 242 242 93/16/31Gc   199201792 199201792
20453 20453 7 242 242 93/16/31Gb   199201811 199201811
24921 24921 1 242 242 93/16/33Ga   198000089 198000089
27734 27734 8 242 242 93/16/31Ga   199201809 199201809
30199 30199 12 242 242 93/16/34G   199201793 199201793
32207 32207 5 242 242 93/16/30.08G   199202638 199202638
32630 32630 10 242 242 93/16/35G   199201919 199201919

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