sprechrolleTeil
23 rows where hörspielID = 161
This data as json, CSV (advanced)
| Link | sprechrolleID | hörspielID | position |
|---|---|---|---|
| 1941,161 | 1941 1941 | 161 161 | 1 |
| 1942,161 | 1942 1942 | 161 161 | 2 |
| 1943,161 | 1943 1943 | 161 161 | 3 |
| 1944,161 | 1944 1944 | 161 161 | 4 |
| 1945,161 | 1945 1945 | 161 161 | 5 |
| 1946,161 | 1946 1946 | 161 161 | 6 |
| 1947,161 | 1947 1947 | 161 161 | 7 |
| 1948,161 | 1948 1948 | 161 161 | 8 |
| 1949,161 | 1949 1949 | 161 161 | 9 |
| 1950,161 | 1950 1950 | 161 161 | 10 |
| 1951,161 | 1951 1951 | 161 161 | 11 |
| 1952,161 | 1952 1952 | 161 161 | 12 |
| 1953,161 | 1953 1953 | 161 161 | 13 |
| 1954,161 | 1954 1954 | 161 161 | 14 |
| 1955,161 | 1955 1955 | 161 161 | 15 |
| 1956,161 | 1956 1956 | 161 161 | 16 |
| 1957,161 | 1957 1957 | 161 161 | 17 |
| 1958,161 | 1958 1958 | 161 161 | 18 |
| 1959,161 | 1959 1959 | 161 161 | 19 |
| 1960,161 | 1960 1960 | 161 161 | 20 |
| 1961,161 | 1961 1961 | 161 161 | 21 |
| 1962,161 | 1962 1962 | 161 161 | 22 |
| 1963,161 | 1963 1963 | 161 161 | 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")
);