DeviceTracks table: Difference between revisions
Jump to navigation
Jump to search
(Created DeviceTracks table) |
m ({{DatabaseTablesList}}) |
||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | |||
== Fields == | == Fields == | ||
{| border="1" | {| border="1" | ||
Revision as of 15:51, 11 April 2024
- [Database Structure]
- Albums
- Artists
- ArtistsAlbums
- ArtistsSongs
- Covers
- DBInfo
- DeviceFilters
- DeviceTracks
- Devices
- Downloads
- Filters
- Folders
- FoldersHier
- Genres
- GenresSongs
- LastTreePath
- Lists
- ListsSongs
- Medias
- OrganizeRules
- PathProcessing
- Pinned
- Played
- PlaylistSongs
- Playlists
- PodcastDirs
- PodcastEpisodes
- Podcasts
- Radio
- RemoteClients
- Songs
- SynchAlbum
- SynchArtist
- SynchLocation
- SynchPlaylist
- SynchPodcast
- URLRequestCache
Fields
| Name | Value Type | Possible Values | Description |
|---|---|---|---|
| ID | INTEGER | ||
| IDDevice | INTEGER | ID of the associated device in the Devices table. | |
| IDTrack | INTEGER | ID of the associated track in the Songs table. | |
| DevicePath | TEXT | ||
| Rating | INTEGER | ||
| Bitrate | INTEGER | ||
| SampleRate | INTEGER | ||
| Channels | INTEGER | ||
| isVBR | INTEGER | ||
| PlayCount | INTEGER | ||
| UploadTime | REAL | Formatted as the number of days since December 30, 1899. | |
| ACSettHash | TEXT | ||
| Status | INTEGER | ||
| Converted | INTEGER | ||
| PreModified | INTEGER | ||
| SyncID | TEXT | Added in version 5.0 | |
| SourceInfo | TEXT | Added in version 5.0 | |
| LastMetaHash | TEXT | Added in version 5.0 |
