home / db

track

9 rows where mediumID = 378

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
3497 378 378 1 Jubiläum: 20 Jahre! 354733
3498 378 378 2 Feueralarm 459894
3499 378 378 3 Brandforscher 484320
3500 378 378 4 Geisterstadt 827986
3501 378 378 5 Mono See 447080
3502 378 378 6 Minenarbeiter 426947
3503 378 378 7 Kellergeister 410373
3504 378 378 8 Schatzjäger 337080
3505 378 378 9 Goldregen 393707

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")
);
Powered by Datasette · Queries took 4.702ms