spricht

13 rows where personID = 182

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
689,182 689 689 Juliane Szalay 182   1
702,182 702 702 Juliane Szalay 182   1
716,182 716 716 Juliane Szalay 182   1
729,182 729 729 Juliane Szalay 182   1
830,182 830 830 Juliane Szalay 182   1
905,182 905 905 Juliane Szalay 182   1
967,182 967 967 Juliane Szalay 182   1
1066,182 1066 1066 Juliane Szalay 182   1
2199,182 2199 2199 Juliane Szalay 182   1
2345,182 2345 2345 Juliane Szalay 182   1
2776,182 2776 2776 Juliane Szalay 182   1
3122,182 3122 3122 Juliane Szalay 182   1
5014,182 5014 5014 Juliane Szalay 182   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")
);