track

9 rows where mediumID = 311

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
2943 311 311 1 Millionen 424613
2944 311 311 2 Gold! Gold! Gold! 391360
2945 311 311 3 Goldrausch 603387
2946 311 311 4 Titus 1 454507
2947 311 311 5 Wiildschweinjagd 459653
2948 311 311 6 Lauschangriff 613920
2949 311 311 7 Verschleppt 405093
2950 311 311 8 Wildwasserfahrt 471880
2951 311 311 9 Falschgold 522320

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