DB Schema
Video
Video asset index record. Binary data (HLS chunks, playlists) lives in BSS / S3.
| Field | Type | Description |
|---|---|---|
id | ObjectId | Primary key |
projectId | String | Parent project |
episodeId | String? | Optional episode link |
name | String? | Full path (e.g. "/camera/front/run01.mp4") — kept for compat |
folderId | ObjectId? | → Node.id (null = project root) |
filename | String? | Basename (e.g. "run01.mp4") |
tags | String[] | Tags |
st | Float | Start time: Unix timestamp (seconds) |
dt | Float | Frame interval: 1/fps |
fps | Float | Frames per second |
length | Int | Total frames |
offset | Float | Time shift in seconds (default: 0) |
speed | Float | Playback speed multiplier (default: 1.0) |
lens | String | "fisheye" | "pinhole" | "eqrec" |
bssVideoId | String? | BSS Video.id reference |
metadata | Json? | Arbitrary metadata |
deletedAt | DateTime? | Soft delete timestamp |
createdAt | DateTime | Created timestamp |
updatedAt | DateTime | Last updated timestamp |
Indexes: projectId, episodeId, folderId, lens, tags, deletedAt