ListsSongs table: Difference between revisions
Jump to navigation
Jump to search
(→Fields) |
m ({{DatabaseTablesList}} and formatting) |
||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | |||
== Fields == | == Fields == | ||
{| border="1" | {| border="1" | ||
| Line 12: | Line 13: | ||
| | | | ||
|- | |- | ||
| IDSong | | '''IDSong''' | ||
| INTEGER | | INTEGER | ||
| | | | ||
| ID of the Song. (ID of the Song in the Songs table.) | | ID of the Song. (ID of the Song in the Songs table.) | ||
|- | |- | ||
| IDListType | | '''IDListType''' | ||
| INTEGER | | INTEGER | ||
| 1=Tempo, 2=Mood, 3=Occasion, 4=Quality | | 1=Tempo, 2=Mood, 3=Occasion, 4=Quality | ||
| ID of the ListType. (IDListType in the Lists table.) | | ID of the ListType. (IDListType in the Lists table.) | ||
|- | |- | ||
| IDList | | '''IDList''' | ||
| INTEGER | | INTEGER | ||
| | | | ||
| ID of the List. (ID of the List in the Lists table.) | | ID of the List. (ID of the List in the Lists table.) | ||
|} | |} | ||
Latest revision as of 15:59, 11 April 2024
- [Database Structure]
- Albums
- Artists
- ArtistsAlbums
- ArtistsSongs
- Covers
- DBInfo
- DeviceFilters
- DeviceTracks
- Devices
- Downloads
- Filters
- Folders
- FoldersHier
- Genres
- GenresSongs
- LastTreePath
- Lists
- ListsSongs
- Medias
- OrganizeRules
- PathProcessing
- Pinned
- Played
- PlaylistSongs
- Playlists
- PodcastDirs
- PodcastEpisodes
- Podcasts
- Radio
- RemoteClients
- Songs
- SynchAlbum
- SynchArtist
- SynchLocation
- SynchPlaylist
- SynchPodcast
- URLRequestCache
Fields
| Name | Value Type | Possible Values | Description |
|---|---|---|---|
| ID | INTEGER | AUTOINCREMENT (1 to inf.) | |
| IDSong | INTEGER | ID of the Song. (ID of the Song in the Songs table.) | |
| IDListType | INTEGER | 1=Tempo, 2=Mood, 3=Occasion, 4=Quality | ID of the ListType. (IDListType in the Lists table.) |
| IDList | INTEGER | ID of the List. (ID of the List in the Lists table.) |
