Songs table: Difference between revisions
Jump to navigation
Jump to search
(→Fields) |
(→Fields) |
||
| Line 148: | Line 148: | ||
|- | |- | ||
| Original | | Original | ||
| INTEGER | | INTEGER | ||
| | | | ||
| Line 166: | Line 161: | ||
| | | | ||
| Beats Per Minute | | Beats Per Minute | ||
|- | |- | ||
| SignType | | SignType | ||
Revision as of 00:29, 24 January 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 |
