Vorgaenge

13 rows where siz_nr = 449

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
834 834 7 449 449 99/03/33G ZUA 199700883 199700883
3573 3573 9 449 449 99/03/34dG UEB an RR 199700991 199700991
5143 5143 5 449 449 99/03/30G ZUS 199700878 199700878
7123 7123 10 449 449 99/03/32G ZUA 199700879 199700879
7341 7341 2 449 449 99/03/32Gb UEB an GVK 198802245 198802245
7652 7652 4 449 449 99/03/30Ga ERL 199203427 199203427
10848 10848 11 449 449 99/03/34eG UEB an RR 199700992 199700992
13143 13143 3 449 449 99/03/33Ga ERL 199700043 199700043
14644 14644 8 449 449 99/03/34cG UEB an RR 199700990 199700990
16163 16163 13 449 449 99/03/34bG UEB an RR 199700989 199700989
16608 16608 6 449 449 99/03/31G GEW 199700948 199700948
24586 24586 1 449 449 99/03/32Ga UEB an GVK 198802232 198802232
30230 30230 12 449 449 99/03/34aG UEB an RR 199700988 199700988

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