ArtistsAlbums table: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
 (→Fields)  | 
				m (Formatting)  | 
				||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}}  | |||
== Fields ==  | == Fields ==  | ||
{| border="1"  | {| border="1"  | ||
| Line 12: | Line 13: | ||
|    | |    | ||
|-  | |-  | ||
| IDArtist  | | '''IDArtist'''  | ||
| INTEGER    | | INTEGER    | ||
|    | |    | ||
| ID of the AlbumArtist. (ID of the "Artist" in the Artists table.)  | | ID of the AlbumArtist. (ID of the "Artist" in the Artists table.)  | ||
|-  | |-  | ||
| IDAlbum  | | '''IDAlbum'''  | ||
| INTEGER  | | INTEGER  | ||
|    | |    | ||
| ID of the Album. (ID of the Album in the Albums table.)  | | ID of the Album. (ID of the Album in the Albums table.)  | ||
|}  | |}  | ||
Latest revision as of 16:20, 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.) | |
| IDArtist | INTEGER | ID of the AlbumArtist. (ID of the "Artist" in the Artists table.) | |
| IDAlbum | INTEGER | ID of the Album. (ID of the Album in the Albums table.) |