SchemaSpy Analysis of .PUBLIC - Columns Generated by
SchemaSpy
Generated by SchemaSpy on –Ø 1 11 13:01 JST 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
.PUBLIC contains 20 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
ID PUBLISHER char 4
BOOK.PUBLISHER FK_PUBLISHER
PUBLISHER BOOK char 4
PUBLISHER.ID FK_PUBLISHER
ID BOOK char 6
INSERT_DATE IDENTITY_TABLE date 8  √  null
ISSUE_DATE BOOK date 8  √  null
ARTIST_ID PAINTING integer 4
ARTIST.ID FK_ARTIST_PAINTING
GALLERY_ID PAINTING integer 4
GALLERY.ID FK_ARTIST_GALLERY
ID ARTIST integer 4  √ 
PAINTING.ARTIST_ID FK_ARTIST_PAINTING
GALLERY.ID Implied Constraint
ID GALLERY integer 4  √ 
ARTIST.ID Implied Constraint
IDENTITY_TABLE.ID Implied Constraint
PAINTING.GALLERY_ID FK_ARTIST_GALLERY
ID IDENTITY_TABLE integer 4  √ 
GALLERY.ID Implied Constraint
VOLUMES PUBLISHER integer 4
CREATE_DATE BOOK timestamp 12
CREATE_DATE PUBLISHER timestamp 12
UPDATE_DATE BOOK timestamp 12
UPDATE_DATE PUBLISHER timestamp 12
AUTHOR BOOK varchar 512  √  null
NAME ARTIST varchar 512
NAME GALLERY varchar 512
NAME PUBLISHER varchar 512
TITLE BOOK varchar 512