Vorgaenge

26 rows where siz_nr = 539

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
616 616 24 539 539     200100139 200100139
1945 1945 9 539 539     199701624 199701624
3955 3955 21 539 539     199700040 199700040
4486 4486 6 539 539     200100146 200100146
6778 6778 23 539 539     200100123 200100123
8520 8520 10 539 539     200100145 200100145
10779 10779 8 539 539     199701665 199701665
11323 11323 16 539 539     199701891 199701891
11507 11507 12 539 539     200100129 200100129
12338 12338 19 539 539     200100124 200100124
14224 14224 4 539 539     200100154 200100154
14776 14776 26 539 539     200100134 200100134
14988 14988 2 539 539     200100143 200100143
18207 18207 5 539 539     200100156 200100156
18639 18639 18 539 539     199701893 199701893
21063 21063 25 539 539     200100134 200100134
21470 21470 7 539 539     200100151 200100151
22955 22955 20 539 539     199202907 199202907
23059 23059 15 539 539     200100144 200100144
23157 23157 11 539 539     200100128 200100128
27565 27565 14 539 539     200100138 200100138
28463 28463 13 539 539     200100127 200100127
29128 29128 27 539 539     200100155 200100155
29939 29939 22 539 539     200100354 200100354
30084 30084 17 539 539     199701892 199701892
30500 30500 1 539 539     200100142 200100142

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