Vorgaenge

30 rows where siz_nr = 194

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1260 1260 11 194 194 92/02/15G   198801410 198801410
6289 6289 28 194 194 92/02/06G   198400242 198400242
7537 7537 27 194 194 92/02/09G   198802123 198802123
8130 8130 25 194 194 92/02/14G   198802127 198802127
9303 9303 21 194 194 92/02/13G   198802126 198802126
9679 9679 20 194 194 92/02/12G   198802125 198802125
10412 10412 14 194 194 92/02/11fG   198801675 198801675
11158 11158 6 194 194 92/02/07aG   198801655 198801655
11936 11936 1 194 194 92/02/18G   198400355 198400355
12794 12794 7 194 194 92/02/08.1G   198400516 198400516
13402 13402 19 194 194 92/02/11aG   198802001 198802001
13847 13847 29 194 194 92/02/08.2G STL an RR 198400441 198400441
14690 14690 17 194 194 92/02/19bG   198802660 198802660
15169 15169 22 194 194 92/02/05G   198802638 198802638
16607 16607 15 194 194 92/02/18Gd   198801403 198801403
16615 16615 30 194 194 92/02/18Gc   198400356 198400356
18567 18567 18 194 194 92/02/16G   198802454 198802454
19845 19845 9 194 194 92/02/11dG   198801680 198801680
20780 20780 23 194 194 92/02/03G   198802121 198802121
21926 21926 2 194 194 92/02/10G   198801872 198801872
22893 22893 26 194 194 92/02/18Gb   198800678 198800678
24190 24190 12 194 194 92/02/04G   198801871 198801871
24891 24891 4 194 194 92/02/18Ga   198000032 198000032
25029 25029 16 194 194 92/02/19aG   198802659 198802659
26319 26319 3 194 194 92/02/11eG   198400189 198400189
27628 27628 5 194 194 92/02/17G   198801777 198801777
28628 28628 24 194 194 92/02/11cG   198801715 198801715
31542 31542 13 194 194 92/02/11bG   198400409 198400409
32277 32277 8 194 194 92/02/07cG   198400407 198400407
32313 32313 10 194 194 92/02/07bG   198801682 198801682

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