Vorgaenge

9 rows where laufnr_ges = 198802629

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
107 107 48 376 376 97/11/11G STL an RR 198802629 198802629
838 838 1 598 598     198802629 198802629
14729 14729 1 288 288 94/c STL an RR 198802629 198802629
15443 15443 12 597 597 03/43/32Ga erledigt 198802629 198802629
16379 16379 2 199 199 92/07/28.01G UEB an RR 198802629 198802629
20359 20359 2 193 193     198802629 198802629
27985 27985 8 555 555     198802629 198802629
29405 29405 2 484 484 2000/02/05G STL an RR 198802629 198802629
32794 32794 1 554 554 02/02/14Ga UEB an BRK 198802629 198802629

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