Vorgaenge
5 rows where laufnr_ges = 200105569
This data as json, copyable, CSV (advanced)
Suggested facets: Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
4496 | 4496 | 11 | 888 888 | 14/50/2.26G | stehen lassen | 200105569 200105569 |
22032 | 22032 | 20 | 824 824 | 12/50/14.9G | Überweisung an RR | 200105569 200105569 |
33526 | 33526 | 24 | 947 947 | 16/42/2.52G | stehen lassen | 200105569 200105569 |
35638 | 35638 | 23 | 1019 1019 | 19/2/2.51G | stehen lassen | 200105569 200105569 |
37975 | 37975 | 25 | 1092 1092 | 12/21/31G | erledigt abgeschrieben | 200105569 200105569 |
Advanced export
JSON shape: default, array, newline-delimited
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");