Table library.address Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
addressId int 11  √ 
borrower.address borrower_ibfk_1
library_branch.address library_branch_ibfk_1
publisher.address publisher_ibfk_1
address1 varchar 50 Address line 1
address2 varchar 50  √  null Address line 2 (optional)
city varchar 30
state char 2
zip varchar 10 Dash req'd for zip+4

Analyzed at Mon Oct 30 19:58 MST 2006

Indexes:
Column(s) Type Sort Constraint Name
addressId Primary key Asc PRIMARY

Close relationships  within one two degrees of separation :