Songs table: Difference between revisions
Jump to navigation
Jump to search
MoDementia (talk | contribs) No edit summary |
No edit summary |
||
| Line 94: | Line 94: | ||
| Year<span id="Year"></span> | | Year<span id="Year"></span> | ||
| INTEGER | | INTEGER | ||
| | | 2010 | ||
| | | | ||
| | | | ||
| [[ISDBSongData::Year |Year ]] | | [[ISDBSongData::Year |Year ]] | ||
| Property Get/Let | | Property Get/Let | ||
| | |||
|- | |||
| Date<span id="Date"></span> | |||
| INTEGER | |||
| 20100930 | |||
| | |||
| | |||
| | |||
| | |||
| | | | ||
|- | |- | ||
| Line 173: | Line 182: | ||
| | | | ||
|- | |- | ||
| | | TrackType<span id="TrackType"></span> | ||
| INTEGER | |||
| Music = 0, Podcast = 1, Audiobook = 2 | |||
| Added in version 3.1 | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
| IDEpisode<span id="IDEpisode"></span> | |||
| INTEGER | | INTEGER | ||
| Corresponds to PodcastsEpisodes.ID | |||
| Added in version 3.1 | |||
| | |||
| | | | ||
| | | | ||
| | | | ||
|- | |- | ||
| Broadcast<span id="Broadcast"></span> | | Broadcast<span id="Broadcast"></span> | ||
| Line 392: | Line 410: | ||
| REAL | | REAL | ||
| | | | ||
| | | Track gain value (dB) | ||
| | | | ||
| [[ISDBSongData::Leveling |Leveling ]] | | [[ISDBSongData::Leveling |Leveling ]] | ||
| Line 401: | Line 419: | ||
| REAL | | REAL | ||
| | | | ||
| | | Album gain value (dB) | ||
| | | | ||
| [[ISDBSongData::LevelingAlbum |LevelingAlbum ]] | | [[ISDBSongData::LevelingAlbum |LevelingAlbum ]] | ||
Revision as of 11:34, 27 November 2009
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 | 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 | LastPlayed | Property Get/Let | ||||
| AudioCDTrack | INTEGER | ||||||
| FileModified | REAL | FileModified | Property Get/Let | ||||
| TrackModified | REAL | ||||||
| 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 | ||||
| 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 |
