Table .PUBLIC.BOOK 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
PUBLISHER char 4
PUBLISHER.ID FK_PUBLISHER
ID char 6
TITLE varchar 512
AUTHOR varchar 512  √  null
ISSUE_DATE date 8  √  null
UPDATE_DATE timestamp 12
CREATE_DATE timestamp 12

Table contained 100 rows at –Ø 1 11 13:01 JST 2007

Indexes:
Column(s) Type Sort Constraint Name
PUBLISHER + ID Primary key Asc/Asc SYS_IDX_64
PUBLISHER Performance Asc SYS_IDX_65

Close relationships: