home / db

kapitel

20 rows where hörspielID = 283

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2521 283 283 1  
2522 283 283 2  
2523 283 283 3  
2524 283 283 4  
2525 283 283 5  
2526 283 283 6  
2527 283 283 7  
2528 283 283 8  
2529 283 283 9  
2530 283 283 10  
2531 283 283 11  
2532 283 283 12  
2533 283 283 13  
2534 283 283 14  
2535 283 283 15  
2536 283 283 16  
2537 283 283 17  
2538 283 283 18  
2539 283 283 19  
2540 283 283 20  

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 6.47ms