kapitel
26 rows where hörspielID = 125
This data as json, CSV (advanced)
| trackID ▼ | hörspielID | position | abweichenderTitel |
|---|---|---|---|
| 1002 | 125 125 | 1 | |
| 1003 | 125 125 | 2 | |
| 1004 | 125 125 | 3 | |
| 1005 | 125 125 | 4 | |
| 1006 | 125 125 | 5 | |
| 1007 | 125 125 | 6 | |
| 1008 | 125 125 | 7 | |
| 1009 | 125 125 | 8 | |
| 1010 | 125 125 | 9 | |
| 1011 | 125 125 | 10 | |
| 1012 | 125 125 | 11 | |
| 1013 | 125 125 | 12 | |
| 1014 | 125 125 | 13 | |
| 1015 | 125 125 | 14 | |
| 1016 | 125 125 | 15 | |
| 1017 | 125 125 | 16 | |
| 1018 | 125 125 | 17 | |
| 1019 | 125 125 | 18 | |
| 1020 | 125 125 | 19 | |
| 1021 | 125 125 | 20 | |
| 1022 | 125 125 | 21 | |
| 1023 | 125 125 | 22 | |
| 1024 | 125 125 | 23 | |
| 1025 | 125 125 | 24 | |
| 1026 | 125 125 | 25 | |
| 1027 | 125 125 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "kapitel"(
"trackID" INTEGER PRIMARY KEY NOT NULL REFERENCES "track"("trackID") ON DELETE CASCADE ON UPDATE CASCADE,
"hörspielID" INTEGER NOT NULL REFERENCES "hörspiel"("hörspielID") ON DELETE CASCADE ON UPDATE CASCADE,
"position" INTEGER NOT NULL CHECK("position" > 0),
"abweichenderTitel" TEXT,
UNIQUE("hörspielID", "position")
);