home / db

kapitel

14 rows where hörspielID = 202

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1867 202 202 1  
1868 202 202 2  
1869 202 202 3  
1870 202 202 4  
1871 202 202 5  
1872 202 202 6  
1873 202 202 7  
1874 202 202 8  
1875 202 202 9  
1876 202 202 10  
1877 202 202 11  
1878 202 202 12  
1879 202 202 13  
1880 202 202 14  

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