CREATE TABLE `borrow` (
 `borrow_id` int(11) NOT NULL AUTO_INCREMENT,
 `book_id` int(11) NOT NULL COMMENT 'is a foreign key of book',
 `member_id` int(11) NOT NULL COMMENT 'is a foreign key of member',
 PRIMARY KEY (`borrow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1