Vorgaenge

14 rows where siz_nr = 312

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
4614 4614 11 312 312 95/17/41G   199202476 199202476
4932 4932 5 312 312 95/17/39G   199202336 199202336
5970 5970 9 312 312 95/17/45dG UEB an RR 199203120 199203120
6621 6621 14 312 312 95/17/45bG UEB an RR 199203118 199203118
8803 8803 3 312 312 95/17/42G   199202436 199202436
9101 9101 2 312 312 95/17/40G   199202484 199202484
13694 13694 4 312 312 95/17/43G   199201628 199201628
15227 15227 13 312 312 95/17/39Gb   198802258 198802258
17603 17603 7 312 312 95/17/40Ga   199202483 199202483
26662 26662 8 312 312 95/17/45cG UEB an RR 199203119 199203119
27436 27436 10 312 312 95/17/45eG   199202632 199202632
27517 27517 6 312 312 95/17/45aG UEB an RR 199203117 199203117
27713 27713 12 312 312 95/17/44G   199202469 199202469
29720 29720 1 312 312 95/17/39Ga   198802257 198802257

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