sprechrolle

12 rows where rolleID = 136

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

sprechrolleID ▼ hörspielID rolleID position
238 18 18 Mr. Shaw 136 8
318 23 23 Mr. Shaw 136 15
451 34 34 Mr. Shaw 136 5
909 69 69 Mr. Shaw 136 14
1180 91 91 Mr. Shaw 136 6
2330 186 186 Mr. Shaw 136 8
3603 296 296 Mr. Shaw 136 7
4129 336 336 Mr. Shaw 136 12
4276 349 349 Mr. Shaw 136 5
4368 358 358 Mr. Shaw 136 5
4751 388 388 Mr. Shaw 136 12
4947 403 403 Mr. Shaw 136 7

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")
);