sprechrolleTeil
23 rows where hörspielID = 226
This data as json, CSV (advanced)
| Link | sprechrolleID | hörspielID | position |
|---|---|---|---|
| 2651,226 | 2651 2651 | 226 226 | 1 |
| 2652,226 | 2652 2652 | 226 226 | 2 |
| 2653,226 | 2653 2653 | 226 226 | 3 |
| 2654,226 | 2654 2654 | 226 226 | 4 |
| 2655,226 | 2655 2655 | 226 226 | 5 |
| 2656,226 | 2656 2656 | 226 226 | 6 |
| 2657,226 | 2657 2657 | 226 226 | 7 |
| 2658,226 | 2658 2658 | 226 226 | 8 |
| 2659,226 | 2659 2659 | 226 226 | 9 |
| 2660,226 | 2660 2660 | 226 226 | 10 |
| 2661,226 | 2661 2661 | 226 226 | 11 |
| 2662,226 | 2662 2662 | 226 226 | 12 |
| 2663,226 | 2663 2663 | 226 226 | 13 |
| 2664,226 | 2664 2664 | 226 226 | 14 |
| 2665,226 | 2665 2665 | 226 226 | 15 |
| 2666,226 | 2666 2666 | 226 226 | 16 |
| 2667,226 | 2667 2667 | 226 226 | 17 |
| 2668,226 | 2668 2668 | 226 226 | 18 |
| 2669,226 | 2669 2669 | 226 226 | 19 |
| 2670,226 | 2670 2670 | 226 226 | 20 |
| 2671,226 | 2671 2671 | 226 226 | 21 |
| 2672,226 | 2672 2672 | 226 226 | 22 |
| 2684,226 | 2684 2684 | 226 226 | 23 |
Advanced export
JSON shape: default, array, newline-delimited, object
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")
);