Vorgaenge

15 rows where siz_nr = 230

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2526 2526 11 230 230 92/50/36aG   199201702 199201702
2901 2901 14 230 230 92/50/36cG UEB an RR 198802632 198802632
7396 7396 12 230 230 92/50/36bG   198802445 198802445
12550 12550 5 230 230 92/50/36aGf   199201708 199201708
12631 12631 3 230 230 92/50/37G   198802552 198802552
14349 14349 4 230 230 92/50/36aGe   199201712 199201712
18594 18594 9 230 230 92/50/37Gc   198802582 198802582
19626 19626 1 230 230 92/50/37Gb   198000084 198000084
23974 23974 8 230 230 92/50/37Ga   199201692 199201692
26454 26454 7 230 230 92/50/38G   199201885 199201885
27587 27587 6 230 230 92/50/36bGc   198802684 198802684
27946 27946 15 230 230 92/50/36aGb   198400418 198400418
28095 28095 13 230 230 92/50/36aGa   199201713 199201713
30504 30504 10 230 230 92/50/36bGb   199201604 199201604
31202 31202 2 230 230 92/50/36bGa   198802675 198802675

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