Vorgaenge

20 rows where siz_nr = 78

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
528 528 16 78 78     198800638 198800638
1418 1418 15 78 78     198802234 198802234
2434 2434 17 78 78     198800639 198800639
2823 2823 5 78 78     198802238 198802238
4596 4596 4 78 78     198800636 198800636
5576 5576 7 78 78     198800764 198800764
6963 6963 14 78 78     198800637 198800637
7043 7043 2 78 78     198802236 198802236
7588 7588 1 78 78     199203505 199203505
8685 8685 8 78 78     198802239 198802239
10494 10494 19 78 78     198802235 198802235
10561 10561 11 78 78     198800643 198800643
16396 16396 13 78 78     198800647 198800647
24539 24539 12 78 78     198800645 198800645
26187 26187 20 78 78     198802231 198802231
29205 29205 18 78 78     198800640 198800640
29803 29803 3 78 78     198802237 198802237
30200 30200 10 78 78     198800720 198800720
30539 30539 6 78 78     198802232 198802232
30635 30635 9 78 78     198802240 198802240

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