kapitel

24 rows where hörspielID = 282

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2497 282 282 1  
2498 282 282 2  
2499 282 282 3  
2500 282 282 4  
2501 282 282 5  
2502 282 282 6  
2503 282 282 7  
2504 282 282 8  
2505 282 282 9  
2506 282 282 10  
2507 282 282 11  
2508 282 282 12  
2509 282 282 13  
2510 282 282 14  
2511 282 282 15  
2512 282 282 16  
2513 282 282 17  
2514 282 282 18  
2515 282 282 19  
2516 282 282 20  
2517 282 282 21  
2518 282 282 22  
2519 282 282 23  
2520 282 282 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")
);