Untitled

mysql> describe magnatune_albums ;+------------+----------------+------+-----+---------+----------------+| Field      | Type           | Null | Key | Default | Extra          |+------------+----------------+------+-----+---------+----------------+| id         | int(11)        | NO   | PRI | NULL    | auto_increment || name       | varchar(255)   | YES  |     | NULL    |                || year       | int(11)        | YES  |     | NULL    |                || artist_id  | int(11)        | YES  |     | NULL    |                || genre      | varchar(255)   | YES  |     | NULL    |                || album_code | varchar(255)   | YES  |     | NULL    |                || cover_url  | varbinary(255) | YES  |     | NULL    |                |+------------+----------------+------+-----+---------+----------------+7 rows in set (0.00 sec)mysql> describe magnatune_artists ;+-------------+----------------+------+-----+---------+----------------+| Field       | Type           | Null | Key | Default | Extra          |+-------------+----------------+------+-----+---------+----------------+| id          | int(11)        | NO   | PRI | NULL    | auto_increment || name        | varchar(255)   | YES  |     | NULL    |                || artist_page | varbinary(255) | YES  |     | NULL    |                || description | varchar(255)   | YES  |     | NULL    |                || photo_url   | varbinary(255) | YES  |     | NULL    |                |+-------------+----------------+------+-----+---------+----------------+5 rows in set (0.00 sec)mysql> describe magnatune_tracks;+--------------+----------------+------+-----+---------+----------------+| Field        | Type           | Null | Key | Default | Extra          |+--------------+----------------+------+-----+---------+----------------+| id           | int(11)        | NO   | PRI | NULL    | auto_increment || name         | varchar(255)   | YES  |     | NULL    |                || track_number | int(11)        | YES  |     | NULL    |                || length       | int(11)        | YES  |     | NULL    |                || album_id     | int(11)        | YES  |     | NULL    |                || artist_id    | int(11)        | YES  |     | NULL    |                || preview_lofi | varbinary(255) | YES  |     | NULL    |                || preview_hifi | varbinary(255) | YES  |     | NULL    |                |+--------------+----------------+------+-----+---------+----------------+8 rows in set (0.00 sec)mysql>