library contains 36 columns - click on heading to sort:

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