spricht

11 rows where personID = 166

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
632,166 632 632 Gosta Liptow 166   1
1765,166 1765 1765 Gosta Liptow 166   1
1776,166 1776 1776 Gosta Liptow 166   1
2108,166 2108 2108 Gosta Liptow 166   1
2217,166 2217 2217 Gosta Liptow 166   1
2452,166 2452 2452 Gosta Liptow 166   1
2523,166 2523 2523 Gosta Liptow 166   1
2552,166 2552 2552 Gosta Liptow 166   1
2579,166 2579 2579 Gosta Liptow 166   1
2833,166 2833 2833 Gosta Liptow 166   1
2947,166 2947 2947 Gosta Liptow 166   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")
);