Vorgaenge

9 rows where laufnr_ges = 199701913

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
8305 8305 38 589 589     199701913 199701913
10301 10301 57 526 526     199701913 199701913
17701 17701 44 641 641     199701913 199701913
19304 19304 13 690 690     199701913 199701913
19392 19392 29 689 689 07/42/31G erledigt abgeschrieben 199701913 199701913
21631 21631 21 642 642     199701913 199701913
26208 26208 15 592 592 03/23/31G stehen lassen 199701913 199701913
28680 28680 37 643 643 05/42/39G stehen lassen 199701913 199701913
28739 28739 43 530 530 01/11/30.06G UEB an RR 199701913 199701913

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