Vorgaenge

18 rows where siz_nr = 101

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2891 2891 14 101 101 89/16/20dG   198801084 198801084
4265 4265 13 101 101 89/16/18aG   198801089 198801089
5813 5813 6 101 101 89/16/19.2G   198802264 198802264
7864 7864 5 101 101 89/16/19.1G   198801022 198801022
10432 10432 10 101 101 89/16/20cG   198801064 198801064
15088 15088 8 101 101 89/16/19.4G UEB an RR 198802265 198802265
16827 16827 3 101 101 89/16/19.11G   198802261 198802261
18604 18604 9 101 101 89/16/19.5G   198802266 198802266
19377 19377 11 101 101 89/16/20aG   198801086 198801086
21894 21894 2 101 101 89/16/19.7G   198802259 198802259
22779 22779 4 101 101 89/16/19.12G   198802262 198802262
24579 24579 16 101 101 89/17/19.6.G UEB an RR 198802267 198802267
25567 25567 17 101 101 89/16/20bG   198801085 198801085
25820 25820 18 101 101 89/16/19.10G   198801016 198801016
28470 28470 1 101 101 89/16/19.8G   198802260 198802260
30828 30828 7 101 101 89/16/19.3G   198801023 198801023
31540 31540 15 101 101 89/16/19.9G   198801015 198801015
31767 31767 12 101 101 89/16/18G   198801088 198801088

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