Songs 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 | SongData Name | SongData Type | SongData Description | |
|---|---|---|---|---|---|---|---|
| ID | INTEGER | AUTOINCREMENT (1 to inf.) | ID | Property Get/Let | |||
| Artist | TEXT | ArtistName | Property Get/Let | ||||
| IDAlbum | INTEGER | ||||||
| Album | TEXT | AlbumName | Property Get/Let | ||||
| AlbumArtist | TEXT | AlbumArtistName | Property Get/Let | ||||
| DiscNumber | TEXT | DiscNumberStr | Property Get/Let | ||||
| TrackNumber | TEXT | TrackOrderStr | Property Get/Let | ||||
| SongTitle | TEXT | Title | Property Get/Let | ||||
| SongPath | TEXT | Path | Property Get/Let | ||||
| Extension | TEXT* | 5 characters max | |||||
| Year | INTEGER | 2010 | Year | Property Get/Let | |||
| Date | INTEGER | 20100930 | |||||
| Genre | TEXT | Genre | Property Get/Let | ||||
| FileLength | INTEGER | FileLength | Property Get/Let | ||||
| SongLength | INTEGER | SongLength | Property Get/Let | ||||
| IDMedia | INTEGER | Media | Property Get | ||||
| CacheStatus | INTEGER | Cached | Property Get/Let | ||||
| CacheName | TEXT | CachedPath | Property Get | ||||
| Rating | INTEGER | Rating | Property Get/Let | ||||
| Bitrate | INTEGER | Bitrate | Property Get/Let | ||||
| TrackType | INTEGER | Music = 0, Podcast = 1, Audiobook = 2 | Added in version 3.1 | ||||
| IDEpisode | INTEGER | Corresponds to PodcastsEpisodes.ID | Added in version 3.1 | ||||
| Broadcast | INTEGER | ||||||
| PreviewState | INTEGER | ||||||
| PreviewName | TEXT | PreviewPath | Property Get | ||||
| PreviewStartTime | INTEGER | ||||||
| PreviewLength | INTEGER | ||||||
| Author | TEXT | The Composer of the Song | Author | Property Get/Let | |||
| SamplingFrequency | INTEGER | SampleRate | Property Get/Let | ||||
| Stereo | INTEGER | Channels | Property Get/Let | ||||
| Copyrighted | INTEGER | ||||||
| Original | INTEGER | ||||||
| VBR | INTEGER | VBR | Property Get/Let | ||||
| BPM | INTEGER | Beats Per Minute | BPM | Property Get/Let | |||
| SignType | INTEGER | ||||||
| SignPart1 | INTEGER | ||||||
| SignPart2 | INTEGER | ||||||
| SignPart3 | INTEGER | ||||||
| SignPart4 | INTEGER | ||||||
| PlayCounter | INTEGER | PlayCounter | Property Get/Let | ||||
| LastTimePlayed | REAL | UTC as Delphi TDateTime | LastPlayed | Property Get/Let | |||
| LastTimeSkipped | REAL | UTC as Delphi TDateTime | Added in version 5.1 | ||||
| AudioCDTrack | INTEGER | ||||||
| FileModified | REAL | UTC as Delphi TDateTime | FileModified | Property Get/Let | |||
| TrackModified | REAL | UTC as Delphi TDateTime | |||||
| ArtworkModified | REAL | UTC as Delphi TDateTime | Added in version 5.0 | ||||
| MaxSample | REAL | ||||||
| NormalizeTrack | REAL | Track gain value (dB) | Leveling | Property Get/Let | |||
| NormalizeAlbum | REAL | Album gain value (dB) | LevelingAlbum | Property Get/Let | |||
| Custom1 | TEXT | Custom1 | Property Get/Let | ||||
| Custom2 | TEXT | Custom2 | Property Get/Let | ||||
| Custom3 | TEXT | Custom3 | Property Get/Let | ||||
| Custom4 | TEXT | Custom4 | Property Get/Let | ||||
| Custom5 | TEXT | Custom5 | Property Get/Let | ||||
| Custom6 | TEXT | Added in version 5.0 | |||||
| Custom7 | TEXT | Added in version 5.0 | |||||
| Custom8 | TEXT | Added in version 5.0 | |||||
| Custom9 | TEXT | Added in version 5.0 | |||||
| Custom10 | TEXT | Added in version 5.0 | |||||
| DateAdded | REAL | UTC as Delphi TDateTime | DateAdded | Property Get/Let | |||
| OrigFileLength | INTEGER | ||||||
| PreGap | INTEGER | PreGap | Property Get/Let | ||||
| PostGap | INTEGER | PostGap | Property Get/Let | ||||
| TotalSamples | INTEGER | TotalSamples | Property Get/Let | ||||
| PlaybackPos | INTEGER | Bookmark | Property Get/Let | To be confirmed | |||
| GaplessBytes | INTEGER | GaplessBytes | Property Get/Let | ||||
| IDFolder | INTEGER | ||||||
| Copyright | TEXT | Copyright | Property Get/Let | ||||
| Publisher | TEXT | Publisher | Property Get/Let | ||||
| Encoder | TEXT | Encoder | Property Get/Let | ||||
| EncodedBy | TEXT | ||||||
| Lyricist | TEXT | Lyricist | Property Get/Let | ||||
| Band | TEXT | Band | Property Get/Let | ||||
| Conductor | TEXT | Conductor | Property Get/Let | ||||
| Remixer | TEXT | ||||||
| InvolvedPeople | TEXT | InvolvedPeople | Property Get/Let | ||||
| OrigTitle | TEXT | OriginalTitle | Property Get/Let | ||||
| OrigArtist | TEXT | OriginalArtist | Property Get/Let | ||||
| OrigLyricist | TEXT | OriginalLyricist | Property Get/Let | ||||
| GroupDesc | TEXT | Grouping | Property Get/Let | ||||
| SubTitle | TEXT | ||||||
| ISRC | TEXT | ISRC | Property Get/Let | ||||
| cuePath | TEXT | Added in version 5.1 | |||||
| InitialKey | TEXT | ||||||
| Language | TEXT | ||||||
| MediaType | TEXT | ||||||
| RatingString | TEXT | ||||||
| WebCommercial | TEXT | ||||||
| WebCopyright | TEXT | ||||||
| WebFilepage | TEXT | ||||||
| WebArtist | TEXT | ||||||
| WebSource | TEXT | ||||||
| WebRadio | TEXT | ||||||
| WebPayment | TEXT | ||||||
| WebPublisher | TEXT | ||||||
| WebUser | TEXT | ||||||
| OrigYear | INTEGER | OriginalYear | Property Get/Let | ||||
| Tempo | TEXT | Tempo | Property Get/Let | ||||
| Mood | TEXT | Mood | Property Get/Let | ||||
| Occasion | TEXT | Occasion | Property Get/Let | ||||
| Quality | TEXT | Quality | Property Get/Let | ||||
| Lyrics | TEXT | Lyrics | Property Get/Let | ||||
| Comment | TEXT | Comment | Property Get/Let | ||||
| ExtendedTags | TEXT | Added in version 5.0 |
