Vorgaenge

15 rows where siz_nr = 212

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
65 65 13 212 212 92/23/41G   198400446 198400446
283 283 12 212 212 92/23/47bG   199201635 199201635
428 428 6 212 212 92/23/43G   198801130 198801130
1867 1867 9 212 212 92/23/35G   198802160 198802160
3185 3185 5 212 212 92/23/45G   198400374 198400374
3387 3387 3 212 212 92/23/38G   198400163 198400163
10718 10718 7 212 212 92/23/34G   198802147 198802147
12412 12412 1 212 212 92/23/37G   198801022 198801022
14273 14273 11 212 212 92/23/47aG   199201634 199201634
16470 16470 14 212 212 92/23/40.1G   198800686 198800686
27300 27300 10 212 212 92/23/39G   198801447 198801447
29196 29196 15 212 212 92/23/46G   198400216 198400216
31848 31848 8 212 212 92/23/36G   198802159 198802159
31981 31981 2 212 212 92/23/40.2G   198400412 198400412
32063 32063 4 212 212 92/23/42G   198800551 198800551

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