track

8 rows where mediumID = 412

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
3788 412 412 1 Tag 9 – Wasserspiele 396547
3789 412 412 2 Tag 10 – Geheimschriften 435293
3790 412 412 3 Tag 11 – Geisterstunde 418867
3791 412 412 4 Tag 12 – Frühstückszeit 379160
3792 412 412 5 Tag 13 – Fiese Erpresser 426866
3793 412 412 6 Tag 14 – Zu früh gefreut 434040
3794 412 412 7 Tag 15 – Fingerabdrücke 412627
3795 412 412 8 Tag 16 – Wunschlisten 380760

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")
);