Vorgaenge

10 rows where laufnr_ges = 199701943

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
4818 4818 43 690 690 07/42/2.44G stehen lassen 199701943 199701943
6582 6582 13 587 587 03/15/30.03G stehen lassen 199701943 199701943
7883 7883 32 729 729     199701943 199701943
11365 11365 34 586 586     199701943 199701943
14187 14187 15 637 637 05/23/17G stehen lassen 199701943 199701943
16048 16048 53 529 529     199701943 199701943
17488 17488 5 739 739 09/50/7.2G ereldigt abgeschrieben 199701943 199701943
21912 21912 9 585 585     199701943 199701943
29339 29339 17 636 636     199701943 199701943
31332 31332 8 531 531 01/17/33.3G UEB an RR 199701943 199701943

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