Songs table: Difference between revisions

From MediaMonkey Wiki
Jump to navigation Jump to search
No edit summary
({{DatabaseTablesList}}, formattting, added missing Extension field)
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{DatabaseTablesList}}
== Fields ==
== Fields ==
{| border="1"
{| border="1"
Line 11: Line 12:
! SongData Description
! SongData Description
|-
|-
| '''ID'''<span id="ID"></span>
| '''ID'''
| INTEGER
| INTEGER
| AUTOINCREMENT (1 to inf.)
| AUTOINCREMENT (1 to inf.)
Line 20: Line 21:
|
|
|-
|-
| Artist<span id="Artist"></span>
| '''Artist'''
| TEXT
| TEXT
|  
|  
Line 29: Line 30:
|
|
|-
|-
| IDAlbum<span id="IDAlbum"></span>
| '''IDAlbum'''
| INTEGER
| INTEGER
|  
|  
Line 38: Line 39:
|
|
|-
|-
| Album<span id="Album"></span>
| '''Album'''
| TEXT
| TEXT
|  
|  
Line 47: Line 48:
|
|
|-
|-
| AlbumArtist<span id="AlbumArtist"></span>
| '''AlbumArtist'''
| TEXT
| TEXT
|  
|  
Line 56: Line 57:
|
|
|-
|-
| DiscNumber<span id="DiscNumber"></span>
| '''DiscNumber'''
| TEXT
| TEXT
|  
|  
Line 65: Line 66:
|
|
|-
|-
| TrackNumber<span id="TrackNumber"></span>
| '''TrackNumber'''
| TEXT
| TEXT
|  
|  
Line 74: Line 75:
|
|
|-
|-
| SongTitle<span id="SongTitle"></span>
| '''SongTitle'''
| TEXT
| TEXT
|  
|  
Line 83: Line 84:
|
|
|-
|-
| SongPath<span id="SongPath"></span>
| '''SongPath'''
| TEXT
| TEXT
|  
|  
Line 92: Line 93:
|
|
|-
|-
| Year<span id="Year"></span>
| '''Extension'''
| TEXT*
| 5 characters max
|
|
|
|
|
|-
| '''Year'''
| INTEGER
| INTEGER
|  
| 2010
|  
|  
|
|
Line 101: Line 111:
|
|
|-
|-
| Genre<span id="Genre"></span>
| '''Date'''
| INTEGER
| 20100930
|
|
|
|
|
|-
| '''Genre'''
| TEXT
| TEXT
|  
|  
Line 110: Line 129:
|
|
|-
|-
| FileLength<span id="FileLength"></span>
| '''FileLength'''
| INTEGER
| INTEGER
|  
|  
Line 119: Line 138:
|
|
|-
|-
| SongLength<span id="SongLength"></span>
| '''SongLength'''
| INTEGER
| INTEGER
|  
|  
Line 128: Line 147:
|
|
|-
|-
| IDMedia<span id="IDMedia"></span>
| '''IDMedia'''
| INTEGER
| INTEGER
|  
|  
Line 137: Line 156:
|
|
|-
|-
| CacheStatus<span id="CacheStatus"></span>
| '''CacheStatus'''
| INTEGER
| INTEGER
|  
|  
Line 146: Line 165:
|
|
|-
|-
| CacheName<span id="CacheName"></span>
| '''CacheName'''
| TEXT
| TEXT
|  
|  
Line 155: Line 174:
|
|
|-
|-
| Rating<span id="Rating"></span>
| '''Rating'''
| INTEGER
| INTEGER
|  
|  
Line 164: Line 183:
|
|
|-
|-
| Bitrate<span id="Bitrate"></span>
| '''Bitrate'''
| INTEGER
| INTEGER
|  
|  
Line 173: Line 192:
|
|
|-
|-
| Seekable<span id="Seekable"></span>
| '''TrackType'''
| INTEGER
| INTEGER
| Music = 0, Podcast = 1, Audiobook = 2
| Added in version 3.1
|
|
|
|
|-
| '''IDEpisode'''
| INTEGER
| Corresponds to PodcastsEpisodes.ID
| Added in version 3.1
|
|  
|  
|  
|  
|
|
| [[ISDBSongData::isBookmarkable |isBookmarkable ]]
| Property Get/Let
| To be confirmed
|-
|-
| Broadcast<span id="Broadcast"></span>
| '''Broadcast'''
| INTEGER
| INTEGER
|  
|  
Line 191: Line 219:
|
|
|-
|-
| PreviewState<span id="PreviewState"></span>
| '''PreviewState'''
| INTEGER
| INTEGER
|  
|  
Line 200: Line 228:
|
|
|-
|-
| PreviewName<span id="PreviewName"></span>
| '''PreviewName'''
| TEXT
| TEXT
|  
|  
Line 209: Line 237:
|
|
|-
|-
| PreviewStartTime<span id="PreviewStartTime"></span>
| '''PreviewStartTime'''
| INTEGER
| INTEGER
|  
|  
Line 218: Line 246:
|
|
|-
|-
| PreviewLength<span id="PreviewLength"></span>
| '''PreviewLength'''
| INTEGER
| INTEGER
|  
|  
Line 227: Line 255:
|
|
|-
|-
| Author<span id="Author"></span>
| '''Author'''
| TEXT
| TEXT
|  
|  
Line 236: Line 264:
|
|
|-
|-
| SamplingFrequency<span id="SamplingFrequency"></span>
| '''SamplingFrequency'''
| INTEGER
| INTEGER
|  
|  
Line 245: Line 273:
|
|
|-
|-
| Stereo<span id="Stereo"></span>
| '''Stereo'''
| INTEGER
| INTEGER
|  
|  
Line 254: Line 282:
|
|
|-
|-
| Copyrighted<span id="Copyrighted"></span>
| '''Copyrighted'''
| INTEGER
| INTEGER
|  
|  
Line 263: Line 291:
|
|
|-
|-
| Original<span id="Original"></span>
| '''Original'''
| INTEGER
| INTEGER
|  
|  
Line 272: Line 300:
|
|
|-
|-
| VBR<span id="VBR"></span>
| '''VBR'''
| INTEGER
| INTEGER
|  
|  
Line 281: Line 309:
|
|
|-
|-
| BPM<span id="BPM"></span>
| '''BPM'''
| INTEGER
| INTEGER
|  
|  
Line 290: Line 318:
|
|
|-
|-
| SignType<span id="SignType"></span>
| '''SignType'''
| INTEGER
| INTEGER
|  
|  
Line 299: Line 327:
|
|
|-
|-
| SignPart1<span id="SignPart1"></span>
| '''SignPart1'''
| INTEGER
| INTEGER
|  
|  
Line 308: Line 336:
|
|
|-
|-
| SignPart2<span id="SignPart2"></span>
| '''SignPart2'''
| INTEGER
| INTEGER
|  
|  
Line 317: Line 345:
|
|
|-
|-
| SignPart3<span id="SignPart3"></span>
| '''SignPart3'''
| INTEGER
| INTEGER
|  
|  
Line 326: Line 354:
|
|
|-
|-
| SignPart4<span id="SignPart4"></span>
| '''SignPart4'''
| INTEGER
| INTEGER
|  
|  
Line 335: Line 363:
|
|
|-
|-
| PlayCounter<span id="PlayCounter"></span>
| '''PlayCounter'''
| INTEGER
| INTEGER
|  
|  
Line 344: Line 372:
|
|
|-
|-
| LastTimePlayed<span id="LastTimePlayed"></span>
| '''LastTimePlayed'''
| REAL
| REAL
|  
| UTC as Delphi TDateTime
|  
|  
|
|
Line 353: Line 381:
|
|
|-
|-
| AudioCDTrack<span id="AudioCDTrack"></span>
| '''LastTimeSkipped'''
| REAL
| UTC as Delphi TDateTime
| Added in version 5.1
|
|
|
|
|-
| '''AudioCDTrack'''
| INTEGER
| INTEGER
|  
|  
Line 362: Line 399:
|
|
|-
|-
| FileModified<span id="FileModified"></span>
| '''FileModified'''
| REAL
| REAL
|  
| UTC as Delphi TDateTime
|  
|  
|
|
Line 371: Line 408:
|
|
|-
|-
| TrackModified<span id="TrackModified"></span>
| '''TrackModified'''
| REAL
| REAL
| UTC as Delphi TDateTime
|  
|  
|
|
|
|
|
Line 380: Line 417:
|
|
|-
|-
| MaxSample<span id="MaxSample"></span>
| '''ArtworkModified'''
| REAL
| UTC as Delphi TDateTime
| Added in version 5.0
|
|
|
|
|-
| '''MaxSample'''
| REAL
| REAL
|  
|  
Line 389: Line 435:
|
|
|-
|-
| NormalizeTrack<span id="NormalizeTrack"></span>
| '''NormalizeTrack'''
| REAL
| REAL
|  
|  
|  
| Track gain value (dB)
|
|
| [[ISDBSongData::Leveling |Leveling ]]
| [[ISDBSongData::Leveling |Leveling ]]
Line 398: Line 444:
|
|
|-
|-
| NormalizeAlbum<span id="NormalizeAlbum"></span>
| '''NormalizeAlbum'''
| REAL
| REAL
|  
|  
|  
| Album gain value (dB)
|
|
| [[ISDBSongData::LevelingAlbum |LevelingAlbum ]]
| [[ISDBSongData::LevelingAlbum |LevelingAlbum ]]
Line 407: Line 453:
|
|
|-
|-
| Custom1<span id="Custom1"></span>
| '''Custom1'''
| TEXT
| TEXT
|  
|  
Line 416: Line 462:
|
|
|-
|-
| Custom2<span id="Custom2"></span>
| '''Custom2'''
| TEXT
| TEXT
|  
|  
Line 425: Line 471:
|
|
|-
|-
| Custom3<span id="Custom3"></span>
| '''Custom3'''
| TEXT
| TEXT
|  
|  
Line 434: Line 480:
|
|
|-
|-
| Custom4<span id="Custom4"></span>
| '''Custom4'''
| TEXT
| TEXT
|  
|  
Line 443: Line 489:
|
|
|-
|-
| Custom5<span id="Custom5"></span>
| '''Custom5'''
| TEXT
| TEXT
|  
|  
Line 452: Line 498:
|
|
|-
|-
| DateAdded<span id="DateAdded"></span>
| '''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
| REAL
|  
| UTC as Delphi TDateTime
|  
|  
|
|
Line 461: Line 552:
|
|
|-
|-
| OrigFileLength<span id="OrigFileLength"></span>
| '''OrigFileLength'''
| INTEGER
| INTEGER
|  
|  
Line 470: Line 561:
|
|
|-
|-
| PreGap<span id="PreGap"></span>
| '''PreGap'''
| INTEGER
| INTEGER
|  
|  
Line 479: Line 570:
|
|
|-
|-
| PostGap<span id="PostGap"></span>
| '''PostGap'''
| INTEGER
| INTEGER
|  
|  
Line 488: Line 579:
|
|
|-
|-
| TotalSamples<span id="TotalSamples"></span>
| '''TotalSamples'''
| INTEGER
| INTEGER
|  
|  
Line 497: Line 588:
|
|
|-
|-
| PlaybackPos<span id="PlaybackPos"></span>
| '''PlaybackPos'''
| INTEGER
| INTEGER
|  
|  
Line 506: Line 597:
| To be confirmed
| To be confirmed
|-
|-
| GaplessBytes<span id="GaplessBytes"></span>
| '''GaplessBytes'''
| INTEGER
| INTEGER
|  
|  
Line 515: Line 606:
|
|
|-
|-
| IDFolder<span id="IDFolder"></span>
| '''IDFolder'''
| INTEGER
| INTEGER
|  
|  
Line 524: Line 615:
|
|
|-
|-
| Copyright<span id="Copyright"></span>
| '''Copyright'''
| TEXT
| TEXT
|  
|  
Line 533: Line 624:
|
|
|-
|-
| Publisher<span id="Publisher"></span>
| '''Publisher'''
| TEXT
| TEXT
|  
|  
Line 542: Line 633:
|
|
|-
|-
| Encoder<span id="Encoder"></span>
| '''Encoder'''
| TEXT
| TEXT
|  
|  
Line 551: Line 642:
|
|
|-
|-
| EncodedBy<span id="EncodedBy"></span>
| '''EncodedBy'''
| TEXT
| TEXT
|  
|  
Line 560: Line 651:
|
|
|-
|-
| Lyricist<span id="Lyricist"></span>
| '''Lyricist'''
| TEXT
| TEXT
|  
|  
Line 569: Line 660:
|
|
|-
|-
| Band<span id="Band"></span>
| '''Band'''
| TEXT
| TEXT
|  
|  
Line 578: Line 669:
|
|
|-
|-
| Conductor<span id="Conductor"></span>
| '''Conductor'''
| TEXT
| TEXT
|  
|  
Line 587: Line 678:
|
|
|-
|-
| Remixer<span id="Remixer"></span>
| '''Remixer'''
| TEXT
| TEXT
|  
|  
Line 596: Line 687:
|
|
|-
|-
| InvolvedPeople<span id="InvolvedPeople"></span>
| '''InvolvedPeople'''
| TEXT
| TEXT
|  
|  
Line 605: Line 696:
|
|
|-
|-
| OrigTitle<span id="OrigTitle"></span>
| '''OrigTitle'''
| TEXT
| TEXT
|  
|  
Line 614: Line 705:
|
|
|-
|-
| OrigArtist<span id="OrigArtist"></span>
| '''OrigArtist'''
| TEXT
| TEXT
|  
|  
Line 623: Line 714:
|
|
|-
|-
| OrigLyricist<span id="OrigLyricist"></span>
| '''OrigLyricist'''
| TEXT
| TEXT
|  
|  
Line 632: Line 723:
|
|
|-
|-
| GroupDesc<span id="GroupDesc"></span>
| '''GroupDesc'''
| TEXT
| TEXT
|  
|  
Line 641: Line 732:
|
|
|-
|-
| SubTitle<span id="SubTitle"></span>
| '''SubTitle'''
| TEXT
| TEXT
|  
|  
Line 650: Line 741:
|
|
|-
|-
| ISRC<span id="ISRC"></span>
| '''ISRC'''
| TEXT
| TEXT
|  
|  
Line 659: Line 750:
|
|
|-
|-
| InitialKey<span id="InitialKey"></span>
| '''cuePath'''
| TEXT
|
| Added in version 5.1
|
|
|
|
|-
| '''InitialKey'''
| TEXT
| TEXT
|  
|  
Line 668: Line 768:
|
|
|-
|-
| Language<span id="Language"></span>
| '''Language'''
| TEXT
| TEXT
|  
|  
Line 677: Line 777:
|
|
|-
|-
| MediaType<span id="MediaType"></span>
| '''MediaType'''
| TEXT
| TEXT
|  
|  
Line 686: Line 786:
|
|
|-
|-
| RatingString<span id="RatingString"></span>
| '''RatingString'''
| TEXT
| TEXT
|  
|  
Line 695: Line 795:
|
|
|-
|-
| WebCommercial<span id="WebCommercial"></span>
| '''WebCommercial'''
| TEXT
| TEXT
|  
|  
Line 704: Line 804:
|
|
|-
|-
| WebCopyright<span id="WebCopyright"></span>
| '''WebCopyright'''
| TEXT
| TEXT
|  
|  
Line 713: Line 813:
|
|
|-
|-
| WebFilepage<span id="WebFilepage"></span>
| '''WebFilepage'''
| TEXT
| TEXT
|  
|  
Line 722: Line 822:
|
|
|-
|-
| WebArtist<span id="WebArtist"></span>
| '''WebArtist'''
| TEXT
| TEXT
|  
|  
Line 731: Line 831:
|
|
|-
|-
| WebSource<span id="WebSource"></span>
| '''WebSource'''
| TEXT
| TEXT
|  
|  
Line 740: Line 840:
|
|
|-
|-
| WebRadio<span id="WebRadio"></span>
| '''WebRadio'''
| TEXT
| TEXT
|  
|  
Line 749: Line 849:
|
|
|-
|-
| WebPayment<span id="WebPayment"></span>
| '''WebPayment'''
| TEXT
| TEXT
|  
|  
Line 758: Line 858:
|
|
|-
|-
| WebPublisher<span id="WebPublisher"></span>
| '''WebPublisher'''
| TEXT
| TEXT
|  
|  
Line 767: Line 867:
|
|
|-
|-
| WebUser<span id="WebUser"></span>
| '''WebUser'''
| TEXT
| TEXT
|  
|  
Line 776: Line 876:
|
|
|-
|-
| OrigYear<span id="OrigYear"></span>
| '''OrigYear'''
| INTEGER
| INTEGER
|  
|  
Line 785: Line 885:
|
|
|-
|-
| Tempo<span id="Tempo"></span>
| '''Tempo'''
| TEXT
| TEXT
|  
|  
Line 794: Line 894:
|
|
|-
|-
| Mood<span id="Mood"></span>
| '''Mood'''
| TEXT
| TEXT
|  
|  
Line 803: Line 903:
|
|
|-
|-
| Occasion<span id="Occasion"></span>
| '''Occasion'''
| TEXT
| TEXT
|  
|  
Line 812: Line 912:
|
|
|-
|-
| Quality<span id="Quality"></span>
| '''Quality'''
| TEXT
| TEXT
|  
|  
Line 821: Line 921:
|
|
|-
|-
| Lyrics<span id="Lyrics"></span>
| '''Lyrics'''
| TEXT
| TEXT
|  
|  
Line 830: Line 930:
|
|
|-
|-
| Comment<span id="Comment"></span>
| '''Comment'''
| TEXT
| TEXT
|  
|  
Line 837: Line 937:
| [[ISDBSongData::Comment |Comment ]]
| [[ISDBSongData::Comment |Comment ]]
| Property Get/Let  
| Property Get/Let  
|
|-
| '''ExtendedTags'''
| TEXT
|
| Added in version 5.0
|
|
|
|
|
|}
|}

Latest revision as of 16:45, 11 April 2024

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
Retrieved from "https://www.mediamonkey.com/wiki/index.php?title=Songs_table&oldid=11394"