spricht

21 rows where personID = 71

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
213,71 213 213 Jürgen Thormann 71   1
250,71 250 250 Jürgen Thormann 71   1
285,71 285 285 Jürgen Thormann 71 Tom Barrows 27 1
356,71 356 356 Jürgen Thormann 71   1
480,71 480 480 Jürgen Thormann 71   1
553,71 553 553 Jürgen Thormann 71   1
624,71 624 624 Jürgen Thormann 71   1
1266,71 1266 1266 Jürgen Thormann 71   1
1485,71 1485 1485 Jürgen Thormann 71   1
1595,71 1595 1595 Jürgen Thormann 71   1
1607,71 1607 1607 Jürgen Thormann 71   1
1954,71 1954 1954 Jürgen Thormann 71   1
1998,71 1998 1998 Jürgen Thormann 71   1
2219,71 2219 2219 Jürgen Thormann 71   1
2663,71 2663 2663 Jürgen Thormann 71   1
2788,71 2788 2788 Jürgen Thormann 71   1
2900,71 2900 2900 Jürgen Thormann 71   1
3246,71 3246 3246 Jürgen Thormann 71   1
3401,71 3401 3401 Jürgen Thormann 71   1
3630,71 3630 3630 Jürgen Thormann 71   1
4456,71 4456 4456 Jürgen Thormann 71   1

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