Medias table: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
 ({{DatabaseTablesList}} and capitalization)  | 
				m (Fixed asterisks in the wrong place)  | 
				||
| Line 63: | Line 63: | ||
|    | |    | ||
|-  | |-  | ||
| '''CDDBQueryResult'''  | | '''CDDBQueryResult'''  | ||
| TEXT  | | TEXT*  | ||
|    | |    | ||
|    | |    | ||
| Line 78: | Line 78: | ||
| Ascii code of drive letter "A"=65  | | Ascii code of drive letter "A"=65  | ||
|-  | |-  | ||
| '''MusicBrainzDiscId'''  | | '''MusicBrainzDiscId'''  | ||
| TEXT  | | TEXT*  | ||
|    | |    | ||
|    | |    | ||
Latest revision as of 16:13, 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 | 
|---|---|---|---|
| IDMedia | INTEGER | Internal MM ID number | |
| SerialNumber | TEXT | ||
| DriveType | TEXT | ||
| Label | TEXT | ||
| ShowLabel | TEXT | ||
| Comment | TEXT | ||
| IsAudioCD | INTEGER | ||
| Location | TEXT | ||
| CDDBId | TEXT | ||
| TOCData | TEXT | ||
| CDDBQueryState | TEXT | ||
| CDDBQueryResult | TEXT* | ||
| TurnedSN | TEXT | ||
| DriveLetter | INTEGER | Ascii code of drive letter "A"=65 | |
| MusicBrainzDiscId | TEXT* | 
(need more info in each)