D
DreamLake

DB Schema

Video

Video index record. Binary data (HLS chunks, playlists, thumbnails) lives in S3.

FieldTypeDescription
idObjectIdPrimary key
ownerStringNamespace slug
projectStringProject slug
episodeIdString?DreamLake episode ID
stFloatStart time: Unix timestamp (seconds)
dtFloatFrame interval: 1/fps
fpsFloatFrames per second
lengthIntTotal frames
offsetFloatTime shift in seconds (default: 0)
speedFloatPlayback speed multiplier (default: 1.0)
durationSecFloatDerived: length * dt
deletedAtDateTime?Soft delete timestamp
createdAtDateTimeCreated timestamp
updatedAtDateTimeLast updated

Indexes: owner, [owner, project], episodeId