sprechrolleTeil

17 rows where hörspielID = 227

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID hörspielID position
2651,227 2651 2651 227 227 1
2652,227 2652 2652 227 227 2
2653,227 2653 2653 227 227 3
2654,227 2654 2654 227 227 4
2657,227 2657 2657 227 227 5
2660,227 2660 2660 227 227 6
2661,227 2661 2661 227 227 10
2662,227 2662 2662 227 227 12
2663,227 2663 2663 227 227 9
2673,227 2673 2673 227 227 7
2674,227 2674 2674 227 227 8
2675,227 2675 2675 227 227 11
2676,227 2676 2676 227 227 13
2677,227 2677 2677 227 227 14
2678,227 2678 2678 227 227 15
2679,227 2679 2679 227 227 16
2684,227 2684 2684 227 227 17

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sprechrolleTeil"(
  "sprechrolleID" INTEGER NOT NULL REFERENCES "sprechrolle"("sprechrolleID") ON DELETE CASCADE ON UPDATE CASCADE,
  "hörspielID" INTEGER NOT NULL REFERENCES "hörspielTeil"("teil") ON DELETE CASCADE ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  PRIMARY KEY("sprechrolleID", "hörspielID"),
  UNIQUE("hörspielID", "position")
);