Vorgaenge

21 rows where siz_nr = 681

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
3458 3458 7 681 681 19/07/2.7G stehen lassen 200101817 200101817
5317 5317 6 681 681     200102902 200102902
5707 5707 6 681 681     200102900 200102900
8637 8637 6 681 681     200102911 200102911
9403 9403 6 681 681     200102915 200102915
11801 11801 6 681 681     200102920 200102920
11959 11959 6 681 681     200102912 200102912
13264 13264 9 681 681 19/07/2.9G Kenntnisnahme 200102941 200102941
13928 13928 6 681 681     200102917 200102917
13980 13980 5 681 681     200102918 200102918
18060 18060 8 681 681 19/07/2.8G Kenntnisnahme 200102362 200102362
18437 18437 6 681 681     200102916 200102916
21906 21906 2 681 681     200102887 200102887
24991 24991 6 681 681     200102913 200102913
26531 26531 6 681 681     200102914 200102914
29024 29024 6 681 681     200102933 200102933
29276 29276 4 681 681 07/19/2.4G Überweisung an JSSK 200102899 200102899
30670 30670 6 681 681     200102901 200102901
30844 30844 1 681 681     200102210 200102210
31409 31409 3 681 681     200102289 200102289
33093 33093 5 681 681     200102926 200102926

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