Vorgaenge
4 rows where laufnr_ges = 200109902
This data as json, copyable, CSV (advanced)
Suggested facets: Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
36485 | 36485 | 43 | 1046 1046 | 19/47/18.41G | Überweisung an RR | 200109902 200109902 |
38954 | 38954 | 22 | 1115 1115 | 21/50/2.50G | stehen lassen | 200109902 200109902 |
40552 | 40552 | 8 | 1159 1159 | 23/11/2.31.2G | stehen lassen | 200109902 200109902 |
43302 | 43302 | 9 | 1237 1237 | 25/23/02/27.1G | stehen lassen Frist: 04.06.2027 | 200109902 200109902 |
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");