track

12 rows where mediumID = 145

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
1266 145 145 1 Geisterstunde 677293
1267 145 145 2 Erste Ermittlungen 614427
1268 145 145 3 KCY 241280
1269 145 145 4 Die Botschaft des Talismans 580133
1270 145 145 5 Hotel Pacific Pearl 313387
1271 145 145 6 Fragen und Fallen 66173
1272 145 145 7 In der Geisterstadt 615694
1273 145 145 8 Verstorben 103720
1274 145 145 9 Niedergeschlagen 386213
1275 145 145 10 Wilde Kirschen 179093
1276 145 145 11 Magnesiumblitz 233720
1277 145 145 12 Die Juwelen 401774

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "track"(
  "trackID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "mediumID" INTEGER NOT NULL REFERENCES "medium"("mediumID") ON DELETE CASCADE ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  "titel" TEXT NOT NULL,
  "dauer" INTEGER NOT NULL CHECK("dauer" > 0),
  UNIQUE("mediumID", "position")
);