kapitel

24 rows where hörspielID = 295

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2619 295 295 1  
2620 295 295 2  
2621 295 295 3  
2622 295 295 4  
2623 295 295 5  
2624 295 295 6  
2625 295 295 7  
2626 295 295 8  
2627 295 295 9  
2628 295 295 10  
2629 295 295 11  
2630 295 295 12  
2631 295 295 13  
2632 295 295 14  
2633 295 295 15  
2634 295 295 16  
2635 295 295 17  
2636 295 295 18  
2637 295 295 19  
2638 295 295 20  
2639 295 295 21  
2640 295 295 22  
2641 295 295 23  
2642 295 295 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")
);