Vorgaenge

47 rows where siz_nr = 226

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
100 100 17 226 226 92/46/42G   198802427 198802427
2331 2331 44 226 226 92/46/35G   198802394 198802394
3688 3688 5 226 226 92/46/23G   198802289 198802289
3869 3869 12 226 226 92/46/28G   199201771 199201771
4391 4391 1 226 226 92/46/39G   198802308 198802308
5125 5125 16 226 226 92/46/31G   198400521 198400521
5379 5379 41 226 226 92/46/28Gi   199201777 199201777
5741 5741 7 226 226 92/46/36G STL an RR 198000080 198000080
7296 7296 31 226 226 92/46/28Gh   199201775 199201775
7686 7686 9 226 226 92/46/28Gg   199201776 199201776
7930 7930 22 226 226 92/46/16G   198802454 198802454
8033 8033 3 226 226 92/46/29G   198802306 198802306
8194 8194 18 226 226 92/46/13.01G   198802431 198802431
8881 8881 13 226 226 92/46/28Gf   199201707 199201707
9020 9020 30 226 226 92/46/22G   199201679 199201679
11239 11239 27 226 226 92/46/27.01G   199202398 199202398
11481 11481 43 226 226 92/46/13.02G   198802443 198802443
11845 11845 36 226 226 92/46/27.08G   199202312 199202312
12326 12326 46 226 226 92/46/28Ge   199201779 199201779
12413 12413 14 226 226 92/46/34G   198400421 198400421
13151 13151 33 226 226 92/46/21G   199201673 199201673
13728 13728 45 226 226 92/46/27.07G   199202541 199202541
15034 15034 34 226 226 92/46/18G   199201681 199201681
15071 15071 8 226 226 92/46/28Gd   199201773 199201773
15217 15217 21 226 226 92/46/32G   198000104 198000104
15412 15412 23 226 226 92/46/27.04G   199202705 199202705
17778 17778 29 226 226 92/46/13G   199201767 199201767
18945 18945 6 226 226 92/46/26G   198802276 198802276
19399 19399 47 226 226 92/46/25G   198802235 198802235
20189 20189 37 226 226 92/46/30G   198802340 198802340
20608 20608 26 226 226 92/46/27.02G   199202151 199202151
21917 21917 35 226 226 92/46/19G   199201680 199201680
23884 23884 10 226 226 92/46/28Gc   199201772 199201772
26091 26091 40 226 226 92/46/27.03G   199202704 199202704
26824 26824 25 226 226 92/46/27.06G UEB an RR 199202707 199202707
26995 26995 2 226 226 92/46/37G   198400453 198400453
27303 27303 20 226 226 92/46/41G   198802325 198802325
28843 28843 38 226 226 92/46/15G   199201656 199201656
29365 29365 19 226 226 92/46/20G   198802692 198802692
30196 30196 39 226 226 92/46/17G   199202723 199202723
30721 30721 32 226 226 92/46/28Gb   199201774 199201774
30722 30722 11 226 226 92/46/28Ga   199201706 199201706
31244 31244 28 226 226 92/46/14G   199201653 199201653
32056 32056 24 226 226 92/46/27.05G   199202706 199202706
32209 32209 4 226 226 92/46/40G   198400437 198400437
32276 32276 15 226 226 92/46/24G   198802389 198802389
32726 32726 42 226 226 92/46/33G   198400426 198400426

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