Table library.borrower Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
cardNo int 10  √ 
borrowed_book.cardNo borrowed_book_ibfk_3 R
firstName varchar 32
middleName varchar 32  √  null
lastName varchar 32
address int 10  √  null
address.addressId borrower_ibfk_1 R
phone varchar 16  √  null

Table contained 30 rows at Mon Aug 16 17:34 MDT 2010

Indexes:
Column(s) Type Sort Constraint Name
cardNo Primary key Asc PRIMARY
address Performance Asc address
lastName + firstName Performance Asc/Asc lastName

Close relationships  within of separation: