Table library.book_author Generated by
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
isbn bigint 19 0
book.isbn book_author_ibfk_1 R
authorId int 10 0
author.authorId Implied Constraint R
FK intentionally omitted to show an implied relationship

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

Column(s) Type Sort Constraint Name
isbn + authorId Primary key Asc/Asc PRIMARY

Close relationships  within of separation: