Difference between revisions of "Songs table"

From MediaMonkey Wiki
Jump to: navigation, search
(Added Anchors to all fields)
(Fields)
 
(2 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
! Possible Values
 
! Possible Values
 
! Description
 
! Description
 +
!
 +
! SongData Name
 +
! SongData Type
 +
! SongData Description
 
|-
 
|-
 
| '''ID'''<span id="ID"></span>
 
| '''ID'''<span id="ID"></span>
Line 11: Line 15:
 
| AUTOINCREMENT (1 to inf.)
 
| AUTOINCREMENT (1 to inf.)
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::ID |ID ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Artist<span id="Artist"></span>
 
| Artist<span id="Artist"></span>
Line 16: Line 24:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::ArtistName |ArtistName ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| IDAlbum<span id="IDAlbum"></span>
 
| IDAlbum<span id="IDAlbum"></span>
Line 21: Line 33:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| Album<span id="Album"></span>
 
| Album<span id="Album"></span>
Line 26: Line 42:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::AlbumName |AlbumName ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| AlbumArtist<span id="AlbumArtist"></span>
 
| AlbumArtist<span id="AlbumArtist"></span>
Line 31: Line 51:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::AlbumArtistName |AlbumArtistName ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| DiscNumber<span id="DiscNumber"></span>
 
| DiscNumber<span id="DiscNumber"></span>
Line 36: Line 60:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::DiscNumberStr |DiscNumberStr ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| TrackNumber<span id="TrackNumber"></span>
 
| TrackNumber<span id="TrackNumber"></span>
Line 41: Line 69:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::TrackOrderStr |TrackOrderStr ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| SongTitle<span id="SongTitle"></span>
 
| SongTitle<span id="SongTitle"></span>
Line 46: Line 78:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Title |Title ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| SongPath<span id="SongPath"></span>
 
| SongPath<span id="SongPath"></span>
Line 51: Line 87:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Path |Path ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Year<span id="Year"></span>
 
| Year<span id="Year"></span>
 
| INTEGER
 
| INTEGER
 +
| 2010
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Year |Year ]]
 +
| Property Get/Let
 +
|
 +
|-
 +
| Date<span id="Date"></span>
 +
| INTEGER
 +
| 20100930
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| Genre<span id="Genre"></span>
 
| Genre<span id="Genre"></span>
Line 61: Line 114:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Genre |Genre ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| FileLength<span id="FileLength"></span>
 
| FileLength<span id="FileLength"></span>
Line 66: Line 123:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::FileLength |FileLength ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| SongLength<span id="SongLength"></span>
 
| SongLength<span id="SongLength"></span>
Line 71: Line 132:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::SongLength |SongLength ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| IDMedia<span id="IDMedia"></span>
 
| IDMedia<span id="IDMedia"></span>
Line 76: Line 141:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Media |Media ]]
 +
| Property Get
 +
|
 
|-
 
|-
 
| CacheStatus<span id="CacheStatus"></span>
 
| CacheStatus<span id="CacheStatus"></span>
Line 81: Line 150:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Cached |Cached ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| CacheName<span id="CacheName"></span>
 
| CacheName<span id="CacheName"></span>
Line 86: Line 159:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::CachedPath |CachedPath ]]
 +
| Property Get
 +
|
 
|-
 
|-
 
| Rating<span id="Rating"></span>
 
| Rating<span id="Rating"></span>
Line 91: Line 168:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Rating |Rating ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Bitrate<span id="Bitrate"></span>
 
| Bitrate<span id="Bitrate"></span>
Line 96: Line 177:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Bitrate |Bitrate ]]
 +
| Property Get/Let
 +
|
 +
|-
 +
| TrackType<span id="TrackType"></span>
 +
| INTEGER
 +
| Music = 0, Podcast = 1, Audiobook = 2
 +
| Added in version 3.1
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
| Seekable<span id="Seekable"></span>
+
| 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 106: Line 204:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| PreviewState<span id="PreviewState"></span>
 
| PreviewState<span id="PreviewState"></span>
Line 111: Line 213:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| PreviewName<span id="PreviewName"></span>
 
| PreviewName<span id="PreviewName"></span>
Line 116: Line 222:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::PreviewPath |PreviewPath ]]
 +
| Property Get
 +
|
 
|-
 
|-
 
| PreviewStartTime<span id="PreviewStartTime"></span>
 
| PreviewStartTime<span id="PreviewStartTime"></span>
Line 121: Line 231:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| PreviewLength<span id="PreviewLength"></span>
 
| PreviewLength<span id="PreviewLength"></span>
Line 126: Line 240:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| Author<span id="Author"></span>
 
| Author<span id="Author"></span>
Line 131: Line 249:
 
|  
 
|  
 
| The Composer of the Song
 
| The Composer of the Song
 +
|
 +
| [[ISDBSongData::Author |Author ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| SamplingFrequency<span id="SamplingFrequency"></span>
 
| SamplingFrequency<span id="SamplingFrequency"></span>
Line 136: Line 258:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::SampleRate |SampleRate ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Stereo<span id="Stereo"></span>
 
| Stereo<span id="Stereo"></span>
Line 141: Line 267:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Channels |Channels ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Copyrighted<span id="Copyrighted"></span>
 
| Copyrighted<span id="Copyrighted"></span>
Line 146: Line 276:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| Original<span id="Original"></span>
 
| Original<span id="Original"></span>
Line 151: Line 285:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| VBR<span id="VBR"></span>
 
| VBR<span id="VBR"></span>
Line 156: Line 294:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::VBR |VBR ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| BPM<span id="BPM"></span>
 
| BPM<span id="BPM"></span>
Line 161: Line 303:
 
|  
 
|  
 
| Beats Per Minute
 
| Beats Per Minute
 +
|
 +
| [[ISDBSongData::BPM |BPM ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| SignType<span id="SignType"></span>
 
| SignType<span id="SignType"></span>
Line 166: Line 312:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| SignPart1<span id="SignPart1"></span>
 
| SignPart1<span id="SignPart1"></span>
Line 171: Line 321:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| SignPart2<span id="SignPart2"></span>
 
| SignPart2<span id="SignPart2"></span>
Line 176: Line 330:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| SignPart3<span id="SignPart3"></span>
 
| SignPart3<span id="SignPart3"></span>
Line 181: Line 339:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| SignPart4<span id="SignPart4"></span>
 
| SignPart4<span id="SignPart4"></span>
Line 186: Line 348:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| PlayCounter<span id="PlayCounter"></span>
 
| PlayCounter<span id="PlayCounter"></span>
Line 191: Line 357:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::PlayCounter |PlayCounter ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| LastTimePlayed<span id="LastTimePlayed"></span>
 
| LastTimePlayed<span id="LastTimePlayed"></span>
 
| REAL
 
| REAL
 +
| UTC as Delphi TDateTime
 
|  
 
|  
|  
+
|
 +
| [[ISDBSongData::LastPlayed |LastPlayed ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| AudioCDTrack<span id="AudioCDTrack"></span>
 
| AudioCDTrack<span id="AudioCDTrack"></span>
Line 201: Line 375:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| FileModified<span id="FileModified"></span>
 
| FileModified<span id="FileModified"></span>
 
| REAL
 
| REAL
 +
| UTC as Delphi TDateTime
 
|  
 
|  
|  
+
|
 +
| [[ISDBSongData::FileModified |FileModified ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| TrackModified<span id="TrackModified"></span>
 
| TrackModified<span id="TrackModified"></span>
 
| REAL
 
| REAL
 +
| UTC as Delphi TDateTime
 
|  
 
|  
|  
+
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| MaxSample<span id="MaxSample"></span>
 
| MaxSample<span id="MaxSample"></span>
Line 216: Line 402:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| NormalizeTrack<span id="NormalizeTrack"></span>
 
| NormalizeTrack<span id="NormalizeTrack"></span>
 
| REAL
 
| REAL
 
|  
 
|  
|  
+
| Track gain value (dB)
 +
|
 +
| [[ISDBSongData::Leveling |Leveling ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| NormalizeAlbum<span id="NormalizeAlbum"></span>
 
| NormalizeAlbum<span id="NormalizeAlbum"></span>
 
| REAL
 
| REAL
 
|  
 
|  
|  
+
| Album gain value (dB)
 +
|
 +
| [[ISDBSongData::LevelingAlbum |LevelingAlbum ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Custom1<span id="Custom1"></span>
 
| Custom1<span id="Custom1"></span>
Line 231: Line 429:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Custom1 |Custom1 ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Custom2<span id="Custom2"></span>
 
| Custom2<span id="Custom2"></span>
Line 236: Line 438:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Custom2 |Custom2 ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Custom3<span id="Custom3"></span>
 
| Custom3<span id="Custom3"></span>
Line 241: Line 447:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Custom3 |Custom3 ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Custom4<span id="Custom4"></span>
 
| Custom4<span id="Custom4"></span>
Line 246: Line 456:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Custom4 |Custom4 ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Custom5<span id="Custom5"></span>
 
| Custom5<span id="Custom5"></span>
Line 251: Line 465:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Custom5 |Custom5 ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| DateAdded<span id="DateAdded"></span>
 
| DateAdded<span id="DateAdded"></span>
 
| REAL
 
| REAL
 +
| UTC as Delphi TDateTime
 
|  
 
|  
|  
+
|
 +
| [[ISDBSongData::DateAdded |DateAdded ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| OrigFileLength<span id="OrigFileLength"></span>
 
| OrigFileLength<span id="OrigFileLength"></span>
Line 261: Line 483:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| PreGap<span id="PreGap"></span>
 
| PreGap<span id="PreGap"></span>
Line 266: Line 492:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::PreGap |PreGap ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| PostGap<span id="PostGap"></span>
 
| PostGap<span id="PostGap"></span>
Line 271: Line 501:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::PostGap |PostGap ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| TotalSamples<span id="TotalSamples"></span>
 
| TotalSamples<span id="TotalSamples"></span>
Line 276: Line 510:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::TotalSamples |TotalSamples ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| PlaybackPos<span id="PlaybackPos"></span>
 
| PlaybackPos<span id="PlaybackPos"></span>
Line 281: Line 519:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Bookmark |Bookmark ]]
 +
| Property Get/Let
 +
| To be confirmed
 
|-
 
|-
 
| GaplessBytes<span id="GaplessBytes"></span>
 
| GaplessBytes<span id="GaplessBytes"></span>
Line 286: Line 528:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::GaplessBytes |GaplessBytes ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| IDFolder<span id="IDFolder"></span>
 
| IDFolder<span id="IDFolder"></span>
Line 291: Line 537:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| Copyright<span id="Copyright"></span>
 
| Copyright<span id="Copyright"></span>
Line 296: Line 546:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Copyright |Copyright ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Publisher<span id="Publisher"></span>
 
| Publisher<span id="Publisher"></span>
Line 301: Line 555:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Publisher |Publisher ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Encoder<span id="Encoder"></span>
 
| Encoder<span id="Encoder"></span>
Line 306: Line 564:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Encoder |Encoder ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| EncodedBy<span id="EncodedBy"></span>
 
| EncodedBy<span id="EncodedBy"></span>
Line 311: Line 573:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| Lyricist<span id="Lyricist"></span>
 
| Lyricist<span id="Lyricist"></span>
Line 316: Line 582:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Lyricist |Lyricist ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Band<span id="Band"></span>
 
| Band<span id="Band"></span>
Line 321: Line 591:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Band |Band ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Conductor<span id="Conductor"></span>
 
| Conductor<span id="Conductor"></span>
Line 326: Line 600:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Conductor |Conductor ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Remixer<span id="Remixer"></span>
 
| Remixer<span id="Remixer"></span>
Line 331: Line 609:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| InvolvedPeople<span id="InvolvedPeople"></span>
 
| InvolvedPeople<span id="InvolvedPeople"></span>
Line 336: Line 618:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::InvolvedPeople |InvolvedPeople ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| OrigTitle<span id="OrigTitle"></span>
 
| OrigTitle<span id="OrigTitle"></span>
Line 341: Line 627:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::OriginalTitle |OriginalTitle ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| OrigArtist<span id="OrigArtist"></span>
 
| OrigArtist<span id="OrigArtist"></span>
Line 346: Line 636:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::OriginalArtist |OriginalArtist ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| OrigLyricist<span id="OrigLyricist"></span>
 
| OrigLyricist<span id="OrigLyricist"></span>
Line 351: Line 645:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::OriginalLyricist |OriginalLyricist ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| GroupDesc<span id="GroupDesc"></span>
 
| GroupDesc<span id="GroupDesc"></span>
Line 356: Line 654:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Grouping |Grouping ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| SubTitle<span id="SubTitle"></span>
 
| SubTitle<span id="SubTitle"></span>
Line 361: Line 663:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| ISRC<span id="ISRC"></span>
 
| ISRC<span id="ISRC"></span>
Line 366: Line 672:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::ISRC |ISRC ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| InitialKey<span id="InitialKey"></span>
 
| InitialKey<span id="InitialKey"></span>
Line 371: Line 681:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| Language<span id="Language"></span>
 
| Language<span id="Language"></span>
Line 376: Line 690:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| MediaType<span id="MediaType"></span>
 
| MediaType<span id="MediaType"></span>
Line 381: Line 699:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| RatingString<span id="RatingString"></span>
 
| RatingString<span id="RatingString"></span>
Line 386: Line 708:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebCommercial<span id="WebCommercial"></span>
 
| WebCommercial<span id="WebCommercial"></span>
Line 391: Line 717:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebCopyright<span id="WebCopyright"></span>
 
| WebCopyright<span id="WebCopyright"></span>
Line 396: Line 726:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebFilepage<span id="WebFilepage"></span>
 
| WebFilepage<span id="WebFilepage"></span>
Line 401: Line 735:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebArtist<span id="WebArtist"></span>
 
| WebArtist<span id="WebArtist"></span>
Line 406: Line 744:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebSource<span id="WebSource"></span>
 
| WebSource<span id="WebSource"></span>
Line 411: Line 753:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebRadio<span id="WebRadio"></span>
 
| WebRadio<span id="WebRadio"></span>
Line 416: Line 762:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebPayment<span id="WebPayment"></span>
 
| WebPayment<span id="WebPayment"></span>
Line 421: Line 771:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebPublisher<span id="WebPublisher"></span>
 
| WebPublisher<span id="WebPublisher"></span>
Line 426: Line 780:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| WebUser<span id="WebUser"></span>
 
| WebUser<span id="WebUser"></span>
Line 431: Line 789:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
|
 +
|
 +
|
 
|-
 
|-
 
| OrigYear<span id="OrigYear"></span>
 
| OrigYear<span id="OrigYear"></span>
Line 436: Line 798:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::OriginalYear |OriginalYear ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Tempo<span id="Tempo"></span>
 
| Tempo<span id="Tempo"></span>
Line 441: Line 807:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Tempo |Tempo ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Mood<span id="Mood"></span>
 
| Mood<span id="Mood"></span>
Line 446: Line 816:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Mood |Mood ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Occasion<span id="Occasion"></span>
 
| Occasion<span id="Occasion"></span>
Line 451: Line 825:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Occasion |Occasion ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Quality<span id="Quality"></span>
 
| Quality<span id="Quality"></span>
Line 456: Line 834:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Quality |Quality ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Lyrics<span id="Lyrics"></span>
 
| Lyrics<span id="Lyrics"></span>
Line 461: Line 843:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Lyrics |Lyrics ]]
 +
| Property Get/Let
 +
|
 
|-
 
|-
 
| Comment<span id="Comment"></span>
 
| Comment<span id="Comment"></span>
Line 466: Line 852:
 
|  
 
|  
 
|  
 
|  
 +
|
 +
| [[ISDBSongData::Comment |Comment ]]
 +
| Property Get/Let
 +
|
 
|}
 
|}

Latest revision as of 04:21, 29 January 2012

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 UTC as Delphi TDateTime LastPlayed Property Get/Let
AudioCDTrack INTEGER
FileModified REAL UTC as Delphi TDateTime FileModified Property Get/Let
TrackModified REAL UTC as Delphi TDateTime
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 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
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