Vorgaenge

15 rows where siz_nr = 151

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
49 49 3 151 151 90/42/09G   198801608 198801608
3612 3612 4 151 151 90/42/13aG   198400252 198400252
4216 4216 15 151 151 90/42/04G   198801184 198801184
8428 8428 1 151 151 90/42/06G   198801138 198801138
9616 9616 7 151 151 90/42/10G   198801644 198801644
12350 12350 9 151 151 90/42/11G   198801336 198801336
12902 12902 13 151 151 90/42/07G   198801637 198801637
14162 14162 6 151 151 90/42/10Gc   198801640 198801640
15750 15750 10 151 151 90/42/08G   198801390 198801390
16158 16158 12 151 151 90/42/05G   198801373 198801373
17694 17694 8 151 151 90/42/02G   198801645 198801645
19074 19074 2 151 151 90/42/13aGa   198801582 198801582
21636 21636 14 151 151 90/42/12G   198801365 198801365
24389 24389 11 151 151 90/42/10Gb   198801632 198801632
25130 25130 5 151 151 90/42/10Ga   198801639 198801639

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