library contains 36 columns - click on heading to sort:

Column	Table	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
address	borrower	int	11	√		null		address.addressId borrower_ibfk_1
address	library_branch	int	11					address.addressId library_branch_ibfk_1
address	publisher	int	11	√		null		address.addressId publisher_ibfk_1
address1	address	varchar	50						Address line 1
address2	address	varchar	50	√		null			Address line 2 (optional)
addressId	address	int	11		√		borrower.address borrower_ibfk_1 library_branch.address library_branch_ibfk_1 publisher.address publisher_ibfk_1
authorId	author	int	11		√		book_author.authorId Implied Constraint
authorId	book_author	int	11			0		author.authorId Implied Constraint	FK intentionally omitted to show an implied relationship
borrowDate	borrowed_book	date	10
branchId	book_location	int	11					library_branch.branchId book_location_ibfk_2
branchId	borrowed_book	int	11					library_branch.branchId borrowed_book_ibfk_2
branchId	library_branch	int	11		√		book_location.branchId book_location_ibfk_2 borrowed_book.branchId borrowed_book_ibfk_2
cardNo	borrowed_book	int	11					borrower.cardNo borrowed_book_ibfk_3
cardNo	borrower	int	11		√		borrowed_book.cardNo borrowed_book_ibfk_3
city	address	varchar	30
dueDate	borrowed_book	date	10
firstName	author	varchar	32
firstName	borrower	varchar	32
isbn	book	bigint	20			0	book_author.isbn book_author_ibfk_1 book_location.isbn book_location_ibfk_1 borrowed_book.isbn borrowed_book_ibfk_1
isbn	book_author	bigint	20			0		book.isbn book_author_ibfk_1
isbn	book_location	bigint	20			0		book.isbn book_location_ibfk_1
isbn	borrowed_book	bigint	20			0		book.isbn borrowed_book_ibfk_1
lastName	author	varchar	32
lastName	borrower	varchar	32
middleName	author	varchar	32	√		null
middleName	borrower	varchar	32	√		null
name	library_branch	varchar	64
name	publisher	varchar	64
numCopies	book_location	int	11
phone	borrower	varchar	16	√		null
phone	publisher	varchar	16	√		null
publisherId	book	int	11		√			publisher.publisherId book_ibfk_1
publisherId	publisher	int	11		√		book.publisherId book_ibfk_1
state	address	char	2
title	book	varchar	64
zip	address	varchar	10						Dash req'd for zip+4