Vorgaenge

44 rows where siz_nr = 86

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
419 419 30 86 86 88/49/49G   198800773 198800773
797 797 18 86 86 88/49/44.12G   198800735 198800735
1212 1212 13 86 86 88/49/47.01G   198800690 198800690
1838 1838 20 86 86 88/49/48.80   198800741 198800741
3571 3571 10 86 86 88/49/50G   198800601 198800601
4145 4145 19 86 86 88/49/48.79G   198800740 198800740
4979 4979 42 86 86 88/49/44.06G   198800719 198800719
5685 5685 6 86 86 88/49/36G   198400214 198400214
6337 6337 21 86 86 88/49/28G   198000047 198000047
8966 8966 32 86 86 88/49/24.01G   198802222 198802222
9494 9494 7 86 86 88/49/37G   198400217 198400217
10321 10321 44 86 86 88/49/45.01G   198800512 198800512
10542 10542 27 86 86 88/49/23G   198400131 198400131
11003 11003 29 86 86 88/49/24.03G   198400257 198400257
11450 11450 38 86 86 88/49/44.09G   198800730 198800730
12206 12206 28 86 86 88/49/44.07G   198800728 198800728
12288 12288 33 86 86 88/49/24.02G   198000049 198000049
13007 13007 9 86 86 88/49/30G   198400219 198400219
13828 13828 12 86 86 88/49/26G   198800644 198800644
15122 15122 40 86 86 88/49/49Ga   198800774 198800774
16740 16740 37 86 86 88/49/25G   198400288 198400288
17520 17520 5 86 86 88/49/31G   198800576 198800576
17737 17737 35 86 86 88/49/48.73G   198800733 198800733
17896 17896 36 86 86 88/49/48.78G   198800739 198800739
18816 18816 34 86 86 88/49/43G   198000043 198000043
19885 19885 17 86 86 88/49/48.74   198800734 198800734
20163 20163 1 86 86 88/49/35.01G   198400450 198400450
20422 20422 22 86 86 88/49/44.03G UEB an RR 198802245 198802245
20646 20646 39 86 86 88/49/46G   198400319 198400319
22356 22356 25 86 86 88/49/44.10G   198800721 198800721
22949 22949 16 86 86 88/49/29G   198400316 198400316
24459 24459 24 86 86 88/49/44.01G   198800718 198800718
25060 25060 31 86 86 88/49/27G   199201537 199201537
25076 25076 3 86 86 88/49/44.05G   198800715 198800715
25590 25590 11 86 86 88/49/48.87G   198800758 198800758
25650 25650 8 86 86 88/49/30Ga   198000040 198000040
25905 25905 15 86 86 88/49/44.11G   198800731 198800731
26420 26420 4 86 86 88/49/44.04G UEB an RR 198802244 198802244
29062 29062 23 86 86 88/49/44.02G   198800716 198800716
29456 29456 41 86 86 88/49/48.89G   198800760 198800760
30103 30103 14 86 86 88/49/44.08G   198800729 198800729
32331 32331 43 86 86 88/49/35.02G   199201543 199201543
32477 32477 26 86 86 88/49/45.02G   198400236 198400236
32545 32545 2 86 86 88/49/32G   198800776 198800776

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