Vorgaenge

15 rows where siz_nr = 89

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2870 2870 1 89 89 89/01/27G   198800937 198800937
3976 3976 8 89 89 89/01/23.02G   198800744 198800744
4616 4616 12 89 89 89/01/16bG   198800752 198800752
4785 4785 5 89 89 89/01/25G   198400308 198400308
5354 5354 7 89 89 89/01/24aG   198400320 198400320
5745 5745 2 89 89 89/01/28G   198800786 198800786
9212 9212 11 89 89 89/01/16aG   198800616 198800616
16838 16838 13 89 89 89/01/18G   198800607 198800607
17693 17693 15 89 89 89/01/24bG   198400162 198400162
20720 20720 10 89 89 89/01/17G   198800612 198800612
22496 22496 14 89 89 89/01/21G   198400453 198400453
24702 24702 9 89 89 89/01/19G   198400418 198400418
27648 27648 4 89 89 89/01/22G   198400297 198400297
31069 31069 6 89 89 89/01/26G   198400313 198400313
32370 32370 3 89 89 89/01/23/04G   198400479 198400479

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