Artists table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(→Fields) |
||
| Line 25: | Line 25: | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | Count of tracks where the "Person" appears as Artist. | ||
|- | |- | ||
| Albums | | Albums | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | Count of tracks where the "Person" appears as AlbumArtist. | ||
|- | |- | ||
| Authors | | Authors | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | Count of tracks where the "Person" appears as Composer. | ||
|- | |- | ||
| Conducts | | Conducts | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | Count of tracks where the "Person" appears as Conductor. | ||
|- | |- | ||
| Lyrics | | Lyrics | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | Count of tracks where the "Person" appears as Lyricist. | ||
|} | |} | ||
Revision as of 21:28, 23 January 2008
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 | Count of tracks where the "Person" appears as Artist. | |
| Albums | INTEGER | Count of tracks where the "Person" appears as AlbumArtist. | |
| Authors | INTEGER | Count of tracks where the "Person" appears as Composer. | |
| Conducts | INTEGER | Count of tracks where the "Person" appears as Conductor. | |
| Lyrics | INTEGER | Count of tracks where the "Person" appears as Lyricist. |
