home / media

videos

1 row where s_uid = "s_67a60"

This data as json, CSV (advanced)

Suggested facets: releaseDate (date), createdAt (date), updatedAt (date)

uid ▼ code titleEn titleJa descriptionEn descriptionJa jacketFullUrl jacketThumbUrl sampleUrl runtimeMins releaseDate s_uid createdAt updatedAt
v_qhtd4 ALDN-514 At That Time, Your Mother-in-law Invited Me... Yurine Tsukino あの時、お義母さんに誘われて… 月野ゆりね     https://pics.dmm.co.jp/digital/video/aldn00514/aldn00514pl.jpg https://pics.dmm.co.jp/digital/video/aldn00514/aldn00514ps.jpg https://cc3001.dmm.co.jp/pv/QXYlAjgA81lwkdTnP_Tr_wRb0L7bG70_ltHIy3y2DEsrZTQXtlUaEQSWq4N2/aldn514mhb.mp4 106 2025-10-11 Invited by the Stepmom s_67a60 2026-08-30 14:10:24 2026-08-30 16:22:09

Advanced export

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

CSV options:

CREATE TABLE videos (
  uid            TEXT PRIMARY KEY,
  code           TEXT NOT NULL UNIQUE,

  titleEn        TEXT,
  titleJa        TEXT,
  -- Some providers publish this as a "comment" rather than a description; it
  -- is the same field and lands here either way.
  descriptionEn  TEXT,
  descriptionJa  TEXT,

  jacketFullUrl  TEXT,
  jacketThumbUrl TEXT,
  sampleUrl      TEXT,

  runtimeMins    INTEGER,
  releaseDate    TEXT,            -- ISO yyyy-mm-dd

  s_uid          TEXT REFERENCES series(uid) ON DELETE SET NULL,

  createdAt      TEXT NOT NULL DEFAULT (datetime('now')),
  updatedAt      TEXT NOT NULL DEFAULT (datetime('now'))
);
CREATE INDEX idx_videos_release ON videos(releaseDate);
CREATE INDEX idx_videos_series  ON videos(s_uid);
Powered by Datasette · Queries took 5.417ms