Vorgaenge

5 rows where laufnr_ges = 199203013

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: siz_nr

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
448 448 55 297 297 94/49/16.11G UEB an RR 199203013 199203013
5737 5737 31 294 294     199203013 199203013
7095 7095 47 372 372     199203013 199203013
15751 15751 46 372 372     199203013 199203013
29315 29315 10 374 374 97/06/37.02G ERL 199203013 199203013

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