ArtistsSongs table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m (Formatting) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | |||
== Fields == | == Fields == | ||
{| border="1" | {| border="1" | ||
| Line 12: | Line 13: | ||
| | | | ||
|- | |- | ||
| PersonType | | '''PersonType''' | ||
| INTEGER | | INTEGER | ||
| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 8 = Publisher | | 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 7=Actor, 8 = Publisher | ||
| Specifies the PersonType relation between the Song and the "Artist" | | Specifies the PersonType relation between the Song and the "Artist" | ||
|- | |- | ||
| IDArtist | | '''IDArtist''' | ||
| INTEGER | | INTEGER | ||
| | | | ||
| ID of the "Artist". (ID of the "Artist" in the Artists table.) | | ID of the "Artist". (ID of the "Artist" in the Artists table.) | ||
|- | |- | ||
| IDSong | | '''IDSong''' | ||
| INTEGER | | INTEGER | ||
| | | | ||
| ID of the Song. (ID of the Song in the Songs table.) | | ID of the Song. (ID of the Song in the Songs 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.) | |
| PersonType | INTEGER | 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 7=Actor, 8 = Publisher | Specifies the PersonType relation between the Song and the "Artist" |
| IDArtist | INTEGER | ID of the "Artist". (ID of the "Artist" in the Artists table.) | |
| IDSong | INTEGER | ID of the Song. (ID of the Song in the Songs table.) |
