Vorgaenge

20 rows where siz_nr = 476

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
945 945 9 476 476 99/45/17G ZUA 199203324 199203324
3439 3439 15 476 476 99/45/20dG UEB an RR 199701390 199701390
6068 6068 12 476 476 99/45/16G ERL 199202963 199202963
6226 6226 20 476 476 99/45/17Gf STL an RPLK 198802462 198802462
9087 9087 5 476 476 99/45/17Ge ZUS 199202051 199202051
10563 10563 17 476 476 99/45/20fG UEB an RR 199701392 199701392
11388 11388 8 476 476 99/45/18G KTS 199700757 199700757
14030 14030 19 476 476 99/45/20cG UEB an RR 199701389 199701389
16308 16308 2 476 476 99/45/17Gd STL an RPLK 199203308 199203308
19254 19254 6 476 476 99/45/17Gc STL an RPLK 199202804 199202804
19708 19708 14 476 476 99/45/20bG UEB an RR 199701388 199701388
21811 21811 16 476 476 99/45/20eG UEB an RR 199701391 199701391
22439 22439 11 476 476 99/45/16Gd ZUA 199701293 199701293
25644 25644 3 476 476 99/45/16Gc ERL 199202514 199202514
26435 26435 4 476 476 99/45/17Gb STL an RPLK 198802423 198802423
26526 26526 13 476 476 99/45/20aG UEB an RR 199701387 199701387
26882 26882 7 476 476 99/45/16Gb ERL 199700250 199700250
27437 27437 18 476 476 99/45/17Ga STL an RPLK 199203066 199203066
27909 27909 1 476 476 99/45/16Ga ERL 198802244 198802244
29687 29687 10 476 476 99/45/19G ZUA 199701329 199701329

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