sprechrolleTeil
31 rows where hörspielID = 163
This data as json, CSV (advanced)
| Link | sprechrolleID | hörspielID | position |
|---|---|---|---|
| 1941,163 | 1941 1941 | 163 163 | 1 |
| 1942,163 | 1942 1942 | 163 163 | 2 |
| 1943,163 | 1943 1943 | 163 163 | 3 |
| 1944,163 | 1944 1944 | 163 163 | 4 |
| 1945,163 | 1945 1945 | 163 163 | 5 |
| 1947,163 | 1947 1947 | 163 163 | 7 |
| 1948,163 | 1948 1948 | 163 163 | 11 |
| 1950,163 | 1950 1950 | 163 163 | 30 |
| 1954,163 | 1954 1954 | 163 163 | 23 |
| 1955,163 | 1955 1955 | 163 163 | 26 |
| 1956,163 | 1956 1956 | 163 163 | 21 |
| 1957,163 | 1957 1957 | 163 163 | 20 |
| 1958,163 | 1958 1958 | 163 163 | 24 |
| 1960,163 | 1960 1960 | 163 163 | 25 |
| 1963,163 | 1963 1963 | 163 163 | 31 |
| 1964,163 | 1964 1964 | 163 163 | 22 |
| 1971,163 | 1971 1971 | 163 163 | 9 |
| 1972,163 | 1972 1972 | 163 163 | 6 |
| 1973,163 | 1973 1973 | 163 163 | 8 |
| 1974,163 | 1974 1974 | 163 163 | 10 |
| 1975,163 | 1975 1975 | 163 163 | 12 |
| 1976,163 | 1976 1976 | 163 163 | 13 |
| 1977,163 | 1977 1977 | 163 163 | 14 |
| 1978,163 | 1978 1978 | 163 163 | 15 |
| 1979,163 | 1979 1979 | 163 163 | 16 |
| 1980,163 | 1980 1980 | 163 163 | 17 |
| 1981,163 | 1981 1981 | 163 163 | 18 |
| 1982,163 | 1982 1982 | 163 163 | 19 |
| 1983,163 | 1983 1983 | 163 163 | 27 |
| 1984,163 | 1984 1984 | 163 163 | 28 |
| 1985,163 | 1985 1985 | 163 163 | 29 |
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")
);