DB Schema
Node
Materialized-paths folder tree for organizing assets and episodes within a Space.
| Field | Type | Description |
|---|---|---|
id | ObjectId | Primary key |
name | String | Local folder name (e.g. "front") |
path | String | Materialized ancestor path (e.g. ",camera,") |
kind | String | "folder" | "episode" | "video" | "audio" | "label-track" | "text-track" | "track" (default: "folder") |
leaf | Int | 1 = leaf node, 0 = has or may have children (default: 0) |
projectId | ObjectId | Parent project |
deletedAt | DateTime? | Soft delete timestamp |
createdAt | DateTime | Created timestamp |
updatedAt | DateTime | Last updated timestamp |
Relations: episodes: Episode[]
Unique: [projectId, path, name] — name unique within same parent
Indexes: [projectId, path], deletedAt