DB Schema
TextTrack
Transcript, subtitle, or free-form label segments. Time-aligned JSONL chunks.
| Field | Type | Description |
|---|---|---|
id | ObjectId | Primary key |
name | String | Display name |
description | String? | Description |
tags | String[] | Tags |
projectId | String | Parent project |
episodeId | String? | Optional episode link |
folderId | ObjectId? | → Node.id (null = project root) |
filename | String? | Basename (e.g. "subtitles.vtt") |
path | String | Topic path (e.g. "subtitles/en") |
chunks | Json | Chunk manifest: [{ path, src }] (default: []) |
t0 | DateTime? | Wall-clock anchor of first segment |
length | BigInt | Total segment count (default: 0) |
metadata | Json? | Arbitrary metadata |
deletedAt | DateTime? | Soft delete timestamp |
createdAt | DateTime | Created timestamp |
updatedAt | DateTime | Last updated timestamp |
Indexes: projectId, episodeId, folderId, path, tags, deletedAt