spricht

16 rows where personID = 37

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
78,37 78 78 Marianne Kehlau 37 Marianne Wolters 12 1
100,37 100 100 Marianne Kehlau 37   1
245,37 245 245 Marianne Kehlau 37   1
268,37 268 268 Marianne Kehlau 37   1
425,37 425 425 Marianne Kehlau 37   1
500,37 500 500 Marianne Kehlau 37   1
547,37 547 547 Marianne Kehlau 37   1
665,37 665 665 Marianne Kehlau 37   1
855,37 855 855 Marianne Kehlau 37   1
947,37 947 947 Marianne Kehlau 37   1
970,37 970 970 Marianne Kehlau 37   1
1005,37 1005 1005 Marianne Kehlau 37   1
1150,37 1150 1150 Marianne Kehlau 37   1
1239,37 1239 1239 Marianne Kehlau 37   1
1294,37 1294 1294 Marianne Kehlau 37   1
1345,37 1345 1345 Marianne Kehlau 37   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")
);