Vorgaenge

8 rows where laufnr_ges = 198802422

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
10854 10854 12 156 156 90/50/21.9G UEB an RR 198802422 198802422
11835 11835 50 376 376 97/11/34G STL an RR 198802422 198802422
17181 17181 47 154 154     198802422 198802422
17576 17576 19 597 597     198802422 198802422
20440 20440 18 601 601     198802422 198802422
28092 28092 16 599 599     198802422 198802422
29533 29533 8 598 598     198802422 198802422
32221 32221 24 605 605 04/02/33G erledigt 198802422 198802422

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