| id | integer | uniquely identifies a record |
| artist | text | performing artist |
| songtitle | text | title of the song |
| album | text | album the song appears on |
| fullcd | boolean | indicates whether all the songs are in the database |
| tracknr | integer | track number on the cd |
| genre | text | genre of the song |
| year | integer | year the song was published |
| comment | text | ID3 comment |
| length | integer | length of the song in seconds |
| sizekb | integer | size of the file in kilobytes |
| samprate | integer | sample rate |
| bitrate | integer | bitrate |
| lastmodified | date | last modification date |
| layer | boolean | MPEG layer |
| mode | text | Stereo mode |
| filename | text | filename on the media |
| path | text | relative path on the media |
| cdtitle | text | title of the media |
| dup | integer | indicates whether the song is a duplicate |
| cdup | integer | indicates whether the song is the first of a set of duplicates |
| rating | integer | a -good or bad- rating of the song |
| fav | integer | indicates a favorite status |
| ex | integer | indicates if the song was excluded |