Vorgaenge

28 rows where siz_nr = 536

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1208 1208 5 536 536     200100133 200100133
2569 2569 9 536 536     200100113 200100113
2946 2946 7 536 536     200100147 200100147
3148 3148 14 536 536     200100122 200100122
3866 3866 25 536 536     199701623 199701623
5482 5482 1 536 536     200100131 200100131
6619 6619 28 536 536     200100115 200100115
6906 6906 23 536 536     199700156 199700156
8291 8291 3 536 536     200100132 200100132
8738 8738 13 536 536     200100120 200100120
8794 8794 22 536 536     200100119 200100119
9591 9591 21 536 536     200100116 200100116
11271 11271 20 536 536     200100114 200100114
12342 12342 26 536 536     200100092 200100092
14226 14226 8 536 536     199701756 199701756
14626 14626 27 536 536     200100099 200100099
15357 15357 11 536 536     200100117 200100117
21594 21594 16 536 536     200100130 200100130
21719 21719 2 536 536     200100091 200100091
24266 24266 4 536 536     200100133 200100133
24794 24794 15 536 536     200100126 200100126
26004 26004 17 536 536     200100093 200100093
26570 26570 6 536 536     200100148 200100148
28123 28123 18 536 536     200100100 200100100
28541 28541 29 536 536     200100132 200100132
30032 30032 12 536 536     200100118 200100118
31432 31432 24 536 536     200100121 200100121
31536 31536 10 536 536     200100125 200100125

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