show tables; desc actor; desc borrow; desc director; desc genre; desc movie; desc moviegenre; desc person; +---------------------------+ | Tables_in_MovieCollection | +---------------------------+ | actor | | borrow | | director | | genre | | movie | | moviegenre | | person | +---------------------------+ 7 rows in set (0.00 sec) +-----------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------+------+-----+---------+-------+ | movie_id | int(11) | NO | | NULL | | | person_id | int(11) | NO | | NULL | | +-----------+---------+------+-----+---------+-------+ 2 rows in set (0.00 sec) +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | movie_id | int(11) | NO | | NULL | | | person_id | int(11) | NO | | NULL | | | checkout | datetime | NO | | NULL | | | checkin | datetime | YES | | NULL | | | comments | varchar(200) | YES | | NULL | | +-----------+------------------+------+-----+---------+----------------+ 6 rows in set (0.00 sec) +-----------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------+------+-----+---------+-------+ | movie_id | int(11) | NO | | NULL | | | person_id | int(11) | NO | | NULL | | +-----------+---------+------+-----+---------+-------+ 2 rows in set (0.00 sec) +-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(20) | NO | | NULL | | | description | varchar(200) | YES | | NULL | | +-------------+------------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | title | varchar(50) | NO | | NULL | | | acquired | datetime | YES | | NULL | | | borrow_id | int(11) | YES | | NULL | | +-----------+------------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) +----------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------+------+-----+---------+-------+ | movie_id | int(11) | NO | | NULL | | | genre_id | int(11) | NO | | NULL | | +----------+---------+------+-----+---------+-------+ 2 rows in set (0.00 sec) +--------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | first | varchar(20) | NO | | NULL | | | middle | varchar(20) | NO | | NULL | | | last | varchar(20) | NO | | NULL | | | suffix | varchar(20) | NO | | NULL | | +--------+------------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec)