DeviceTracks table: Difference between revisions
Jump to navigation
Jump to search
m ({{DatabaseTablesList}}) |
(Added asterisks for non IUNICODE fields) |
||
| Line 64: | Line 64: | ||
|- | |- | ||
| '''ACSettHash''' | | '''ACSettHash''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 84: | Line 84: | ||
|- | |- | ||
| '''SyncID''' | | '''SyncID''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| Added in version 5.0 | | Added in version 5.0 | ||
|- | |- | ||
| '''SourceInfo''' | | '''SourceInfo''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| Added in version 5.0 | | Added in version 5.0 | ||
|- | |- | ||
| '''LastMetaHash''' | | '''LastMetaHash''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| Added in version 5.0 | | Added in version 5.0 | ||
|} | |} | ||
Latest revision as of 16:18, 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 |
