Vorgaenge

5 rows where laufnr_ges = 200101309

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
5957 5957 18 659 659 20/06/20G abgeschrieben 200101309 200101309
22105 22105 22 657 657     200101309 200101309
23621 23621 19 604 604     200101309 200101309
24433 24433 33 606 606     200101309 200101309
26112 26112 33 608 608 04/11/56.04G Überweisung an RR 200101309 200101309

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