spricht

10 rows where personID = 150

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

Link sprechrolleID personID pseudonymID position
596,150 596 596 Micaëla Kreißler 150 Julia Mahnkopf 47 1
610,150 610 610 Micaëla Kreißler 150   1
844,150 844 844 Micaëla Kreißler 150   1
923,150 923 923 Micaëla Kreißler 150   1
1024,150 1024 1024 Micaëla Kreißler 150   1
1153,150 1153 1153 Micaëla Kreißler 150   1
1383,150 1383 1383 Micaëla Kreißler 150   1
1643,150 1643 1643 Micaëla Kreißler 150   1
2380,150 2380 2380 Micaëla Kreißler 150   1
2964,150 2964 2964 Micaëla Kreißler 150   10

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "spricht"(
  "sprechrolleID" INTEGER NOT NULL REFERENCES "sprechrolle"("sprechrolleID") ON DELETE CASCADE ON UPDATE CASCADE,
  "personID" INTEGER NOT NULL REFERENCES "person"("personID") ON DELETE CASCADE ON UPDATE CASCADE,
  "pseudonymID" INTEGER REFERENCES "pseudonym"("pseudonymID") ON DELETE SET NULL ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  PRIMARY KEY("sprechrolleID", "personID"),
  UNIQUE("sprechrolleID", "position")
);