Artists table
Fields
| Name | Value Type | Possible Values | Description |
|---|---|---|---|
| ID | INTEGER | AUTOINCREMENT (1 to inf.) | |
| Artist | TEXT | Name of the "Person". (This field should be named Person.) | |
| Comment | TEXT | ||
| Tracks | INTEGER | Number of tracks where the "Person" appears as Artist. | |
| Albums | INTEGER | Number of tracks where the "Person" appears as AlbumArtist. | |
| Authors | INTEGER | Number of tracks where the "Person" appears as Composer. | |
| Conducts | INTEGER | Number of tracks where the "Person" appears as Conductor. | |
| Lyrics | INTEGER | Number of tracks where the "Person" appears as Lyricist. |
