DeviceTracks table
Jump to navigation
Jump to search
- [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 |
