Vorgaenge

40 rows where siz_nr = 77

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
361 361 27 77 77 88/37/37G   198800629 198800629
1375 1375 11 77 77 88/37/37Gh   198800634 198800634
2380 2380 5 77 77 88/37/41G   198800527 198800527
2844 2844 17 77 77 88/37/41Gi   198800500 198800500
4060 4060 38 77 77 88/37/38G   198000056 198000056
4513 4513 2 77 77 88/37/41Gh   198800668 198800668
5689 5689 30 77 77 88/37/37Gg   198800632 198800632
5723 5723 16 77 77 88/37/40G   198400129 198400129
6079 6079 26 77 77 88/37/37Gf UEB an RR 198802233 198802233
6401 6401 40 77 77 88/37/41Gg   198800523 198800523
6419 6419 39 77 77 88/37/41Gf   198800519 198800519
6797 6797 33 77 77 88/37/42G   198800685 198800685
7112 7112 22 77 77 88/37/42Gd   198800675 198800675
7613 7613 9 77 77 88/37/28G   198800537 198800537
10824 10824 21 77 77 88/37/41Ge   198800667 198800667
15326 15326 10 77 77 88/37/29G   198800538 198800538
15894 15894 36 77 77 88/37/31G   198400235 198400235
16082 16082 34 77 77 88/37/42Gc   198800683 198800683
16140 16140 37 77 77 88/37/41Gd   198800521 198800521
17029 17029 14 77 77 88/37/32G   198800557 198800557
17173 17173 1 77 77 88/37/41Gc   198800522 198800522
18008 18008 4 77 77 88/37/41Gb   198800526 198800526
19199 19199 7 77 77 88/37/27G   198800514 198800514
20833 20833 23 77 77 88/37/36G   198800681 198800681
21129 21129 15 77 77 88/37/26G   198400123 198400123
22727 22727 8 77 77 88/37/34G   198800535 198800535
25687 25687 32 77 77 88/37/42Gb   198800684 198800684
26127 26127 19 77 77 88/37/40Gb   198400477 198400477
26377 26377 35 77 77 88/37/33G   198400124 198400124
26971 26971 20 77 77 88/37/40Ga   198400314 198400314
27160 27160 28 77 77 88/37/37Ge   198800630 198800630
29242 29242 3 77 77 88/37/41Ga   198800524 198800524
29581 29581 18 77 77 88/37/39G   199201548 199201548
29631 29631 13 77 77 88/37/25G   198400170 198400170
29931 29931 25 77 77 88/37/37Gd   198800628 198800628
30318 30318 31 77 77 88/37/37Gc   198800633 198800633
30399 30399 24 77 77 88/37/42Ga   198800682 198800682
30611 30611 12 77 77 88/37/37Gb   198800635 198800635
31279 31279 6 77 77 88/37/30G   199201544 199201544
33025 33025 29 77 77 88/37/37Ga   198800631 198800631

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