SchemaSpy - Table library.author

Generated by
SchemaSpy

Legend:

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

authorId

int

10

√

book_author.authorId

Implied Constraint R

firstName

varchar

32

middleName

varchar

32

√

null

lastName

varchar

32

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

Indexes:

Column(s)	Type	Sort	Constraint Name
authorId	Primary key	Asc	PRIMARY
lastName	Performance	Asc	lastName