Vorgaenge

14 rows where siz_nr = 452

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
733 733 14 452 452 99/06/30G ERL 199203580 199203580
1055 1055 1 452 452 99/06/32.02G ERL 198400499 198400499
2094 2094 11 452 452 99/06/32.05G ERL 198802270 198802270
4485 4485 13 452 452 99/06/35G ERL 199203425 199203425
4564 4564 2 452 452 99/06/32.03G STL an RR 198400500 198400500
6207 6207 3 452 452 99/06/32.04G ERL 198400501 198400501
6811 6811 9 452 452 99/06/29G UEB an STEK 199700951 199700951
8129 8129 4 452 452 99/06/31G ERL 198802318 198802318
17368 17368 7 452 452 99/06/32.01G ERL 198400498 198400498
17391 17391 8 452 452 99/06/37G UEB an RR 199701032 199701032
19921 19921 6 452 452 99/06/34G ERL 199203085 199203085
24997 24997 12 452 452 99/06/33G ERL 199203532 199203532
26443 26443 10 452 452 99/06/29Ga UEB an STEK 199700629 199700629
30358 30358 5 452 452 99/06/36G ERL 199203809 199203809

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