Vorgaenge

12 rows where laufnr_ges = 199203153

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, siz_nr

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
3882 3882 17 687 687     199203153 199203153
5106 5106 14 687 687     199203153 199203153
14531 14531 49 462 462 99/23/27G STL an RR 199203153 199203153
16285 16285 44 327 327 95/42/35.01G UEB an RR 199203153 199203153
16798 16798 17 688 688 07/38/20G erledigt abgeschrieben 199203153 199203153
18436 18436 15 565 565 02/15/32G stehen lassen 199203153 199203153
20206 20206 60 322 322     199203153 199203153
22037 22037 12 615 615     199203153 199203153
25772 25772 26 619 619     199203153 199203153
28631 28631 22 616 616     199203153 199203153
30018 30018 23 612 612     199203153 199203153
32195 32195 23 621 621 04/43/40G Überweisung an JSSK 199203153 199203153

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