DB Schema
Audio
Audio asset. Space-level or episode-scoped. Codec-aware streaming (AAC, OPUS, etc.).
| 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. "mic.wav") |
path | String | Topic path for S3 construction (e.g. "microphone/front") |
chunks | Json | Chunk manifest: [{ path, src }] (default: []) |
t0 | DateTime? | Wall-clock anchor of first sample |
length | BigInt | Total samples (default: 0) |
sampleRate | Int? | Hz (e.g. 44100, 48000) |
channels | Int? | 1 = mono, 2 = stereo |
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