ArtistsSongs table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
| PersonType | | PersonType | ||
| INTEGER | | INTEGER | ||
| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist | | 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 8 = Publisher | ||
| Specifies the PersonType relation between the Song and the "Artist" | | Specifies the PersonType relation between the Song and the "Artist" | ||
|- | |- | ||
Revision as of 19:14, 9 June 2020
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, 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.) |
