Songs table: Difference between revisions

From MediaMonkey Wiki
Jump to navigation Jump to search
No edit summary
(Added Anchors to all fields)
Line 7: Line 7:
! Description
! Description
|-
|-
| '''ID'''
| '''ID'''<span id="ID"></span>
| INTEGER
| INTEGER
| AUTOINCREMENT (1 to inf.)
| AUTOINCREMENT (1 to inf.)
|  
|  
|-
|-
| Artist
| Artist<span id="Artist"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| IDAlbum
| IDAlbum<span id="IDAlbum"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Album
| Album<span id="Album"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| AlbumArtist
| AlbumArtist<span id="AlbumArtist"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| DiscNumber
| DiscNumber<span id="DiscNumber"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| TrackNumber
| TrackNumber<span id="TrackNumber"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| SongTitle
| SongTitle<span id="SongTitle"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| SongPath
| SongPath<span id="SongPath"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Year
| Year<span id="Year"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Genre
| Genre<span id="Genre"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| FileLength
| FileLength<span id="FileLength"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| SongLength
| SongLength<span id="SongLength"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| IDMedia
| IDMedia<span id="IDMedia"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| CacheStatus
| CacheStatus<span id="CacheStatus"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| CacheName
| CacheName<span id="CacheName"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Rating
| Rating<span id="Rating"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Bitrate
| Bitrate<span id="Bitrate"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Seekable
| Seekable<span id="Seekable"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Broadcast
| Broadcast<span id="Broadcast"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| PreviewState
| PreviewState<span id="PreviewState"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| PreviewName
| PreviewName<span id="PreviewName"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| PreviewStartTime
| PreviewStartTime<span id="PreviewStartTime"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| PreviewLength
| PreviewLength<span id="PreviewLength"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Author
| Author<span id="Author"></span>
| TEXT
| TEXT
|  
|  
| The Composer of the Song
| The Composer of the Song
|-
|-
| SamplingFrequency
| SamplingFrequency<span id="SamplingFrequency"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Stereo
| Stereo<span id="Stereo"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Copyrighted
| Copyrighted<span id="Copyrighted"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Original
| Original<span id="Original"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| VBR
| VBR<span id="VBR"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| BPM
| BPM<span id="BPM"></span>
| INTEGER
| INTEGER
|  
|  
| Beats Per Minute
| Beats Per Minute
|-
|-
| SignType
| SignType<span id="SignType"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| SignPart1
| SignPart1<span id="SignPart1"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| SignPart2
| SignPart2<span id="SignPart2"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| SignPart3
| SignPart3<span id="SignPart3"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| SignPart4
| SignPart4<span id="SignPart4"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| PlayCounter
| PlayCounter<span id="PlayCounter"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| LastTimePlayed
| LastTimePlayed<span id="LastTimePlayed"></span>
| REAL
| REAL
|  
|  
|  
|  
|-
|-
| AudioCDTrack
| AudioCDTrack<span id="AudioCDTrack"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| FileModified
| FileModified<span id="FileModified"></span>
| REAL
| REAL
|  
|  
|  
|  
|-
|-
| TrackModified
| TrackModified<span id="TrackModified"></span>
| REAL
| REAL
|  
|  
|  
|  
|-
|-
| MaxSample
| MaxSample<span id="MaxSample"></span>
| REAL
| REAL
|  
|  
|  
|  
|-
|-
| NormalizeTrack
| NormalizeTrack<span id="NormalizeTrack"></span>
| REAL
| REAL
|  
|  
|  
|  
|-
|-
| NormalizeAlbum
| NormalizeAlbum<span id="NormalizeAlbum"></span>
| REAL
| REAL
|  
|  
|  
|  
|-
|-
| Custom1
| Custom1<span id="Custom1"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Custom2
| Custom2<span id="Custom2"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Custom3
| Custom3<span id="Custom3"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Custom4
| Custom4<span id="Custom4"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Custom5
| Custom5<span id="Custom5"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| DateAdded
| DateAdded<span id="DateAdded"></span>
| REAL
| REAL
|  
|  
|  
|  
|-
|-
| OrigFileLength
| OrigFileLength<span id="OrigFileLength"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| PreGap
| PreGap<span id="PreGap"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| PostGap
| PostGap<span id="PostGap"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| TotalSamples
| TotalSamples<span id="TotalSamples"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| PlaybackPos
| PlaybackPos<span id="PlaybackPos"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| GaplessBytes
| GaplessBytes<span id="GaplessBytes"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| IDFolder
| IDFolder<span id="IDFolder"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Copyright
| Copyright<span id="Copyright"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Publisher
| Publisher<span id="Publisher"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Encoder
| Encoder<span id="Encoder"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| EncodedBy
| EncodedBy<span id="EncodedBy"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Lyricist
| Lyricist<span id="Lyricist"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Band
| Band<span id="Band"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Conductor
| Conductor<span id="Conductor"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Remixer
| Remixer<span id="Remixer"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| InvolvedPeople
| InvolvedPeople<span id="InvolvedPeople"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| OrigTitle
| OrigTitle<span id="OrigTitle"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| OrigArtist
| OrigArtist<span id="OrigArtist"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| OrigLyricist
| OrigLyricist<span id="OrigLyricist"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| GroupDesc
| GroupDesc<span id="GroupDesc"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| SubTitle
| SubTitle<span id="SubTitle"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| ISRC
| ISRC<span id="ISRC"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| InitialKey
| InitialKey<span id="InitialKey"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Language
| Language<span id="Language"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| MediaType
| MediaType<span id="MediaType"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| RatingString
| RatingString<span id="RatingString"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebCommercial
| WebCommercial<span id="WebCommercial"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebCopyright
| WebCopyright<span id="WebCopyright"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebFilepage
| WebFilepage<span id="WebFilepage"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebArtist
| WebArtist<span id="WebArtist"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebSource
| WebSource<span id="WebSource"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebRadio
| WebRadio<span id="WebRadio"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebPayment
| WebPayment<span id="WebPayment"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebPublisher
| WebPublisher<span id="WebPublisher"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| WebUser
| WebUser<span id="WebUser"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| OrigYear
| OrigYear<span id="OrigYear"></span>
| INTEGER
| INTEGER
|  
|  
|  
|  
|-
|-
| Tempo
| Tempo<span id="Tempo"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Mood
| Mood<span id="Mood"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Occasion
| Occasion<span id="Occasion"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|-
|-
| Quality
| Quality<span id="Quality"></span>
| TEXT
| TEXT
|  
|  
Line 462: Line 462:
|  
|  
|-
|-
| Comment
| Comment<span id="Comment"></span>
| TEXT
| TEXT
|  
|  
|  
|  
|}
|}

