ArtistsSongs table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(No difference)
|
Revision as of 21:46, 23 January 2008
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.) |
