Songs table
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 | ||||
| Year | INTEGER | Year | Property Get/Let | ||||
| 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 | ||||
| Seekable | INTEGER | isBookmarkable | Property Get/Let | To be confirmed | |||
| 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 | LastPlayed | Property Get/Let | ||||
| AudioCDTrack | INTEGER | ||||||
| FileModified | REAL | FileModified | Property Get/Let | ||||
| TrackModified | REAL | ||||||
| MaxSample | REAL | ||||||
| NormalizeTrack | REAL | Leveling | Property Get/Let | ||||
| NormalizeAlbum | REAL | 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 | ||||
| DateAdded | REAL | 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 | ||||
| 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 |
