Vorgaenge

15 rows where siz_nr = 540

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
3020 3020 7 540 540 01/26/23G ABL 199701884 199701884
5935 5935 9 540 540 01/26/24G ABL 199701886 199701886
6383 6383 5 540 540 01/26/16G ZUS 200100113 200100113
6670 6670 2 540 540 01/26/19G ABL 199701893 199701893
10551 10551 15 540 540 01/26/18G ZUS 199701882 199701882
17844 17844 10 540 540 01/26/21G ABL 199701887 199701887
20959 20959 14 540 540 01/26/19Gb ABL 199701892 199701892
23986 23986 4 540 540 01/26/26G ERL 199701952 199701952
24140 24140 13 540 540 01/26/19Ga ABL 199701891 199701891
26394 26394 6 540 540 01/26/17G ERL 199701883 199701883
27242 27242 1 540 540 01/26/25G ZUS 200100139 200100139
29283 29283 11 540 540 01/26/20G ABL 199701889 199701889
29383 29383 3 540 540 01/26/20Ga ABL 199701888 199701888
30442 30442 8 540 540 01/26/23Ga ABL 199701885 199701885
31852 31852 12 540 540 01/26/22G ABL 199701890 199701890

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