Albums table: Difference between revisions
Jump to navigation
Jump to search
(→Fields) |
(Added asterisks for non IUNICODE fields) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | {{DatabaseTablesList}} | ||
== Fields == | == Fields == | ||
{| border="1" | {| border="1" | ||
| Line 14: | Line 13: | ||
| | | | ||
|- | |- | ||
| Artist | | '''Artist''' | ||
| TEXT | | TEXT | ||
| | | | ||
| The name(s) of the AlbumArtist(s) | | The name(s) of the AlbumArtist(s) | ||
|- | |- | ||
| ''Album'' | | '''Album''' | ||
| TEXT | | TEXT | ||
| | | | ||
| The Name of the Album | | The Name of the Album | ||
|- | |- | ||
| Year | | '''Year''' | ||
| INTEGER | | INTEGER | ||
| | | 20100521 | ||
| | | Was not in use until version 5.0. | ||
The first 4 digits are the year, and the last 4 digits are the month and then day. The example is May 21, 2010. | |||
|- | |- | ||
| Comment | | '''Comment''' | ||
| TEXT | | TEXT | ||
| | | | ||
| Album level comment | | Album level comment | ||
|- | |- | ||
| Tracks | | '''Tracks''' | ||
| INTEGER | | INTEGER | ||
| Counter by trigger (0 to inf.) | | Counter by trigger (0 to inf.) | ||
| Count of Songs linked to the Album | | Count of Songs linked to the Album | ||
|- | |||
| '''MBGID''' | |||
| TEXT* | |||
| bfd86854-99cb-496e-b7c4-1c58c928ba1d | |||
| ID of the matching release on MusicBrainz. | |||
Added in version 5.0 | |||
|- | |||
| '''MBRGGID''' | |||
| TEXT* | |||
| 7a83ecca-b88e-3eab-b769-8d72dde013f7 | |||
| ID of the matching release group on MusicBrainz. | |||
Added in version 5.0 | |||
|- | |||
| '''LastTimeShown''' | |||
| REAL | |||
| | |||
| Formatted as the number of days since December 30, 1899. | |||
Added in version 5.0 | |||
|- | |||
| '''TVDBID''' | |||
| INTEGER | |||
| | |||
| Added in version 5.0 | |||
|- | |||
| '''RATING''' | |||
| INTEGER | |||
| | |||
| Added in version 5.1 | |||
|} | |} | ||
Latest revision as of 16:21, 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.) | |
| Artist | TEXT | The name(s) of the AlbumArtist(s) | |
| Album | TEXT | The Name of the Album | |
| Year | INTEGER | 20100521 | Was not in use until version 5.0.
The first 4 digits are the year, and the last 4 digits are the month and then day. The example is May 21, 2010. |
| Comment | TEXT | Album level comment | |
| Tracks | INTEGER | Counter by trigger (0 to inf.) | Count of Songs linked to the Album |
| MBGID | TEXT* | bfd86854-99cb-496e-b7c4-1c58c928ba1d | ID of the matching release on MusicBrainz.
Added in version 5.0 |
| MBRGGID | TEXT* | 7a83ecca-b88e-3eab-b769-8d72dde013f7 | ID of the matching release group on MusicBrainz.
Added in version 5.0 |
| LastTimeShown | REAL | Formatted as the number of days since December 30, 1899.
Added in version 5.0 | |
| TVDBID | INTEGER | Added in version 5.0 | |
| RATING | INTEGER | Added in version 5.1 |
Connections
- Songs table
- Artists table (via the ArtistsAlbums table)
- ...
