medium

3 rows where hörspielID = 412

✎ View and edit SQL

This data as json, CSV (advanced)

mediumID ▼ hörspielID position ripLog musicBrainzID
411 412 412 1 0 JHlPYk9OHfakr.8ILmw9lWD5JQk-
412 412 412 2 0 Y5T4Kb9A_6KJenhdlfdPFTcRTPg-
413 412 412 3 0 K9k.DbelB.v.C6wt7m36dnhwpvw-

Advanced export

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

CSV options: 

CREATE TABLE "medium"(
  "mediumID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "hörspielID" INTEGER NOT NULL REFERENCES "hörspiel"("hörspielID") ON DELETE CASCADE ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  "ripLog" BOOLEAN NOT NULL,
  "musicBrainzID" TEXT,
  UNIQUE("hörspielID", "position")
);