videos
1 row where s_uid = "s_bfrzn"
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_lf6gg | DV-1254 | Female Teacher Yumika - How Low Will She Go - Mako Oda | 続 女教師・弓香 どこまでも墜ちていく運命 織田真子 | https://pics.dmm.co.jp/digital/video/53dv01254/53dv01254pl.jpg | https://pics.dmm.co.jp/digital/video/53dv01254/53dv01254ps.jpg | https://cc3001.dmm.co.jp/litevideo/freepv/5/53d/53dv1254/53dv1254_sm_w.mp4 | 119 | 2011-04-22 | Female Teacher Yumika s_bfrzn | 2026-08-30 14:02:39 | 2026-08-30 16:06:08 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);