Vorgaenge

22 rows where siz_nr = 636

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
3186 3186 12 636 636     200101924 200101924
4978 4978 4 636 636     200101905 200101905
6663 6663 8 636 636 05/19/02.09G Überweisung an UVEK 200101897 200101897
7469 7469 1 636 636     200101623 200101623
8885 8885 16 636 636     200101934 200101934
9218 9218 11 636 636 05/19/02.12G Überweisung an PetKo 200101931 200101931
11856 11856 18 636 636 05/19/02.19G stehen lassen 199701497 199701497
12061 12061 6 636 636 05/19/02.07G Überweisung an BRK 200101903 200101903
13046 13046 13 636 636     200101639 200101639
13409 13409 10 636 636 05/19/02.11G Überweisung an GSK 200101928 200101928
13725 13725 3 636 636     200101731 200101731
13832 13832 9 636 636 05/19/02.10G Überweisung an JSSK 200101929 200101929
14902 14902 12 636 636     200101925 200101925
15870 15870 15 636 636     200101935 200101935
17889 17889 12 636 636     200101923 200101923
19652 19652 14 636 636     200100916 200100916
20569 20569 5 636 636 05/19/02.06G Überweisung an BRK 200101904 200101904
21500 21500 2 636 636     200101781 200101781
27588 27588 12 636 636     200101926 200101926
29339 29339 17 636 636     199701943 199701943
29897 29897 19 636 636 05/19/02.20G stehen lassen 199700121 199700121
30178 30178 7 636 636 05/19/02.08G Überweisung an BRK 200101919 200101919

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