Vorgaenge
6 rows where laufnr_ges = 200101736
This data as json, copyable, CSV (advanced)
Suggested facets: siz_nr, Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
1352 | 1352 | 25 | 642 642 | 05/36/02.25G | Überweisung an BKK | 200101736 200101736 |
1765 | 1765 | 10 | 631 631 | 200101736 200101736 | ||
2680 | 2680 | 20 | 631 631 | 200101736 200101736 | ||
2925 | 2925 | 2 | 645 645 | 05/45/05G | Zustimmung | 200101736 200101736 |
5503 | 5503 | 4 | 632 632 | 05/10/05G | Zustimmung | 200101736 200101736 |
23476 | 23476 | 16 | 625 625 | 04/50/09G | Überweisung an BKK | 200101736 200101736 |
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");