ArtistsSongs table
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 | 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.) |