Vorgaenge

5 rows where laufnr_ges = 200100077

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
3504 3504 23 575 575 02/43/46G erledigt 200100077 200100077
4326 4326 31 532 532     200100077 200100077
9126 9126 25 573 573     200100077 200100077
13382 13382 19 571 571     200100077 200100077
20727 20727 31 531 531 01/17/07G UEB an PETK 200100077 200100077

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