home / db

kapitel

15 rows where hörspielID = 163

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1468 163 163 1  
1469 163 163 2  
1470 163 163 3  
1471 163 163 4  
1472 163 163 5  
1473 163 163 6  
1474 163 163 7  
1475 163 163 8  
1476 163 163 9  
1477 163 163 10  
1478 163 163 11  
1479 163 163 12  
1480 163 163 13  
1481 163 163 14  
1482 163 163 15  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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")
);
Powered by Datasette · Queries took 5.748ms