Vorgaenge

36 rows where siz_nr = 168

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1326 1326 24 168 168 91/20/25.7G   198802465 198802465
1548 1548 16 168 168 91/20/25.16G   198802474 198802474
2486 2486 15 168 168 91/20/28G   198801892 198801892
3219 3219 35 168 168 91/20/28Gf   198801893 198801893
3870 3870 12 168 168 91/20/28Ge   198801688 198801688
6072 6072 36 168 168 91/20/30G   198800931 198800931
6656 6656 27 168 168 91/20/25.10G   198802471 198802471
7372 7372 14 168 168 91/20/25.5G UEB an RR 198802462 198802462
10421 10421 5 168 168 91/20/23Ga   198800910 198800910
13373 13373 1 168 168 91/20/30Gb   198000042 198000042
13626 13626 19 168 168 91/20/24bG   198801385 198801385
13743 13743 18 168 168 91/20/25.13G UEB an RR 198802473 198802473
14216 14216 32 168 168 91/20/25.14   198801887 198801887
14384 14384 31 168 168 91/20/25.9G   198802470 198802470
15030 15030 4 168 168 91/20/29Ga   198400241 198400241
15641 15641 3 168 168 91/20/31G   198400448 198400448
17628 17628 10 168 168 91/20/25.15G   198802472 198802472
17749 17749 34 168 168 91/20/25.12G   198802467 198802467
19753 19753 17 168 168 91/20/24aG   198801898 198801898
21215 21215 26 168 168 91/20/25.8G   198802469 198802469
21454 21454 21 168 168 91/20/28Gd   198801884 198801884
21457 21457 2 168 168 91/20/32G   198800549 198800549
21560 21560 25 168 168 91/20/25.11G   198802468 198802468
22147 22147 7 168 168 91/20/32Gc   198800548 198800548
22269 22269 20 168 168 91/20/30Ga   198801387 198801387
23220 23220 8 168 168 91/20/32Gb   198800550 198800550
24186 24186 11 168 168 91/20/27   198801461 198801461
26009 26009 6 168 168 91/20/24cG   198801354 198801354
26290 26290 29 168 168 91/20/25.17G   198802490 198802490
28545 28545 33 168 168 91/20/25.3G   198802461 198802461
29005 29005 28 168 168 91/20/33Ga   198801927 198801927
30411 30411 13 168 168 91/20/25.2G   198802460 198802460
30683 30683 30 168 168 91/20/26   198802374 198802374
32222 32222 23 168 168 91/20/25.4G   198802463 198802463
32318 32318 9 168 168 91/20/28Gb   198801678 198801678
32992 32992 22 168 168 91/20/28Ga   198801885 198801885

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