Revision as of 07:24, 13 April 2008

Fields

Name Value Type Possible Values Description
ID INTEGER AUTOINCREMENT (1 to inf.)
Artist TEXT
IDAlbum INTEGER
Album TEXT
AlbumArtist TEXT
DiscNumber TEXT
TrackNumber TEXT
SongTitle TEXT
SongPath TEXT
Year INTEGER
Genre TEXT
FileLength INTEGER
SongLength INTEGER
IDMedia INTEGER
CacheStatus INTEGER
CacheName TEXT
Rating INTEGER
Bitrate INTEGER
Seekable INTEGER
Broadcast INTEGER
PreviewState INTEGER
PreviewName TEXT
PreviewStartTime INTEGER
PreviewLength INTEGER
Author TEXT The Composer of the Song
SamplingFrequency INTEGER
Stereo INTEGER
Copyrighted INTEGER
Original INTEGER
VBR INTEGER
BPM INTEGER Beats Per Minute
SignType INTEGER
SignPart1 INTEGER
SignPart2 INTEGER
SignPart3 INTEGER
SignPart4 INTEGER
PlayCounter INTEGER
LastTimePlayed REAL
AudioCDTrack INTEGER
FileModified REAL
TrackModified REAL
MaxSample REAL
NormalizeTrack REAL
NormalizeAlbum REAL
Custom1 TEXT
Custom2 TEXT
Custom3 TEXT
Custom4 TEXT
Custom5 TEXT
DateAdded REAL
OrigFileLength INTEGER
PreGap INTEGER
PostGap INTEGER
TotalSamples INTEGER
PlaybackPos INTEGER
GaplessBytes INTEGER
IDFolder INTEGER
Copyright TEXT
Publisher TEXT
Encoder TEXT
EncodedBy TEXT
Lyricist TEXT
Band TEXT
Conductor TEXT
Remixer TEXT
InvolvedPeople TEXT
OrigTitle TEXT
OrigArtist TEXT
OrigLyricist TEXT
GroupDesc TEXT
SubTitle TEXT
ISRC TEXT
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
Tempo TEXT
Mood TEXT
Occasion TEXT
Quality TEXT
Lyrics TEXT
Comment TEXT
Retrieved from "https://www.mediamonkey.com/wiki/index.php?title=Songs_table&oldid=3970"