mysql> desc authors;
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| authors_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| authors_name | varchar(255) | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)
mysql> desc books;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| book_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| heading_id | int(11) unsigned | NO | | NULL | |
| book_name | varchar(255) | NO | | NULL | |
| book_img | varchar(255) | NO | | NULL | |
+------------+------------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)
mysql> desc books_authors;
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| bh_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| a_id | int(11) unsigned | NO | | NULL | |
| b_id | int(11) unsigned | NO | | NULL | |
+-------+------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)