Vorgaenge

20 rows where siz_nr = 1245

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
43451 43451 1 1245 1245     200113968 200113968
43452 43452 2 1245 1245     200113969 200113969
43453 43453 3 1245 1245     200113970 200113970
43454 43454 4 1245 1245     200113971 200113971
43455 43455 5 1245 1245     200113972 200113972
43456 43456 6 1245 1245     200113973 200113973
43457 43457 7 1245 1245     200113974 200113974
43458 43458 8 1245 1245     200113975 200113975
43459 43459 9 1245 1245     200113976 200113976
43460 43460 10 1245 1245     200113977 200113977
43494 43494 11 1245 1245     200113982 200113982
43495 43495 12 1245 1245     200113983 200113983
43496 43496 13 1245 1245     200113984 200113984
43497 43497 14 1245 1245     200113985 200113985
43498 43498 15 1245 1245     200113986 200113986
43500 43500 16 1245 1245     200113988 200113988
43521 43521 17 1245 1245     200113991 200113991
43523 43523 18 1245 1245     200113993 200113993
43524 43524 19 1245 1245     200113994 200113994
43530 43530 20 1245 1245     200114005 200114005

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