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>