Vorgaenge

11 rows where laufnr_ges = 200112659

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
41092 41092 11 1173 1173     200112659 200112659
41240 41240 8 1176 1176     200112659 200112659
41378 41378 12 1179 1179     200112659 200112659
41472 41472 10 1182 1182     200112659 200112659
41720 41720 13 1190 1190     200112659 200112659
42215 42215 11 1208 1208     200112659 200112659
42562 42562 13 1214 1214     200112659 200112659
42687 42687 17 1218 1218     200112659 200112659
42848 42848 21 1222 1222     200112659 200112659
43014 43014 18 1228 1228     200112659 200112659
43325 43325 7 1236 1236     200112659 200112659

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