Vorgaenge

13 rows where siz_nr = 215

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1252 1252 8 215 215 92/26/22G   198802647 198802647
4121 4121 1 215 215 92/26/27cG   198802263 198802263
4687 4687 12 215 215 92/26/20G   198802646 198802646
5518 5518 11 215 215 92/26/27aG   198802649 198802649
5676 5676 2 215 215 92/26/19bG   198802268 198802268
6073 6073 6 215 215 92/26/19aG   198802652 198802652
7136 7136 5 215 215 92/26/23G   198802651 198802651
18830 18830 4 215 215 92/26/19cG   198802280 198802280
22285 22285 7 215 215 92/26/21G   198802644 198802644
23082 23082 3 215 215 92/26/24G   198400478 198400478
26450 26450 9 215 215 92/26/26G   198802650 198802650
27281 27281 13 215 215 92/26/19dG   199201636 199201636
32843 32843 10 215 215 92/26/27bG   198400522 198400522

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