Files¶
One file on disk, video or audio, with the facts measured from the file itself.
| Field | Type | Required | Allowed values or link | Definition | Purpose | MP4 tag | MP3 tag |
|---|---|---|---|---|---|---|---|
File_Kind |
One value from a list | Yes | Video, Audio | Video or Audio. | Says which kind of file the row is. | None | None |
File_Path |
Text | Yes | The full path of the file, under the Tracks or Tracks2 root, ending .m4v for video and .m4a or .mp3 for audio. | Where the file lives. | None | None | |
Video |
Link to one row | Row of Videos | A link to the Videos row the file belongs to. | Pairs a video and its audio through the YouTube ID. | None | None | |
File_Status |
One value from a list | Monitored, Downloaded, Replaced, Needed, Pending, Filed | Where the file is in its life: Monitored, Downloaded, Replaced (video); Needed, Pending, Filed, Replaced (audio). | Lets a run resume, and shows what is finished, queued or superseded. | None | None | |
File_Format |
Text | The file's format as measured: the container and codec of a video, or ALAC, FLAC, AAC or MP3 for audio. | Ranks copies when two files collide. | None | None | ||
Video_Resolution |
Text | The video's picture size as width x height (for example 1920x1080). Blank for audio. | Settles 'Primary pending' groups and picks the better video in a collision. | None | None | ||
Audio_Sample_Rate_Hz |
Whole number | The audio's sample rate in Hz (for example 44100). Blank for video. | Picks the better audio when the format is the same. | None | None | ||
Audio_Bit_Depth |
Whole number | The audio's bit depth (for example 16). Blank for video. | Picks the better audio when the format and sample rate are the same. | None | None | ||
Bitrate_Kbps |
Whole number | The file's bitrate in kilobits per second. | The tie-breaker after resolution or format. | None | None | ||
Obtained_From |
One value from a list | YouTube, Soulseek, Tracks folder | Where the file came from: YouTube, Soulseek or Tracks folder. | Traces a file back to its source. | None | None | |
Is_Verified |
Yes or no | Yes only when the artist, recording and album have verified IDs (or are confirmed as not in MusicBrainz), album, year, disc and track are present, the Primary is decided and the check shows no problems. On an audio file: the fingerprint and length checks passed. | Only verified videos are downloaded and synced. | None | None | ||
Updated_Date |
Date | The date the row was last changed. It stamps itself. | Shows what changed recently. On a video it is also written to the file's tag. | None | None | ||
File_Size_Bytes |
Decimal number | The file's size in bytes, measured from the file when it is filed or replaced and measured again whenever the file changes. | Lets a sync tell two copies apart quickly, and catches truncated or empty downloads. | None | None | ||
File_Hash_SHA256 |
Text | The SHA-256 fingerprint of the file's contents: 64 lowercase hexadecimal characters, measured from the file. | Proves two copies are identical, so a sync never copies or replaces a file that already matches, and finds corrupt files and duplicates. | None | None | ||
File_Modified_Time |
Date and time (UTC) | The file's last-modified date and time as the file system reports it, in UTC. | Lets a sync tell which copy is newer without reading the contents, together with the size and hash. | None | None |
This page is generated from the data dictionary. Change the dictionary, not this page.