spricht

23 rows where personID = 108

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
454,108 454 454 Douglas Welbat 108   1
464,108 464 464 Douglas Welbat 108   1
535,108 535 535 Douglas Welbat 108   1
635,108 635 635 Douglas Welbat 108   1
694,108 694 694 Douglas Welbat 108   1
718,108 718 718 Douglas Welbat 108   1
738,108 738 738 Douglas Welbat 108   1
857,108 857 857 Douglas Welbat 108   1
1232,108 1232 1232 Douglas Welbat 108   1
1486,108 1486 1486 Douglas Welbat 108   1
1723,108 1723 1723 Douglas Welbat 108   1
1948,108 1948 1948 Douglas Welbat 108   1
2439,108 2439 2439 Douglas Welbat 108   1
2832,108 2832 2832 Douglas Welbat 108   1
3115,108 3115 3115 Douglas Welbat 108   1
3282,108 3282 3282 Douglas Welbat 108   1
3433,108 3433 3433 Douglas Welbat 108   1
3587,108 3587 3587 Douglas Welbat 108   1
3606,108 3606 3606 Douglas Welbat 108   1
3888,108 3888 3888 Douglas Welbat 108   1
3897,108 3897 3897 Douglas Welbat 108   1
4728,108 4728 4728 Douglas Welbat 108   1
5040,108 5040 5040 Douglas Welbat 108   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")
);