Vorgaenge

17 rows where siz_nr = 1247

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
43378 43378 1 1247 1247     200113934 200113934
43379 43379 2 1247 1247     200113935 200113935
43380 43380 3 1247 1247     200113936 200113936
43381 43381 4 1247 1247     200113938 200113938
43411 43411 5 1247 1247     200113954 200113954
43412 43412 6 1247 1247     200113955 200113955
43442 43442 7 1247 1247     200113959 200113959
43443 43443 8 1247 1247     200113960 200113960
43444 43444 9 1247 1247     200113961 200113961
43445 43445 10 1247 1247     200113962 200113962
43446 43446 11 1247 1247     200113963 200113963
43447 43447 12 1247 1247     200113964 200113964
43448 43448 13 1247 1247     200113965 200113965
43449 43449 14 1247 1247     200113966 200113966
43450 43450 15 1247 1247     200113967 200113967
43499 43499 16 1247 1247     200113987 200113987
43501 43501 17 1247 1247     200113989 200113989

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