Vorgaenge

11 rows where laufnr_ges = 198802256

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
3198 3198 18 521 521     198802256 198802256
3910 3910 39 522 522 01/02/05cG STL an RR 198802256 198802256
9431 9431 17 574 574 02/43/12G Überweisung an JSSK 198802256 198802256
11611 11611 5 590 590 03/20/19G erledigt 198802256 198802256
14925 14925 5 239 239 93/10/57.06G STL an RR 198802256 198802256
16529 16529 65 93 93     198802256 198802256
20886 20886 4 371 371 97/02/21Gd STL an RR 198802256 198802256
23003 23003 3 121 121 89/50/07.9G STL an RR 198802256 198802256
28927 28927 5 319 319 95/26/19Ga UEB an STPO 198802256 198802256
29332 29332 30 453 453 99/10/17G STL an RR 198802256 198802256
30496 30496 16 98 98 89/10/19.02G   198802256 198802256

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