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

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

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

Close relationships  within of separation: