Vorgaenge

24 rows where siz_nr = 123

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
586 586 6 123 123 89/51/6.7G   198801215 198801215
2425 2425 12 123 123 89/51/6.12G   198801222 198801222
2910 2910 16 123 123 89/51/2G   198800888 198800888
4552 4552 14 123 123 89/51/6.14G   198801224 198801224
5160 5160 24 123 123 89/51/6.4G   198801204 198801204
5235 5235 9 123 123 89/51/6.10G   198801219 198801219
6774 6774 15 123 123 89/51/5bG   198800906 198800906
6818 6818 19 123 123 89/50/   198800829 198800829
6835 6835 4 123 123 89/51/6.6G   198801208 198801208
6980 6980 17 123 123 89/51/4.G   198800890 198800890
7146 7146 21 123 123 89/51/8.G   198400375 198400375
10154 10154 1 123 123 89/51/6.2G   198801200 198801200
11147 11147 10 123 123 89/51/6.11G   198801221 198801221
11446 11446 7 123 123 89/51/6.9G   198801217 198801217
12182 12182 23 123 123 89/51/5.aG   198801228 198801228
19731 19731 8 123 123 89/51/6.8G   198801218 198801218
21681 21681 11 123 123 89/51/6.1G   198801199 198801199
22038 22038 2 123 123 89/51/9.G   198400366 198400366
22063 22063 20 123 123 89/51/3.1G   198800892 198800892
23572 23572 18 123 123 89/51/7G   198800665 198800665
25667 25667 5 123 123 89/51/1G   198800884 198800884
25809 25809 13 123 123 89/51/6.13G   198801223 198801223
27808 27808 3 123 123 89/51/6.5G   198801205 198801205
29888 29888 22 123 123 89/51/6.3G   198801202 198801202

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