sprechrolle

6 rows where rolleID = 595

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

sprechrolleID ▼ hörspielID rolleID position
1052 79 79 Hank 595 13
2940 249 249 Hank 595 9
3013 253 253 Hank 595 6
3040 255 255 Hank 595 6
5027 416 416 Hank 595 18
5053 418 418 Hank 595 13

Advanced export

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

CSV options: 

CREATE TABLE "sprechrolle"(
  "sprechrolleID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "hörspielID" INTEGER NOT NULL REFERENCES "hörspiel"("hörspielID") ON DELETE CASCADE ON UPDATE CASCADE,
  "rolleID" INTEGER NOT NULL REFERENCES "rolle"("rolleID") ON DELETE CASCADE ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  UNIQUE("hörspielID", "rolleID"),
  UNIQUE("hörspielID", "position")
);