books

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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)