Medias table: Difference between revisions
Jump to navigation
Jump to search
(→Fields) |
m (Fixed asterisks in the wrong place) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | |||
== Fields == | == Fields == | ||
{| border="1" | {| border="1" | ||
| Line 7: | Line 8: | ||
! Description | ! Description | ||
|- | |- | ||
| ''' | | '''IDMedia''' | ||
| INTEGER | | INTEGER | ||
| | | | ||
| Internal MM ID number | | Internal MM ID number | ||
|- | |- | ||
| ''' | | '''SerialNumber''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''DriveType''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''Label''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''ShowLabel''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''Comment''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''IsAudioCD''' | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''Location''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''CDDBId''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''TOCData''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''CDDBQueryState''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''CDDBQueryResult''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''TurnedSN''' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | | ||
|- | |- | ||
| ''' | | '''DriveLetter''' | ||
| INTEGER | | INTEGER | ||
| | |||
| Ascii code of drive letter "A"=65 | |||
|- | |||
| '''MusicBrainzDiscId''' | |||
| TEXT* | |||
| | | | ||
| | | | ||
| Line 79: | Line 85: | ||
|} | |} | ||
( | (need more info in each) | ||
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)
