Vorgaenge

19 rows where siz_nr = 658

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
7708 7708 6 658 658 19/06/2.6G stehen lassen 199203577 199203577
7792 7792 10 658 658     200102342 200102342
9422 9422 1 658 658     200102135 200102135
10835 10835 5 658 658     200102415 200102415
10870 10870 5 658 658     200102427 200102427
11027 11027 14 658 658 19/06/2.14g Kenntnisnahme 200101918 200101918
11204 11204 5 658 658     200102428 200102428
12086 12086 5 658 658     200102413 200102413
15577 15577 12 658 658     200101388 200101388
15980 15980 5 658 658     200102429 200102429
16180 16180 4 658 658 06/19/2.4G Überweisung an FKom 200102411 200102411
17151 17151 2 658 658     200101447 200101447
19311 19311 7 658 658 19/06/2.7G stehen lassen 200101433 200101433
20677 20677 8 658 658 19/06/2.8G Kenntnisnahme 200102418 200102418
21319 21319 11 658 658     200101435 200101435
24996 24996 13 658 658     200101515 200101515
27090 27090 3 658 658     200102400 200102400
27730 27730 5 658 658     200102414 200102414
30439 30439 9 658 658 19/06/2.9G Kenntnisnahme 200102430 200102430

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