Vorgaenge

22 rows where siz_nr = 236

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
508 508 1 236 236 93/06/43G   198400512 198400512
691 691 12 236 236 93/06/40dG   198802472 198802472
1874 1874 14 236 236 93/06/40aG   198802464 198802464
3436 3436 6 236 236 93/06/40aGc   199202724 199202724
4718 4718 18 236 236 93/06/41G   198400530 198400530
6664 6664 4 236 236 93/06/46G   198802577 198802577
8760 8760 13 236 236 93/06/45G   198802376 198802376
9325 9325 21 236 236 93/06/50G   199202233 199202233
9677 9677 3 236 236 93/06/44G   198400514 198400514
10682 10682 10 236 236 93/06/42.02G   198802323 198802323
11816 11816 7 236 236 93/06/40bG   199201847 199201847
12870 12870 5 236 236 93/06/40aGb   198802343 198802343
16803 16803 8 236 236 93/06/47G   198802348 198802348
18390 18390 2 236 236 93/06/48G   198802403 198802403
19733 19733 16 236 236 93/06/38G   199201750 199201750
20926 20926 9 236 236 93/06/40aGa   198802603 198802603
24973 24973 15 236 236 93/06/36G   199201739 199201739
25224 25224 17 236 236 93/06/39G   199201732 199201732
26891 26891 22 236 236 93/06/40cG   198802242 198802242
26945 26945 20 236 236 93/06/49G   198802347 198802347
27490 27490 11 236 236 93/06/42.01G   198802324 198802324
31883 31883 19 236 236 93/06/37G   199201770 199201770

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