sprechrolle

23 rows where rolleID = 525

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

sprechrolleID ▼ hörspielID rolleID position
911 69 69 Goodween 525 16
1272 99 99 Goodween 525 15
1308 105 105 Goodween 525 9
1484 120 120 Goodween 525 8
1747 145 145 Goodween 525 6
1766 146 146 Goodween 525 11
2010 165 165 Goodween 525 7
2026 166 166 Goodween 525 11
2094 170 170 Goodween 525 14
2278 182 182 Goodween 525 20
2321 185 185 Goodween 525 13
2398 201 201 Goodween 525 14
2623 222 222 Goodween 525 12
2746 233 233 Goodween 525 9
2806 242 242 Goodween 525 8
2908 247 247 Goodween 525 16
2979 251 251 Goodween 525 15
3237 272 272 Goodween 525 10
3426 284 284 Goodween 525 17
3549 293 293 Goodween 525 14
3610 296 296 Goodween 525 14
3762 307 307 Goodween 525 13
5070 419 419 Goodween 525 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")
);