sprechrolle

6 rows where rolleID = 291

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

sprechrolleID ▼ hörspielID rolleID position
500 38 38 Mrs. Shaw 291 5
910 69 69 Mrs. Shaw 291 15
991 75 75 Mrs. Shaw 291 5
1231 96 96 Mrs. Shaw 291 9
1965 160 160 Mrs. Shaw 291 25
2803 242 242 Mrs. Shaw 291 5

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