Songs table

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
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
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