spricht

6 rows where personID = 349

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1174,349 1174 1174 Till Demtrøder 349   1
1555,349 1555 1555 Till Demtrøder 349   1
2245,349 2245 2245 Till Demtrøder 349   1
2646,349 2646 2646 Till Demtrøder 349   1
3250,349 3250 3250 Till Demtrøder 349   1
4010,349 4010 4010 Till Demtrøder 349   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")
);