kapitel

16 rows where hörspielID = 274

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2432 274 274 1  
2433 274 274 2  
2434 274 274 3  
2435 274 274 4  
2436 274 274 5  
2437 274 274 6  
2438 274 274 7  
2439 274 274 8  
2440 274 274 9  
2441 274 274 10  
2442 274 274 11  
2443 274 274 12  
2444 274 274 13  
2445 274 274 14  
2446 274 274 15  
2447 274 274 16  

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")
);