home / db

kapitel

24 rows where hörspielID = 272

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2399 272 272 1  
2400 272 272 2  
2401 272 272 3  
2402 272 272 4  
2403 272 272 5  
2404 272 272 6  
2405 272 272 7  
2406 272 272 8  
2407 272 272 9  
2408 272 272 10  
2409 272 272 11  
2410 272 272 12  
2411 272 272 13  
2412 272 272 14  
2413 272 272 15  
2414 272 272 16  
2415 272 272 17  
2416 272 272 18  
2417 272 272 19  
2418 272 272 20  
2419 272 272 21  
2420 272 272 22  
2421 272 272 23  
2422 272 272 24  

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.165ms