Field

Type

Description

From Tags?

id

int

Unique ID for the song

n

path

string

Full path to the song

n

fname

string

file name of the song, less the path

n

title

string

Title of the song, or file name less extension if no title data

y

artist

string

Song artist

y

album

string

Song album

y

album_artist

string

Album artist

y

genre

string

Song genre

y

comment

string

Song comment

y

type

string

An iTunes field: one of mp4a, wav, aif, wma, mp4v, ogg, flac, or mpc

n

composer

string

Composer

y

orchestra

string

Orchestra

y

conductor

string

Conductor

y

grouping

string

Grouping

y

url

string

URL of the radio station if the data_kind is 1

n

bitrate

int

Bitrate of song

n

samplerate

int

Sample rate of song

n

song_length

int

Length of song (duration) in ms

n

file_size

int

Size of file in bytes

n

year

string

Year of song

y

track

int

Track number of song

y

total_tracks

int

Tracks in album

y

disc

int

Disc number of this album

y

total_discs

int

Total discs in multi-disc set

y

bpm

int

Beats per minute

y

compilation

int

Is the song part of a compilation?

y

rating

int

User rating, 0-100 with 20,40,60,80,100 being 1-5 stars in iTunes

y

play_count

int

Number of times this track has been played

n

data_kind

int

iTunes field: 0 for music files, 1 for URLs (internet radio stations)

n

item_kind

int

iTunes field: Unknown. Set to 2

n

description

string

iTunes field: Description of media type: "MPEG Audio File", for example

n

time_added

int/date

Unix time_t of the time added to DB

n

time_modified

int/date

Unix time_t of modification time of the file

n

time_played

int/date

Unix time_t of the last time this song was played

n

db_timestamp

int/date

Unix time_t of the last time this song was indexed

n

disabled

int

iTunes field: the "checkbox" on an item. 1 to disable, 0 to enable

n

sample_count

int

Number of samples in song

n

force_update

int

Force a re-index next scan? 0=no, 1=yes

n

codectype

int

iTunes field: one of mp4a, mpeg, wav, aif, wma, mp4v, ogg, flac, or mpc

n

idx

int

Index, if one physical file contains multiple songs (like an iso or bin/cue). Always 0 currently

n

has_video

int

Is the item video? 1=yes, 0=no

n

contentrating

int

Unused

n

bits_per_sample

int

Bits per sample

n