spricht

34 rows where personID = 552

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1907,552 1907 1907 Tim Kreuer 552   1
2154,552 2154 2154 Tim Kreuer 552   1
2438,552 2438 2438 Tim Kreuer 552   1
2670,552 2670 2670 Tim Kreuer 552   1
2708,552 2708 2708 Tim Kreuer 552   1
2913,552 2913 2913 Tim Kreuer 552   1
2963,552 2963 2963 Tim Kreuer 552   1
3159,552 3159 3159 Tim Kreuer 552   1
3399,552 3399 3399 Tim Kreuer 552   1
3930,552 3930 3930 Tim Kreuer 552   1
3962,552 3962 3962 Tim Kreuer 552   1
3990,552 3990 3990 Tim Kreuer 552   1
4050,552 4050 4050 Tim Kreuer 552   1
4101,552 4101 4101 Tim Kreuer 552   1
4176,552 4176 4176 Tim Kreuer 552   1
4208,552 4208 4208 Tim Kreuer 552   1
4219,552 4219 4219 Tim Kreuer 552   1
4283,552 4283 4283 Tim Kreuer 552   1
4316,552 4316 4316 Tim Kreuer 552   1
4363,552 4363 4363 Tim Kreuer 552   1
4432,552 4432 4432 Tim Kreuer 552   1
4453,552 4453 4453 Tim Kreuer 552   1
4471,552 4471 4471 Tim Kreuer 552   1
4499,552 4499 4499 Tim Kreuer 552   1
4636,552 4636 4636 Tim Kreuer 552   1
4685,552 4685 4685 Tim Kreuer 552   1
4791,552 4791 4791 Tim Kreuer 552   1
4805,552 4805 4805 Tim Kreuer 552   1
4859,552 4859 4859 Tim Kreuer 552   1
4870,552 4870 4870 Tim Kreuer 552   1
4891,552 4891 4891 Tim Kreuer 552   1
4984,552 4984 4984 Tim Kreuer 552   1
5092,552 5092 5092 Tim Kreuer 552   1
5136,552 5136 5136 Tim Kreuer 552   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")
);