Lists table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m ({{DatabaseTablesList}} and formatting) |
||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | |||
== Fields == | == Fields == | ||
{| border="1" | {| border="1" | ||
| Line 12: | Line 13: | ||
| | | | ||
|- | |- | ||
| IDListType | | '''IDListType''' | ||
| INTEGER | | INTEGER | ||
| 1=Tempo, 2=Mood, 3=Occasion, 4=Quality | | 1=Tempo, 2=Mood, 3=Occasion, 4=Quality | ||
| Type of Classification | | Type of Classification | ||
|- | |- | ||
| TextData | | '''TextData''' | ||
| TEXT | | TEXT | ||
| | | | ||
| Contains the actual Tempo, Mood, Occasion or Quality. Listed as subnodes of the selected Classification | | Contains the actual Tempo, Mood, Occasion or Quality. Listed as subnodes of the selected Classification | ||
|- | |- | ||
| SortOrder | | '''SortOrder''' | ||
| INTEGER | | INTEGER | ||
| | | | ||
| The sortorder of the TextData in the tree | | The sortorder of the TextData in the tree | ||
|} | |} | ||
Latest revision as of 15:58, 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.) | |
| IDListType | INTEGER | 1=Tempo, 2=Mood, 3=Occasion, 4=Quality | Type of Classification |
| TextData | TEXT | Contains the actual Tempo, Mood, Occasion or Quality. Listed as subnodes of the selected Classification | |
| SortOrder | INTEGER | The sortorder of the TextData in the tree |
