Songs table: Difference between revisions

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